PREVIEW / futures_1hour / 2024-02-13
file: by_date/futures_1hour/2024/2024-02-13.parquet size: 69 KB rows: 2,108
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-02-13 00:00:00 | ES | Futures | 5407.0 | 5409.41 | 5406.73 | 5408.07 | 2663.0 |
| 2024-02-13 01:00:00 | ES | Futures | 5408.34 | 5413.98 | 5408.34 | 5412.37 | 6153.0 |
| 2024-02-13 02:00:00 | ES | Futures | 5412.37 | 5414.25 | 5410.76 | 5414.25 | 6951.0 |
| 2024-02-13 03:00:00 | ES | Futures | 5414.25 | 5414.79 | 5397.6 | 5398.67 | 22634.0 |
| 2024-02-13 04:00:00 | ES | Futures | 5398.94 | 5402.16 | 5395.99 | 5398.13 | 19274.0 |
| 2024-02-13 05:00:00 | ES | Futures | 5398.13 | 5399.48 | 5392.76 | 5395.72 | 17405.0 |
| 2024-02-13 06:00:00 | ES | Futures | 5395.72 | 5398.67 | 5393.57 | 5394.64 | 12857.0 |
| 2024-02-13 07:00:00 | ES | Futures | 5394.64 | 5396.52 | 5390.08 | 5394.91 | 24958.0 |
| 2024-02-13 08:00:00 | ES | Futures | 5394.64 | 5401.89 | 5344.95 | 5348.18 | 155479.0 |
| 2024-02-13 09:00:00 | ES | Futures | 5348.18 | 5352.47 | 5335.28 | 5337.43 | 309637.0 |
| 2024-02-13 10:00:00 | ES | Futures | 5337.16 | 5353.28 | 5330.72 | 5345.22 | 287159.0 |
| 2024-02-13 11:00:00 | ES | Futures | 5345.49 | 5359.19 | 5345.49 | 5350.86 | 164094.0 |
| 2024-02-13 12:00:00 | ES | Futures | 5350.86 | 5353.55 | 5340.92 | 5342.54 | 129101.0 |
| 2024-02-13 13:00:00 | ES | Futures | 5342.54 | 5344.42 | 5332.33 | 5334.75 | 122061.0 |
| 2024-02-13 14:00:00 | ES | Futures | 5334.48 | 5334.75 | 5307.62 | 5310.57 | 234850.0 |
| 2024-02-13 15:00:00 | ES | Futures | 5310.57 | 5342.27 | 5303.59 | 5341.46 | 390812.0 |
| 2024-02-13 16:00:00 | ES | Futures | 5341.46 | 5344.15 | 5337.7 | 5343.07 | 75018.0 |
| 2024-02-13 18:00:00 | ES | Futures | 5344.15 | 5345.22 | 5339.85 | 5342.27 | 11208.0 |
| 2024-02-13 19:00:00 | ES | Futures | 5342.27 | 5343.07 | 5338.51 | 5342.27 | 9228.0 |
| 2024-02-13 20:00:00 | ES | Futures | 5342.0 | 5342.54 | 5338.24 | 5341.19 | 9476.0 |
| 2024-02-13 21:00:00 | ES | Futures | 5341.46 | 5343.34 | 5339.04 | 5339.85 | 7150.0 |
| 2024-02-13 22:00:00 | ES | Futures | 5339.85 | 5340.92 | 5338.78 | 5339.58 | 5095.0 |
| 2024-02-13 23:00:00 | ES | Futures | 5339.85 | 5341.73 | 5338.78 | 5340.92 | 4544.0 |
| 2024-02-13 00:00:00 | NQ | Futures | 19450.32 | 19465.51 | 19449.51 | 19461.71 | 2369.0 |
| 2024-02-13 01:00:00 | NQ | Futures | 19461.71 | 19483.68 | 19461.17 | 19475.0 | 4464.0 |
| 2024-02-13 02:00:00 | NQ | Futures | 19474.73 | 19482.33 | 19461.71 | 19477.17 | 4413.0 |
| 2024-02-13 03:00:00 | NQ | Futures | 19477.44 | 19486.94 | 19406.93 | 19408.56 | 12730.0 |
| 2024-02-13 04:00:00 | NQ | Futures | 19408.83 | 19424.56 | 19376.83 | 19384.96 | 13667.0 |
| 2024-02-13 05:00:00 | NQ | Futures | 19384.69 | 19389.3 | 19356.49 | 19366.52 | 10397.0 |
| 2024-02-13 06:00:00 | NQ | Futures | 19366.52 | 19374.93 | 19348.08 | 19354.59 | 7258.0 |
| 2024-02-13 07:00:00 | NQ | Futures | 19354.59 | 19358.11 | 19317.43 | 19345.64 | 16357.0 |
| 2024-02-13 08:00:00 | NQ | Futures | 19345.37 | 19385.78 | 19134.37 | 19159.32 | 66281.0 |
| 2024-02-13 09:00:00 | NQ | Futures | 19159.86 | 19184.0 | 19078.5 | 19173.69 | 133345.0 |
| 2024-02-13 10:00:00 | NQ | Futures | 19173.69 | 19300.89 | 19126.5 | 19230.38 | 135138.0 |
| 2024-02-13 11:00:00 | NQ | Futures | 19230.38 | 19284.62 | 19218.17 | 19224.68 | 77342.0 |
| 2024-02-13 12:00:00 | NQ | Futures | 19224.95 | 19231.73 | 19162.03 | 19173.15 | 66375.0 |
| 2024-02-13 13:00:00 | NQ | Futures | 19173.15 | 19199.19 | 19144.4 | 19154.71 | 55647.0 |
| 2024-02-13 14:00:00 | NQ | Futures | 19154.98 | 19155.25 | 19060.06 | 19069.82 | 91687.0 |
| 2024-02-13 15:00:00 | NQ | Futures | 19069.82 | 19181.02 | 19029.96 | 19180.2 | 111836.0 |
| 2024-02-13 16:00:00 | NQ | Futures | 19180.2 | 19204.07 | 19169.36 | 19201.09 | 19354.0 |
| 2024-02-13 18:00:00 | NQ | Futures | 19204.61 | 19206.78 | 19181.29 | 19191.59 | 5060.0 |
| 2024-02-13 19:00:00 | NQ | Futures | 19191.05 | 19194.58 | 19172.07 | 19187.25 | 4939.0 |
| 2024-02-13 20:00:00 | NQ | Futures | 19187.25 | 19190.51 | 19169.08 | 19179.39 | 4475.0 |
| 2024-02-13 21:00:00 | NQ | Futures | 19180.2 | 19188.61 | 19168.0 | 19172.61 | 2854.0 |
| 2024-02-13 22:00:00 | NQ | Futures | 19172.61 | 19181.56 | 19170.44 | 19176.68 | 2054.0 |
| 2024-02-13 23:00:00 | NQ | Futures | 19176.41 | 19187.53 | 19170.17 | 19183.73 | 1969.0 |
| 2024-02-13 00:00:00 | YM | Futures | 41702.1 | 41720.4 | 41702.1 | 41712.9 | 481.0 |
| 2024-02-13 01:00:00 | YM | Futures | 41714.0 | 41756.9 | 41712.9 | 41748.3 | 905.0 |
| 2024-02-13 02:00:00 | YM | Futures | 41747.3 | 41775.2 | 41730.1 | 41775.2 | 1747.0 |
| 2024-02-13 03:00:00 | YM | Futures | 41774.1 | 41778.4 | 41647.4 | 41679.6 | 3474.0 |
> showing 50 of 2,108 rows — these rows as CSV