PREVIEW / futures_1hour / 2024-01-15
file: by_date/futures_1hour/2024/2024-01-15.parquet size: 55 KB rows: 1,676
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-01-15 00:00:00 | ES | Futures | 5176.82 | 5176.82 | 5173.32 | 5174.13 | 2880.0 |
| 2024-01-15 01:00:00 | ES | Futures | 5174.13 | 5179.5 | 5174.13 | 5179.23 | 4842.0 |
| 2024-01-15 02:00:00 | ES | Futures | 5179.23 | 5181.65 | 5174.94 | 5175.2 | 7557.0 |
| 2024-01-15 03:00:00 | ES | Futures | 5175.2 | 5180.04 | 5168.22 | 5168.22 | 14362.0 |
| 2024-01-15 04:00:00 | ES | Futures | 5168.49 | 5176.01 | 5165.27 | 5169.83 | 12503.0 |
| 2024-01-15 05:00:00 | ES | Futures | 5170.1 | 5172.52 | 5167.15 | 5170.91 | 7678.0 |
| 2024-01-15 06:00:00 | ES | Futures | 5171.17 | 5171.17 | 5166.07 | 5168.76 | 8341.0 |
| 2024-01-15 07:00:00 | ES | Futures | 5168.76 | 5171.44 | 5166.61 | 5167.41 | 8397.0 |
| 2024-01-15 08:00:00 | ES | Futures | 5167.41 | 5170.1 | 5164.19 | 5167.68 | 10493.0 |
| 2024-01-15 09:00:00 | ES | Futures | 5167.68 | 5170.64 | 5165.0 | 5168.76 | 17945.0 |
| 2024-01-15 10:00:00 | ES | Futures | 5169.03 | 5171.44 | 5168.22 | 5171.17 | 13726.0 |
| 2024-01-15 11:00:00 | ES | Futures | 5171.17 | 5171.44 | 5168.22 | 5168.76 | 7967.0 |
| 2024-01-15 12:00:00 | ES | Futures | 5168.76 | 5171.44 | 5167.95 | 5171.44 | 5700.0 |
| 2024-01-15 18:00:00 | ES | Futures | 5169.29 | 5171.44 | 5165.53 | 5166.07 | 7891.0 |
| 2024-01-15 19:00:00 | ES | Futures | 5166.07 | 5166.07 | 5155.6 | 5156.13 | 12987.0 |
| 2024-01-15 20:00:00 | ES | Futures | 5155.87 | 5162.58 | 5153.72 | 5160.43 | 11381.0 |
| 2024-01-15 21:00:00 | ES | Futures | 5160.43 | 5162.85 | 5158.01 | 5159.63 | 6347.0 |
| 2024-01-15 22:00:00 | ES | Futures | 5159.89 | 5159.89 | 5155.33 | 5157.48 | 5781.0 |
| 2024-01-15 23:00:00 | ES | Futures | 5157.48 | 5158.55 | 5155.33 | 5157.48 | 3384.0 |
| 2024-01-15 00:00:00 | NQ | Futures | 18432.76 | 18432.76 | 18420.56 | 18423.81 | 1840.0 |
| 2024-01-15 01:00:00 | NQ | Futures | 18423.27 | 18456.36 | 18423.0 | 18451.2 | 3784.0 |
| 2024-01-15 02:00:00 | NQ | Futures | 18451.47 | 18468.29 | 18436.56 | 18439.54 | 5306.0 |
| 2024-01-15 03:00:00 | NQ | Futures | 18439.54 | 18465.85 | 18407.0 | 18407.27 | 7900.0 |
| 2024-01-15 04:00:00 | NQ | Futures | 18407.81 | 18425.44 | 18392.35 | 18400.49 | 7104.0 |
| 2024-01-15 05:00:00 | NQ | Futures | 18400.76 | 18414.05 | 18394.25 | 18408.62 | 3732.0 |
| 2024-01-15 06:00:00 | NQ | Futures | 18409.71 | 18411.61 | 18383.94 | 18407.54 | 4637.0 |
| 2024-01-15 07:00:00 | NQ | Futures | 18407.0 | 18421.1 | 18398.32 | 18401.57 | 4838.0 |
| 2024-01-15 08:00:00 | NQ | Futures | 18401.57 | 18409.71 | 18389.37 | 18399.13 | 4438.0 |
| 2024-01-15 09:00:00 | NQ | Futures | 18399.4 | 18405.37 | 18372.82 | 18390.45 | 13739.0 |
| 2024-01-15 10:00:00 | NQ | Futures | 18391.0 | 18416.49 | 18377.43 | 18414.86 | 12300.0 |
| 2024-01-15 11:00:00 | NQ | Futures | 18414.86 | 18419.2 | 18399.67 | 18400.49 | 8582.0 |
| 2024-01-15 12:00:00 | NQ | Futures | 18401.03 | 18413.23 | 18392.35 | 18409.44 | 6837.0 |
| 2024-01-15 18:00:00 | NQ | Futures | 18399.67 | 18404.01 | 18369.84 | 18371.74 | 5316.0 |
| 2024-01-15 19:00:00 | NQ | Futures | 18372.28 | 18373.37 | 18323.74 | 18325.63 | 9084.0 |
| 2024-01-15 20:00:00 | NQ | Futures | 18325.09 | 18350.59 | 18313.7 | 18345.16 | 8575.0 |
| 2024-01-15 21:00:00 | NQ | Futures | 18345.16 | 18352.48 | 18331.06 | 18336.21 | 5081.0 |
| 2024-01-15 22:00:00 | NQ | Futures | 18335.94 | 18338.38 | 18316.14 | 18326.18 | 4394.0 |
| 2024-01-15 23:00:00 | NQ | Futures | 18326.72 | 18332.96 | 18319.13 | 18328.62 | 2843.0 |
| 2024-01-15 00:00:00 | YM | Futures | 40621.6 | 40622.7 | 40593.7 | 40598.0 | 501.0 |
| 2024-01-15 01:00:00 | YM | Futures | 40598.0 | 40619.5 | 40598.0 | 40616.2 | 742.0 |
| 2024-01-15 02:00:00 | YM | Futures | 40616.2 | 40632.4 | 40569.0 | 40571.1 | 1784.0 |
| 2024-01-15 03:00:00 | YM | Futures | 40572.2 | 40603.4 | 40523.9 | 40524.9 | 2305.0 |
| 2024-01-15 04:00:00 | YM | Futures | 40523.9 | 40592.6 | 40503.5 | 40544.3 | 2631.0 |
| 2024-01-15 05:00:00 | YM | Futures | 40543.2 | 40576.5 | 40518.5 | 40541.1 | 5405.0 |
| 2024-01-15 06:00:00 | YM | Futures | 40542.1 | 40573.3 | 40518.5 | 40526.0 | 4454.0 |
| 2024-01-15 07:00:00 | YM | Futures | 40524.9 | 40572.2 | 40497.0 | 40541.1 | 9280.0 |
| 2024-01-15 08:00:00 | YM | Futures | 40541.1 | 40560.4 | 40487.4 | 40513.1 | 6175.0 |
| 2024-01-15 09:00:00 | YM | Futures | 40514.2 | 40567.9 | 40505.6 | 40563.6 | 4234.0 |
| 2024-01-15 10:00:00 | YM | Futures | 40562.5 | 40593.7 | 40558.2 | 40572.2 | 2737.0 |
| 2024-01-15 11:00:00 | YM | Futures | 40570.1 | 40589.4 | 40546.4 | 40556.1 | 1640.0 |
> showing 50 of 1,676 rows — these rows as CSV