PREVIEW / futures_1hour / 2024-04-01
file: by_date/futures_1hour/2024/2024-04-01.parquet size: 55 KB rows: 1,670
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-04-01 00:00:00 | ES | Futures | 5654.51 | 5655.57 | 5653.72 | 5655.31 | 2641.0 |
| 2024-04-01 01:00:00 | ES | Futures | 5655.57 | 5655.84 | 5652.13 | 5652.39 | 2687.0 |
| 2024-04-01 02:00:00 | ES | Futures | 5652.39 | 5654.25 | 5652.13 | 5652.66 | 4270.0 |
| 2024-04-01 03:00:00 | ES | Futures | 5653.19 | 5656.64 | 5652.92 | 5655.84 | 6417.0 |
| 2024-04-01 04:00:00 | ES | Futures | 5655.84 | 5655.84 | 5651.33 | 5655.04 | 7953.0 |
| 2024-04-01 05:00:00 | ES | Futures | 5655.04 | 5655.57 | 5651.86 | 5653.45 | 4904.0 |
| 2024-04-01 06:00:00 | ES | Futures | 5653.45 | 5655.57 | 5652.92 | 5655.04 | 5807.0 |
| 2024-04-01 07:00:00 | ES | Futures | 5654.78 | 5654.78 | 5646.82 | 5648.94 | 13008.0 |
| 2024-04-01 08:00:00 | ES | Futures | 5648.94 | 5649.21 | 5635.15 | 5640.45 | 32406.0 |
| 2024-04-01 09:00:00 | ES | Futures | 5640.45 | 5642.57 | 5632.49 | 5639.66 | 145830.0 |
| 2024-04-01 10:00:00 | ES | Futures | 5639.13 | 5640.45 | 5617.64 | 5620.02 | 204501.0 |
| 2024-04-01 11:00:00 | ES | Futures | 5620.02 | 5621.09 | 5606.76 | 5606.76 | 139718.0 |
| 2024-04-01 12:00:00 | ES | Futures | 5607.02 | 5618.96 | 5605.43 | 5615.51 | 88085.0 |
| 2024-04-01 13:00:00 | ES | Futures | 5615.51 | 5615.78 | 5606.23 | 5613.66 | 76342.0 |
| 2024-04-01 14:00:00 | ES | Futures | 5613.39 | 5618.17 | 5610.74 | 5614.98 | 57914.0 |
| 2024-04-01 15:00:00 | ES | Futures | 5615.25 | 5625.06 | 5612.07 | 5618.17 | 178473.0 |
| 2024-04-01 16:00:00 | ES | Futures | 5618.17 | 5620.29 | 5615.25 | 5617.64 | 49662.0 |
| 2024-04-01 18:00:00 | ES | Futures | 5618.43 | 5618.43 | 5612.6 | 5613.13 | 5361.0 |
| 2024-04-01 19:00:00 | ES | Futures | 5613.13 | 5614.98 | 5609.94 | 5613.13 | 5768.0 |
| 2024-04-01 20:00:00 | ES | Futures | 5613.13 | 5614.72 | 5610.74 | 5612.33 | 6635.0 |
| 2024-04-01 21:00:00 | ES | Futures | 5612.33 | 5615.51 | 5610.47 | 5613.13 | 6777.0 |
| 2024-04-01 22:00:00 | ES | Futures | 5613.13 | 5616.04 | 5611.8 | 5615.51 | 4541.0 |
| 2024-04-01 23:00:00 | ES | Futures | 5615.25 | 5616.04 | 5612.86 | 5613.13 | 3654.0 |
| 2024-04-01 00:00:00 | NQ | Futures | 19885.71 | 19892.67 | 19881.43 | 19891.06 | 2676.0 |
| 2024-04-01 01:00:00 | NQ | Futures | 19891.06 | 19894.54 | 19871.54 | 19873.41 | 2652.0 |
| 2024-04-01 02:00:00 | NQ | Futures | 19872.87 | 19883.57 | 19866.99 | 19869.13 | 2752.0 |
| 2024-04-01 03:00:00 | NQ | Futures | 19869.13 | 19905.24 | 19868.59 | 19899.09 | 5254.0 |
| 2024-04-01 04:00:00 | NQ | Futures | 19899.36 | 19899.89 | 19856.29 | 19877.96 | 6753.0 |
| 2024-04-01 05:00:00 | NQ | Futures | 19877.96 | 19880.63 | 19860.03 | 19871.27 | 3007.0 |
| 2024-04-01 06:00:00 | NQ | Futures | 19871.27 | 19884.11 | 19868.59 | 19880.9 | 3508.0 |
| 2024-04-01 07:00:00 | NQ | Futures | 19880.63 | 19880.63 | 19825.26 | 19840.24 | 8970.0 |
| 2024-04-01 08:00:00 | NQ | Futures | 19840.51 | 19840.51 | 19788.08 | 19811.62 | 16799.0 |
| 2024-04-01 09:00:00 | NQ | Futures | 19811.62 | 19909.79 | 19771.76 | 19887.32 | 93830.0 |
| 2024-04-01 10:00:00 | NQ | Futures | 19885.71 | 19906.85 | 19759.72 | 19776.04 | 115848.0 |
| 2024-04-01 11:00:00 | NQ | Futures | 19776.31 | 19783.8 | 19710.23 | 19715.31 | 73916.0 |
| 2024-04-01 12:00:00 | NQ | Futures | 19715.58 | 19785.94 | 19703.81 | 19762.13 | 45992.0 |
| 2024-04-01 13:00:00 | NQ | Futures | 19762.4 | 19765.87 | 19715.31 | 19756.78 | 37246.0 |
| 2024-04-01 14:00:00 | NQ | Futures | 19757.31 | 19776.57 | 19742.06 | 19761.86 | 29416.0 |
| 2024-04-01 15:00:00 | NQ | Futures | 19761.86 | 19810.55 | 19748.22 | 19790.22 | 64944.0 |
| 2024-04-01 16:00:00 | NQ | Futures | 19789.68 | 19801.45 | 19783.53 | 19792.89 | 14641.0 |
| 2024-04-01 18:00:00 | NQ | Futures | 19792.36 | 19794.76 | 19765.61 | 19771.49 | 3498.0 |
| 2024-04-01 19:00:00 | NQ | Futures | 19771.76 | 19778.18 | 19750.89 | 19763.47 | 3498.0 |
| 2024-04-01 20:00:00 | NQ | Futures | 19763.73 | 19766.94 | 19750.36 | 19759.19 | 3314.0 |
| 2024-04-01 21:00:00 | NQ | Futures | 19758.38 | 19771.22 | 19750.09 | 19763.2 | 3263.0 |
| 2024-04-01 22:00:00 | NQ | Futures | 19763.47 | 19784.6 | 19758.92 | 19781.39 | 2725.0 |
| 2024-04-01 23:00:00 | NQ | Futures | 19781.12 | 19785.13 | 19770.96 | 19772.83 | 1951.0 |
| 2024-04-01 00:00:00 | YM | Futures | 42804.7 | 42816.3 | 42800.4 | 42815.3 | 479.0 |
| 2024-04-01 01:00:00 | YM | Futures | 42816.3 | 42816.3 | 42794.0 | 42798.3 | 486.0 |
| 2024-04-01 02:00:00 | YM | Futures | 42796.2 | 42808.9 | 42791.9 | 42794.0 | 796.0 |
| 2024-04-01 03:00:00 | YM | Futures | 42797.2 | 42814.2 | 42790.9 | 42796.2 | 868.0 |
> showing 50 of 1,670 rows — these rows as CSV