PREVIEW / futures_1hour / 2025-01-06
file: by_date/futures_1hour/2025/2025-01-06.parquet size: 69 KB rows: 2,132
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 |
|---|---|---|---|---|---|---|---|
| 2025-01-06 00:00:00 | ES | Futures | 6140.24 | 6146.4 | 6139.73 | 6144.35 | 3606.0 |
| 2025-01-06 01:00:00 | ES | Futures | 6144.6 | 6148.96 | 6143.06 | 6147.68 | 3479.0 |
| 2025-01-06 02:00:00 | ES | Futures | 6147.68 | 6153.06 | 6145.63 | 6150.75 | 5686.0 |
| 2025-01-06 03:00:00 | ES | Futures | 6151.01 | 6160.75 | 6149.99 | 6159.98 | 12344.0 |
| 2025-01-06 04:00:00 | ES | Futures | 6159.98 | 6171.27 | 6159.73 | 6170.75 | 14430.0 |
| 2025-01-06 05:00:00 | ES | Futures | 6170.75 | 6174.6 | 6166.65 | 6168.45 | 13180.0 |
| 2025-01-06 06:00:00 | ES | Futures | 6168.19 | 6187.67 | 6160.75 | 6186.9 | 34895.0 |
| 2025-01-06 07:00:00 | ES | Futures | 6186.65 | 6194.6 | 6181.78 | 6189.21 | 23788.0 |
| 2025-01-06 08:00:00 | ES | Futures | 6189.21 | 6195.36 | 6185.62 | 6194.85 | 28964.0 |
| 2025-01-06 09:00:00 | ES | Futures | 6195.11 | 6207.41 | 6169.21 | 6203.57 | 250629.0 |
| 2025-01-06 10:00:00 | ES | Futures | 6203.57 | 6217.93 | 6201.26 | 6214.08 | 205257.0 |
| 2025-01-06 11:00:00 | ES | Futures | 6214.34 | 6223.05 | 6210.75 | 6220.23 | 99925.0 |
| 2025-01-06 12:00:00 | ES | Futures | 6220.23 | 6220.23 | 6197.67 | 6201.26 | 117275.0 |
| 2025-01-06 13:00:00 | ES | Futures | 6201.52 | 6202.03 | 6178.7 | 6179.73 | 158591.0 |
| 2025-01-06 14:00:00 | ES | Futures | 6179.73 | 6181.52 | 6164.6 | 6165.37 | 159606.0 |
| 2025-01-06 15:00:00 | ES | Futures | 6165.11 | 6177.42 | 6157.16 | 6176.14 | 237982.0 |
| 2025-01-06 16:00:00 | ES | Futures | 6176.14 | 6182.29 | 6175.62 | 6182.03 | 56265.0 |
| 2025-01-06 18:00:00 | ES | Futures | 6181.78 | 6185.62 | 6178.7 | 6179.47 | 6315.0 |
| 2025-01-06 19:00:00 | ES | Futures | 6179.21 | 6181.01 | 6174.85 | 6177.16 | 5877.0 |
| 2025-01-06 20:00:00 | ES | Futures | 6176.91 | 6177.93 | 6172.8 | 6176.65 | 6164.0 |
| 2025-01-06 21:00:00 | ES | Futures | 6176.91 | 6180.24 | 6169.98 | 6170.5 | 5113.0 |
| 2025-01-06 22:00:00 | ES | Futures | 6170.75 | 6174.6 | 6166.65 | 6174.34 | 4759.0 |
| 2025-01-06 23:00:00 | ES | Futures | 6174.34 | 6174.6 | 6169.73 | 6169.73 | 3808.0 |
| 2025-01-06 00:00:00 | NQ | Futures | 22155.75 | 22185.09 | 22152.92 | 22171.96 | 3255.0 |
| 2025-01-06 01:00:00 | NQ | Futures | 22172.48 | 22188.95 | 22162.7 | 22182.51 | 2935.0 |
| 2025-01-06 02:00:00 | NQ | Futures | 22182.25 | 22211.08 | 22173.25 | 22198.98 | 4979.0 |
| 2025-01-06 03:00:00 | NQ | Futures | 22198.98 | 22260.49 | 22198.21 | 22254.05 | 8472.0 |
| 2025-01-06 04:00:00 | NQ | Futures | 22253.02 | 22309.9 | 22251.74 | 22306.3 | 8638.0 |
| 2025-01-06 05:00:00 | NQ | Futures | 22305.78 | 22330.74 | 22291.37 | 22307.84 | 7847.0 |
| 2025-01-06 06:00:00 | NQ | Futures | 22307.07 | 22384.01 | 22277.99 | 22368.57 | 16703.0 |
| 2025-01-06 07:00:00 | NQ | Futures | 22368.83 | 22399.97 | 22349.02 | 22373.98 | 11607.0 |
| 2025-01-06 08:00:00 | NQ | Futures | 22373.72 | 22390.45 | 22344.9 | 22388.65 | 14183.0 |
| 2025-01-06 09:00:00 | NQ | Futures | 22388.65 | 22490.81 | 22277.73 | 22460.7 | 91773.0 |
| 2025-01-06 10:00:00 | NQ | Futures | 22459.42 | 22536.11 | 22420.3 | 22512.17 | 81308.0 |
| 2025-01-06 11:00:00 | NQ | Futures | 22512.94 | 22540.22 | 22486.44 | 22499.82 | 45205.0 |
| 2025-01-06 12:00:00 | NQ | Futures | 22499.56 | 22511.92 | 22408.46 | 22434.97 | 51229.0 |
| 2025-01-06 13:00:00 | NQ | Futures | 22435.48 | 22436.26 | 22339.24 | 22345.15 | 55663.0 |
| 2025-01-06 14:00:00 | NQ | Futures | 22344.64 | 22361.62 | 22293.94 | 22295.74 | 51687.0 |
| 2025-01-06 15:00:00 | NQ | Futures | 22295.74 | 22395.34 | 22283.91 | 22389.68 | 67310.0 |
| 2025-01-06 16:00:00 | NQ | Futures | 22389.68 | 22426.48 | 22389.16 | 22420.56 | 17986.0 |
| 2025-01-06 18:00:00 | NQ | Futures | 22421.33 | 22436.77 | 22408.46 | 22411.55 | 3675.0 |
| 2025-01-06 19:00:00 | NQ | Futures | 22410.01 | 22422.1 | 22389.16 | 22401.0 | 3744.0 |
| 2025-01-06 20:00:00 | NQ | Futures | 22401.0 | 22412.58 | 22385.04 | 22408.46 | 3479.0 |
| 2025-01-06 21:00:00 | NQ | Futures | 22407.69 | 22425.7 | 22372.43 | 22376.55 | 3889.0 |
| 2025-01-06 22:00:00 | NQ | Futures | 22377.32 | 22391.22 | 22353.9 | 22386.33 | 5212.0 |
| 2025-01-06 23:00:00 | NQ | Futures | 22386.33 | 22386.84 | 22357.25 | 22358.79 | 2751.0 |
| 2025-01-06 00:00:00 | YM | Futures | 44232.7 | 44269.8 | 44228.6 | 44258.4 | 367.0 |
| 2025-01-06 01:00:00 | YM | Futures | 44260.5 | 44286.2 | 44254.3 | 44281.1 | 477.0 |
| 2025-01-06 02:00:00 | YM | Futures | 44278.0 | 44309.9 | 44264.6 | 44290.3 | 956.0 |
| 2025-01-06 03:00:00 | YM | Futures | 44293.4 | 44328.4 | 44272.9 | 44320.2 | 1443.0 |
> showing 50 of 2,132 rows — these rows as CSV