PREVIEW / futures_1hour / 2024-06-11
file: by_date/futures_1hour/2024/2024-06-11.parquet size: 60 KB rows: 1,866
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-06-11 00:00:00 | ES | Futures | 5694.31 | 5695.63 | 5692.98 | 5694.31 | 1679.0 |
| 2024-06-11 01:00:00 | ES | Futures | 5694.31 | 5698.29 | 5693.78 | 5698.29 | 3130.0 |
| 2024-06-11 02:00:00 | ES | Futures | 5698.02 | 5702.8 | 5698.02 | 5698.55 | 7281.0 |
| 2024-06-11 03:00:00 | ES | Futures | 5698.55 | 5699.88 | 5694.31 | 5695.63 | 10350.0 |
| 2024-06-11 04:00:00 | ES | Futures | 5695.63 | 5698.02 | 5687.94 | 5688.74 | 10416.0 |
| 2024-06-11 05:00:00 | ES | Futures | 5688.74 | 5691.39 | 5683.16 | 5683.16 | 14570.0 |
| 2024-06-11 06:00:00 | ES | Futures | 5683.16 | 5687.41 | 5679.98 | 5685.82 | 14072.0 |
| 2024-06-11 07:00:00 | ES | Futures | 5685.82 | 5686.08 | 5677.33 | 5683.16 | 21556.0 |
| 2024-06-11 08:00:00 | ES | Futures | 5683.16 | 5687.67 | 5680.78 | 5683.7 | 26555.0 |
| 2024-06-11 09:00:00 | ES | Futures | 5683.7 | 5686.61 | 5660.88 | 5668.57 | 216591.0 |
| 2024-06-11 10:00:00 | ES | Futures | 5668.57 | 5689.53 | 5666.45 | 5689.53 | 211051.0 |
| 2024-06-11 11:00:00 | ES | Futures | 5689.27 | 5690.59 | 5678.39 | 5680.25 | 166721.0 |
| 2024-06-11 12:00:00 | ES | Futures | 5680.51 | 5685.02 | 5677.33 | 5683.16 | 86527.0 |
| 2024-06-11 13:00:00 | ES | Futures | 5683.16 | 5695.37 | 5678.92 | 5694.84 | 117585.0 |
| 2024-06-11 14:00:00 | ES | Futures | 5694.84 | 5710.22 | 5691.92 | 5705.45 | 147055.0 |
| 2024-06-11 15:00:00 | ES | Futures | 5705.45 | 5714.73 | 5699.08 | 5713.41 | 197113.0 |
| 2024-06-11 16:00:00 | ES | Futures | 5713.41 | 5715.8 | 5709.69 | 5713.14 | 46178.0 |
| 2024-06-11 18:00:00 | ES | Futures | 5713.94 | 5715.0 | 5709.16 | 5715.0 | 4864.0 |
| 2024-06-11 19:00:00 | ES | Futures | 5714.73 | 5717.12 | 5713.41 | 5714.2 | 2906.0 |
| 2024-06-11 20:00:00 | ES | Futures | 5714.2 | 5715.53 | 5710.49 | 5711.82 | 3646.0 |
| 2024-06-11 21:00:00 | ES | Futures | 5712.08 | 5716.33 | 5711.82 | 5714.73 | 3455.0 |
| 2024-06-11 22:00:00 | ES | Futures | 5714.73 | 5715.8 | 5713.94 | 5715.0 | 2182.0 |
| 2024-06-11 23:00:00 | ES | Futures | 5715.0 | 5717.12 | 5714.47 | 5716.86 | 2295.0 |
| 2024-06-11 00:00:00 | NQ | Futures | 20427.68 | 20430.35 | 20422.86 | 20425.27 | 944.0 |
| 2024-06-11 01:00:00 | NQ | Futures | 20425.27 | 20443.73 | 20423.13 | 20442.93 | 2188.0 |
| 2024-06-11 02:00:00 | NQ | Futures | 20443.19 | 20451.75 | 20430.89 | 20433.3 | 3564.0 |
| 2024-06-11 03:00:00 | NQ | Futures | 20433.83 | 20441.32 | 20418.31 | 20432.76 | 5223.0 |
| 2024-06-11 04:00:00 | NQ | Futures | 20432.49 | 20439.98 | 20391.83 | 20399.05 | 6768.0 |
| 2024-06-11 05:00:00 | NQ | Futures | 20399.05 | 20411.89 | 20381.93 | 20382.74 | 7626.0 |
| 2024-06-11 06:00:00 | NQ | Futures | 20382.74 | 20400.93 | 20370.43 | 20394.51 | 7754.0 |
| 2024-06-11 07:00:00 | NQ | Futures | 20394.51 | 20395.84 | 20361.87 | 20385.95 | 10119.0 |
| 2024-06-11 08:00:00 | NQ | Futures | 20385.68 | 20403.07 | 20380.6 | 20391.56 | 11326.0 |
| 2024-06-11 09:00:00 | NQ | Futures | 20391.3 | 20423.93 | 20324.42 | 20364.81 | 94570.0 |
| 2024-06-11 10:00:00 | NQ | Futures | 20364.81 | 20476.36 | 20358.13 | 20473.96 | 88842.0 |
| 2024-06-11 11:00:00 | NQ | Futures | 20473.69 | 20476.9 | 20397.98 | 20413.23 | 69861.0 |
| 2024-06-11 12:00:00 | NQ | Futures | 20414.03 | 20449.08 | 20409.75 | 20436.24 | 36667.0 |
| 2024-06-11 13:00:00 | NQ | Futures | 20435.97 | 20508.46 | 20422.86 | 20506.06 | 53483.0 |
| 2024-06-11 14:00:00 | NQ | Futures | 20506.32 | 20578.82 | 20492.95 | 20555.28 | 61311.0 |
| 2024-06-11 15:00:00 | NQ | Futures | 20555.28 | 20595.14 | 20530.67 | 20589.25 | 65327.0 |
| 2024-06-11 16:00:00 | NQ | Futures | 20589.25 | 20605.84 | 20573.2 | 20595.14 | 15544.0 |
| 2024-06-11 18:00:00 | NQ | Futures | 20595.67 | 20607.98 | 20580.15 | 20605.84 | 3154.0 |
| 2024-06-11 19:00:00 | NQ | Futures | 20605.57 | 20618.94 | 20600.49 | 20604.77 | 2852.0 |
| 2024-06-11 20:00:00 | NQ | Futures | 20605.03 | 20607.98 | 20584.97 | 20592.73 | 3201.0 |
| 2024-06-11 21:00:00 | NQ | Futures | 20591.66 | 20614.93 | 20590.59 | 20603.43 | 3073.0 |
| 2024-06-11 22:00:00 | NQ | Futures | 20604.23 | 20608.51 | 20600.49 | 20603.96 | 1508.0 |
| 2024-06-11 23:00:00 | NQ | Futures | 20603.16 | 20616.0 | 20599.42 | 20615.73 | 1848.0 |
| 2024-06-11 00:00:00 | YM | Futures | 41274.7 | 41284.3 | 41257.8 | 41271.6 | 945.0 |
| 2024-06-11 01:00:00 | YM | Futures | 41271.6 | 41288.5 | 41266.2 | 41288.5 | 509.0 |
| 2024-06-11 02:00:00 | YM | Futures | 41289.6 | 41334.2 | 41289.6 | 41303.4 | 1337.0 |
| 2024-06-11 03:00:00 | YM | Futures | 41303.4 | 41317.2 | 41270.5 | 41271.6 | 1382.0 |
> showing 50 of 1,866 rows — these rows as CSV