PREVIEW / futures_1hour / 2024-04-04
file: by_date/futures_1hour/2024/2024-04-04.parquet size: 68 KB rows: 2,078
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-04 00:00:00 | ES | Futures | 5603.31 | 5605.7 | 5602.51 | 5603.58 | 4217.0 |
| 2024-04-04 01:00:00 | ES | Futures | 5603.58 | 5603.84 | 5599.86 | 5599.86 | 4224.0 |
| 2024-04-04 02:00:00 | ES | Futures | 5599.86 | 5600.39 | 5597.47 | 5598.8 | 6302.0 |
| 2024-04-04 03:00:00 | ES | Futures | 5599.07 | 5604.9 | 5597.47 | 5603.84 | 13254.0 |
| 2024-04-04 04:00:00 | ES | Futures | 5603.84 | 5607.82 | 5603.05 | 5604.11 | 13209.0 |
| 2024-04-04 05:00:00 | ES | Futures | 5604.11 | 5607.02 | 5602.78 | 5605.43 | 6241.0 |
| 2024-04-04 06:00:00 | ES | Futures | 5605.7 | 5608.88 | 5603.05 | 5608.88 | 8917.0 |
| 2024-04-04 07:00:00 | ES | Futures | 5608.88 | 5609.15 | 5604.37 | 5606.23 | 12807.0 |
| 2024-04-04 08:00:00 | ES | Futures | 5606.49 | 5625.33 | 5603.84 | 5624.27 | 50985.0 |
| 2024-04-04 09:00:00 | ES | Futures | 5624.27 | 5631.7 | 5619.23 | 5622.15 | 173245.0 |
| 2024-04-04 10:00:00 | ES | Futures | 5621.88 | 5624.53 | 5618.17 | 5620.82 | 114712.0 |
| 2024-04-04 11:00:00 | ES | Futures | 5620.55 | 5626.92 | 5616.58 | 5626.39 | 94213.0 |
| 2024-04-04 12:00:00 | ES | Futures | 5626.66 | 5633.29 | 5625.6 | 5628.51 | 88232.0 |
| 2024-04-04 13:00:00 | ES | Futures | 5628.78 | 5629.04 | 5609.41 | 5611.0 | 100779.0 |
| 2024-04-04 14:00:00 | ES | Futures | 5611.0 | 5611.27 | 5541.76 | 5546.27 | 537176.0 |
| 2024-04-04 15:00:00 | ES | Futures | 5546.01 | 5548.39 | 5512.05 | 5515.5 | 479939.0 |
| 2024-04-04 16:00:00 | ES | Futures | 5515.5 | 5522.66 | 5510.19 | 5514.97 | 90631.0 |
| 2024-04-04 18:00:00 | ES | Futures | 5517.89 | 5526.37 | 5516.29 | 5519.74 | 15148.0 |
| 2024-04-04 19:00:00 | ES | Futures | 5519.74 | 5523.72 | 5517.62 | 5518.95 | 7839.0 |
| 2024-04-04 20:00:00 | ES | Futures | 5518.95 | 5523.46 | 5509.13 | 5518.68 | 19073.0 |
| 2024-04-04 21:00:00 | ES | Futures | 5518.68 | 5520.27 | 5513.38 | 5514.7 | 13241.0 |
| 2024-04-04 22:00:00 | ES | Futures | 5514.7 | 5519.48 | 5513.64 | 5519.21 | 7535.0 |
| 2024-04-04 23:00:00 | ES | Futures | 5519.21 | 5524.25 | 5517.62 | 5523.99 | 8877.0 |
| 2024-04-04 00:00:00 | NQ | Futures | 19745.27 | 19754.37 | 19742.87 | 19744.2 | 2024.0 |
| 2024-04-04 01:00:00 | NQ | Futures | 19744.74 | 19746.08 | 19721.47 | 19722.54 | 2711.0 |
| 2024-04-04 02:00:00 | NQ | Futures | 19722.0 | 19722.8 | 19707.82 | 19712.37 | 4097.0 |
| 2024-04-04 03:00:00 | NQ | Futures | 19711.84 | 19738.05 | 19699.8 | 19731.36 | 7525.0 |
| 2024-04-04 04:00:00 | NQ | Futures | 19731.9 | 19754.37 | 19726.82 | 19736.18 | 7132.0 |
| 2024-04-04 05:00:00 | NQ | Futures | 19736.98 | 19751.96 | 19731.36 | 19746.61 | 3792.0 |
| 2024-04-04 06:00:00 | NQ | Futures | 19746.88 | 19756.51 | 19730.83 | 19755.17 | 5557.0 |
| 2024-04-04 07:00:00 | NQ | Futures | 19755.44 | 19756.78 | 19736.45 | 19746.08 | 5956.0 |
| 2024-04-04 08:00:00 | NQ | Futures | 19746.61 | 19839.97 | 19733.5 | 19833.82 | 26706.0 |
| 2024-04-04 09:00:00 | NQ | Futures | 19834.09 | 19868.06 | 19802.25 | 19814.56 | 86105.0 |
| 2024-04-04 10:00:00 | NQ | Futures | 19814.29 | 19829.0 | 19781.12 | 19795.83 | 65018.0 |
| 2024-04-04 11:00:00 | NQ | Futures | 19795.83 | 19832.48 | 19773.63 | 19832.48 | 47400.0 |
| 2024-04-04 12:00:00 | NQ | Futures | 19832.48 | 19866.72 | 19828.74 | 19856.02 | 44389.0 |
| 2024-04-04 13:00:00 | NQ | Futures | 19856.29 | 19858.16 | 19781.92 | 19793.16 | 44756.0 |
| 2024-04-04 14:00:00 | NQ | Futures | 19793.43 | 19793.43 | 19483.12 | 19502.92 | 195167.0 |
| 2024-04-04 15:00:00 | NQ | Futures | 19502.11 | 19502.11 | 19334.39 | 19340.54 | 164973.0 |
| 2024-04-04 16:00:00 | NQ | Futures | 19340.81 | 19367.29 | 19319.41 | 19337.87 | 26556.0 |
| 2024-04-04 18:00:00 | NQ | Futures | 19352.58 | 19387.35 | 19340.54 | 19361.14 | 8797.0 |
| 2024-04-04 19:00:00 | NQ | Futures | 19361.67 | 19374.51 | 19349.1 | 19358.2 | 5174.0 |
| 2024-04-04 20:00:00 | NQ | Futures | 19358.46 | 19377.99 | 19317.27 | 19363.55 | 7310.0 |
| 2024-04-04 21:00:00 | NQ | Futures | 19363.28 | 19365.69 | 19326.36 | 19336.26 | 5276.0 |
| 2024-04-04 22:00:00 | NQ | Futures | 19335.73 | 19356.06 | 19330.38 | 19354.45 | 3560.0 |
| 2024-04-04 23:00:00 | NQ | Futures | 19353.92 | 19379.86 | 19345.89 | 19377.99 | 3844.0 |
| 2024-04-04 00:00:00 | YM | Futures | 41975.5 | 41997.8 | 41972.3 | 41991.4 | 463.0 |
| 2024-04-04 01:00:00 | YM | Futures | 41990.3 | 41991.4 | 41968.0 | 41969.1 | 568.0 |
| 2024-04-04 02:00:00 | YM | Futures | 41969.1 | 41980.8 | 41953.2 | 41971.2 | 1201.0 |
| 2024-04-04 03:00:00 | YM | Futures | 41972.3 | 42013.7 | 41963.8 | 42000.9 | 1821.0 |
> showing 50 of 2,078 rows — these rows as CSV