Skip to content

Instantly share code, notes, and snippets.

@srikanthccv
Created June 28, 2023 03:41
Show Gist options
  • Save srikanthccv/01100f536ada68df07ef4c2e40b6fef0 to your computer and use it in GitHub Desktop.
Save srikanthccv/01100f536ada68df07ef4c2e40b6fef0 to your computer and use it in GitHub Desktop.

                                                        - │ 11887564887837025943 │ 2023-06-26 12:59:00 │ 104381 │ (prev point)
┌──────────fingerprint─┬──────────────────ts─┬──value─┐
│ 11887564887837025943 │ 2023-06-26 13:00:00 │ 104402 │
│ 11887564887837025943 │ 2023-06-26 13:01:00 │ 104461 │
│ 11887564887837025943 │ 2023-06-26 13:02:00 │ 104504 │
│ 11887564887837025943 │ 2023-06-26 13:03:00 │ 104532 │
│ 11887564887837025943 │ 2023-06-26 13:04:00 │ 104590 │
                                                        - │ 12004891769856389124 │ 2023-06-26 12:59:30 │  71476 │ (prev point)
│ 12004891769856389124 │ 2023-06-26 13:00:30 │  71521 │
│ 12004891769856389124 │ 2023-06-26 13:01:30 │  71588 │
│ 12004891769856389124 │ 2023-06-26 13:02:30 │  71618 │
│ 12004891769856389124 │ 2023-06-26 13:03:30 │  71631 │
│ 12004891769856389124 │ 2023-06-26 13:04:30 │  71675 │
└──────────────────────┴─────────────────────┴────────┘

Total interval:

((104590-104402) + (71675-71521))/300 = 1.14

per interval:
2023-06-26 13:00:00 - (104402-104381)/60 = 0.35
2023-06-26 13:00:30 - (71521-71476)/60 = 0.75
2023-06-26 13:01:00 - (104461-104402)/60 = 0.98333333333
2023-06-26 13:01:30 - (71588-71521)/60 = 1.1166666666666667
2023-06-26 13:02:00 - (104504-104461)/60 = 0.7166666666666667
2023-06-26 13:02:30 - (71618-71588)/60 = 0.5
2023-06-26 13:03:00 - (104532-104504)/60 = 0.4666666666666667
2023-06-26 13:03:30 - (71631-71618)/60 = 0.21666666666666667
2023-06-26 13:04:00 - (104590-104532)/60 = 0.9666666666666667
2023-06-26 13:04:30 - (71675-71631)/60 = 0.7333333333333333


@ankitnayan
Copy link

per interval:
2023-06-26 13:00:00 - (104402-104381)/60 = 0.35
2023-06-26 13:00:30 - (71521-71476)/60 = 0.75
2023-06-26 13:01:00 - (104461-104402)/60 = 0.98333333333
2023-06-26 13:01:30 - (71588-71521)/60 = 1.1166666666666667
2023-06-26 13:02:00 - (104504-104461)/60 = 0.7166666666666667
2023-06-26 13:02:30 - (71618-71588)/60 = 0.5
2023-06-26 13:03:00 - (104532-104504)/60 = 0.4666666666666667
2023-06-26 13:03:30 - (71631-71618)/60 = 0.21666666666666667
2023-06-26 13:04:00 - (104590-104532)/60 = 0.9666666666666667
2023-06-26 13:04:30 - (71675-71631)/60 = 0.7333333333333333

Why does it look like the output is 2 lines (each fingerprint having value at 1 min interval) overlapped at 30s displacement?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment