PREVIEW / futures_1hour / 2024-03-27
file: by_date/futures_1hour/2024/2024-03-27.parquet size: 65 KB rows: 2,098
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-27 00:00:00 | ES | Futures | 5601.19 | 5605.96 | 5600.92 | 5605.96 | 5103.0 |
| 2024-03-27 01:00:00 | ES | Futures | 5605.96 | 5609.15 | 5604.9 | 5605.7 | 8639.0 |
| 2024-03-27 02:00:00 | ES | Futures | 5605.7 | 5606.49 | 5603.31 | 5603.58 | 5584.0 |
| 2024-03-27 03:00:00 | ES | Futures | 5603.31 | 5604.37 | 5598.8 | 5599.86 | 8690.0 |
| 2024-03-27 04:00:00 | ES | Futures | 5600.13 | 5607.02 | 5599.86 | 5604.37 | 12267.0 |
| 2024-03-27 05:00:00 | ES | Futures | 5604.64 | 5608.09 | 5603.05 | 5606.76 | 8836.0 |
| 2024-03-27 06:00:00 | ES | Futures | 5606.76 | 5612.33 | 5605.17 | 5611.27 | 10768.0 |
| 2024-03-27 07:00:00 | ES | Futures | 5611.27 | 5611.8 | 5607.56 | 5608.09 | 10177.0 |
| 2024-03-27 08:00:00 | ES | Futures | 5608.35 | 5613.13 | 5604.64 | 5612.86 | 19951.0 |
| 2024-03-27 09:00:00 | ES | Futures | 5612.86 | 5618.43 | 5606.23 | 5608.09 | 178619.0 |
| 2024-03-27 10:00:00 | ES | Futures | 5607.82 | 5608.62 | 5594.29 | 5596.68 | 238744.0 |
| 2024-03-27 11:00:00 | ES | Futures | 5596.68 | 5600.13 | 5593.23 | 5593.76 | 104965.0 |
| 2024-03-27 12:00:00 | ES | Futures | 5593.76 | 5604.11 | 5593.23 | 5602.25 | 87469.0 |
| 2024-03-27 13:00:00 | ES | Futures | 5602.51 | 5604.64 | 5596.15 | 5601.19 | 72336.0 |
| 2024-03-27 14:00:00 | ES | Futures | 5601.45 | 5610.47 | 5599.6 | 5603.05 | 90926.0 |
| 2024-03-27 15:00:00 | ES | Futures | 5603.05 | 5635.41 | 5598.54 | 5635.15 | 366182.0 |
| 2024-03-27 16:00:00 | ES | Futures | 5635.15 | 5638.86 | 5632.49 | 5633.02 | 114342.0 |
| 2024-03-27 18:00:00 | ES | Futures | 5632.76 | 5633.29 | 5625.86 | 5627.98 | 11523.0 |
| 2024-03-27 19:00:00 | ES | Futures | 5628.25 | 5630.37 | 5626.92 | 5627.98 | 4525.0 |
| 2024-03-27 20:00:00 | ES | Futures | 5627.72 | 5632.49 | 5627.45 | 5632.49 | 9330.0 |
| 2024-03-27 21:00:00 | ES | Futures | 5632.23 | 5632.76 | 5628.78 | 5629.04 | 5958.0 |
| 2024-03-27 22:00:00 | ES | Futures | 5628.78 | 5629.57 | 5628.25 | 5628.51 | 4497.0 |
| 2024-03-27 23:00:00 | ES | Futures | 5628.51 | 5630.37 | 5628.25 | 5629.57 | 4287.0 |
| 2024-03-27 00:00:00 | NQ | Futures | 19791.82 | 19813.76 | 19790.75 | 19812.95 | 2756.0 |
| 2024-03-27 01:00:00 | NQ | Futures | 19812.95 | 19820.98 | 19803.86 | 19804.39 | 4409.0 |
| 2024-03-27 02:00:00 | NQ | Futures | 19804.39 | 19807.34 | 19792.89 | 19795.03 | 3600.0 |
| 2024-03-27 03:00:00 | NQ | Futures | 19794.76 | 19798.51 | 19763.73 | 19772.83 | 7314.0 |
| 2024-03-27 04:00:00 | NQ | Futures | 19772.29 | 19817.77 | 19772.29 | 19805.73 | 9403.0 |
| 2024-03-27 05:00:00 | NQ | Futures | 19806.0 | 19822.32 | 19795.83 | 19812.15 | 7252.0 |
| 2024-03-27 06:00:00 | NQ | Futures | 19812.15 | 19839.97 | 19806.53 | 19834.09 | 7773.0 |
| 2024-03-27 07:00:00 | NQ | Futures | 19833.82 | 19834.89 | 19816.43 | 19818.57 | 6680.0 |
| 2024-03-27 08:00:00 | NQ | Futures | 19818.57 | 19848.53 | 19807.34 | 19846.93 | 12018.0 |
| 2024-03-27 09:00:00 | NQ | Futures | 19847.19 | 19872.07 | 19737.52 | 19742.33 | 100051.0 |
| 2024-03-27 10:00:00 | NQ | Futures | 19742.6 | 19750.36 | 19665.29 | 19709.43 | 117735.0 |
| 2024-03-27 11:00:00 | NQ | Futures | 19709.7 | 19720.66 | 19678.4 | 19683.75 | 57112.0 |
| 2024-03-27 12:00:00 | NQ | Futures | 19684.02 | 19745.54 | 19679.74 | 19731.9 | 43617.0 |
| 2024-03-27 13:00:00 | NQ | Futures | 19732.17 | 19738.59 | 19696.05 | 19720.66 | 37563.0 |
| 2024-03-27 14:00:00 | NQ | Futures | 19720.93 | 19754.1 | 19701.94 | 19709.16 | 45093.0 |
| 2024-03-27 15:00:00 | NQ | Futures | 19709.43 | 19803.59 | 19685.09 | 19802.52 | 96345.0 |
| 2024-03-27 16:00:00 | NQ | Futures | 19802.52 | 19823.39 | 19795.57 | 19801.18 | 19016.0 |
| 2024-03-27 18:00:00 | NQ | Futures | 19800.65 | 19800.92 | 19770.42 | 19776.04 | 5857.0 |
| 2024-03-27 19:00:00 | NQ | Futures | 19776.57 | 19787.81 | 19768.28 | 19774.17 | 2760.0 |
| 2024-03-27 20:00:00 | NQ | Futures | 19774.17 | 19799.31 | 19773.36 | 19796.64 | 4218.0 |
| 2024-03-27 21:00:00 | NQ | Futures | 19796.64 | 19800.92 | 19778.71 | 19780.32 | 4130.0 |
| 2024-03-27 22:00:00 | NQ | Futures | 19780.59 | 19789.41 | 19778.18 | 19782.46 | 2237.0 |
| 2024-03-27 23:00:00 | NQ | Futures | 19782.19 | 19793.16 | 19781.12 | 19789.41 | 1709.0 |
| 2024-03-27 00:00:00 | YM | Futures | 42243.0 | 42274.9 | 42242.0 | 42273.8 | 633.0 |
| 2024-03-27 01:00:00 | YM | Futures | 42273.8 | 42301.4 | 42270.6 | 42282.3 | 974.0 |
| 2024-03-27 02:00:00 | YM | Futures | 42281.2 | 42286.5 | 42263.2 | 42263.2 | 999.0 |
| 2024-03-27 03:00:00 | YM | Futures | 42263.2 | 42268.5 | 42236.6 | 42237.7 | 1582.0 |
> showing 50 of 2,098 rows — these rows as CSV