PREVIEW / futures_1hour / 2024-03-25
file: by_date/futures_1hour/2024/2024-03-25.parquet size: 65 KB rows: 2,073
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-03-25 00:00:00 | ES | Futures | 5613.39 | 5613.39 | 5611.27 | 5612.33 | 2217.0 |
| 2024-03-25 01:00:00 | ES | Futures | 5612.6 | 5613.66 | 5609.68 | 5609.68 | 3713.0 |
| 2024-03-25 02:00:00 | ES | Futures | 5609.68 | 5610.21 | 5605.43 | 5608.35 | 6100.0 |
| 2024-03-25 03:00:00 | ES | Futures | 5608.35 | 5610.74 | 5605.96 | 5608.88 | 6381.0 |
| 2024-03-25 04:00:00 | ES | Futures | 5609.15 | 5616.84 | 5609.15 | 5613.13 | 14472.0 |
| 2024-03-25 05:00:00 | ES | Futures | 5613.13 | 5613.92 | 5604.37 | 5605.43 | 10920.0 |
| 2024-03-25 06:00:00 | ES | Futures | 5605.17 | 5606.49 | 5601.98 | 5602.78 | 15788.0 |
| 2024-03-25 07:00:00 | ES | Futures | 5602.51 | 5603.05 | 5595.09 | 5598.27 | 17550.0 |
| 2024-03-25 08:00:00 | ES | Futures | 5598.27 | 5601.98 | 5595.88 | 5600.66 | 22085.0 |
| 2024-03-25 09:00:00 | ES | Futures | 5600.39 | 5605.7 | 5596.94 | 5604.64 | 130671.0 |
| 2024-03-25 10:00:00 | ES | Futures | 5604.37 | 5611.0 | 5601.72 | 5608.09 | 119775.0 |
| 2024-03-25 11:00:00 | ES | Futures | 5608.35 | 5610.74 | 5605.43 | 5607.82 | 81545.0 |
| 2024-03-25 12:00:00 | ES | Futures | 5608.09 | 5609.41 | 5604.11 | 5606.23 | 65060.0 |
| 2024-03-25 13:00:00 | ES | Futures | 5606.49 | 5609.41 | 5602.78 | 5609.15 | 53641.0 |
| 2024-03-25 14:00:00 | ES | Futures | 5609.15 | 5612.33 | 5608.09 | 5610.74 | 47568.0 |
| 2024-03-25 15:00:00 | ES | Futures | 5610.74 | 5610.74 | 5598.54 | 5599.86 | 167015.0 |
| 2024-03-25 16:00:00 | ES | Futures | 5600.13 | 5604.11 | 5599.6 | 5603.84 | 38398.0 |
| 2024-03-25 18:00:00 | ES | Futures | 5603.84 | 5607.56 | 5603.84 | 5605.43 | 3992.0 |
| 2024-03-25 19:00:00 | ES | Futures | 5605.43 | 5607.82 | 5604.11 | 5607.02 | 2452.0 |
| 2024-03-25 20:00:00 | ES | Futures | 5607.02 | 5610.21 | 5605.96 | 5609.68 | 4460.0 |
| 2024-03-25 21:00:00 | ES | Futures | 5609.68 | 5610.74 | 5608.62 | 5608.88 | 4966.0 |
| 2024-03-25 22:00:00 | ES | Futures | 5608.88 | 5610.21 | 5607.82 | 5607.82 | 2605.0 |
| 2024-03-25 23:00:00 | ES | Futures | 5608.09 | 5609.15 | 5604.64 | 5605.96 | 4376.0 |
| 2024-03-25 00:00:00 | NQ | Futures | 19876.62 | 19877.15 | 19865.38 | 19867.26 | 1267.0 |
| 2024-03-25 01:00:00 | NQ | Futures | 19867.26 | 19872.34 | 19850.94 | 19853.08 | 2714.0 |
| 2024-03-25 02:00:00 | NQ | Futures | 19853.35 | 19854.15 | 19829.54 | 19845.32 | 4248.0 |
| 2024-03-25 03:00:00 | NQ | Futures | 19845.59 | 19849.07 | 19832.75 | 19839.97 | 3800.0 |
| 2024-03-25 04:00:00 | NQ | Futures | 19839.44 | 19864.85 | 19835.96 | 19850.14 | 7998.0 |
| 2024-03-25 05:00:00 | NQ | Futures | 19849.6 | 19855.22 | 19815.9 | 19821.51 | 6861.0 |
| 2024-03-25 06:00:00 | NQ | Futures | 19821.25 | 19826.86 | 19790.22 | 19796.1 | 8324.0 |
| 2024-03-25 07:00:00 | NQ | Futures | 19795.83 | 19797.97 | 19748.75 | 19762.93 | 12481.0 |
| 2024-03-25 08:00:00 | NQ | Futures | 19763.47 | 19782.19 | 19751.69 | 19769.08 | 12604.0 |
| 2024-03-25 09:00:00 | NQ | Futures | 19769.62 | 19781.92 | 19704.08 | 19772.83 | 84185.0 |
| 2024-03-25 10:00:00 | NQ | Futures | 19772.83 | 19840.24 | 19759.72 | 19818.84 | 77361.0 |
| 2024-03-25 11:00:00 | NQ | Futures | 19818.84 | 19852.54 | 19811.08 | 19836.23 | 51675.0 |
| 2024-03-25 12:00:00 | NQ | Futures | 19836.49 | 19837.83 | 19807.34 | 19826.86 | 34983.0 |
| 2024-03-25 13:00:00 | NQ | Futures | 19826.86 | 19856.82 | 19811.35 | 19851.21 | 28496.0 |
| 2024-03-25 14:00:00 | NQ | Futures | 19851.21 | 19872.07 | 19846.66 | 19867.26 | 25741.0 |
| 2024-03-25 15:00:00 | NQ | Futures | 19868.06 | 19869.93 | 19803.32 | 19805.46 | 57313.0 |
| 2024-03-25 16:00:00 | NQ | Futures | 19805.46 | 19832.75 | 19804.39 | 19831.14 | 9921.0 |
| 2024-03-25 18:00:00 | NQ | Futures | 19828.74 | 19840.24 | 19827.4 | 19829.27 | 2708.0 |
| 2024-03-25 19:00:00 | NQ | Futures | 19830.07 | 19841.84 | 19823.92 | 19839.17 | 1989.0 |
| 2024-03-25 20:00:00 | NQ | Futures | 19838.37 | 19848.26 | 19834.35 | 19845.59 | 2315.0 |
| 2024-03-25 21:00:00 | NQ | Futures | 19845.86 | 19855.22 | 19838.37 | 19841.31 | 3358.0 |
| 2024-03-25 22:00:00 | NQ | Futures | 19841.31 | 19846.12 | 19832.48 | 19832.48 | 2546.0 |
| 2024-03-25 23:00:00 | NQ | Futures | 19833.02 | 19837.03 | 19813.22 | 19820.18 | 2999.0 |
| 2024-03-25 00:00:00 | YM | Futures | 42266.4 | 42268.5 | 42255.8 | 42264.2 | 245.0 |
| 2024-03-25 01:00:00 | YM | Futures | 42264.2 | 42269.6 | 42247.3 | 42251.5 | 449.0 |
| 2024-03-25 02:00:00 | YM | Futures | 42250.4 | 42254.7 | 42227.1 | 42251.5 | 970.0 |
| 2024-03-25 03:00:00 | YM | Futures | 42251.5 | 42258.9 | 42229.2 | 42240.9 | 1825.0 |
> showing 50 of 2,073 rows — these rows as CSV