PREVIEW / futures_1hour / 2024-04-02
file: by_date/futures_1hour/2024/2024-04-02.parquet size: 68 KB rows: 2,100
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-02 00:00:00 | ES | Futures | 5612.86 | 5613.66 | 5611.0 | 5612.07 | 3232.0 |
| 2024-04-02 01:00:00 | ES | Futures | 5612.07 | 5612.33 | 5608.62 | 5610.74 | 4147.0 |
| 2024-04-02 02:00:00 | ES | Futures | 5610.74 | 5616.04 | 5610.47 | 5611.8 | 8232.0 |
| 2024-04-02 03:00:00 | ES | Futures | 5611.8 | 5616.84 | 5608.35 | 5611.27 | 18400.0 |
| 2024-04-02 04:00:00 | ES | Futures | 5611.53 | 5620.02 | 5610.21 | 5613.13 | 19002.0 |
| 2024-04-02 05:00:00 | ES | Futures | 5612.86 | 5616.58 | 5610.21 | 5610.74 | 13283.0 |
| 2024-04-02 06:00:00 | ES | Futures | 5610.74 | 5610.74 | 5602.25 | 5606.23 | 19280.0 |
| 2024-04-02 07:00:00 | ES | Futures | 5605.96 | 5607.02 | 5596.68 | 5596.94 | 22478.0 |
| 2024-04-02 08:00:00 | ES | Futures | 5597.21 | 5599.33 | 5580.5 | 5581.82 | 58993.0 |
| 2024-04-02 09:00:00 | ES | Futures | 5581.56 | 5582.88 | 5559.01 | 5567.76 | 242676.0 |
| 2024-04-02 10:00:00 | ES | Futures | 5568.03 | 5572.27 | 5555.29 | 5560.6 | 250572.0 |
| 2024-04-02 11:00:00 | ES | Futures | 5560.6 | 5570.41 | 5559.54 | 5562.46 | 130580.0 |
| 2024-04-02 12:00:00 | ES | Futures | 5562.46 | 5572.27 | 5560.07 | 5571.74 | 100222.0 |
| 2024-04-02 13:00:00 | ES | Futures | 5571.74 | 5573.86 | 5565.37 | 5569.88 | 76416.0 |
| 2024-04-02 14:00:00 | ES | Futures | 5569.62 | 5573.86 | 5568.56 | 5570.15 | 62024.0 |
| 2024-04-02 15:00:00 | ES | Futures | 5570.15 | 5583.68 | 5569.62 | 5582.88 | 237174.0 |
| 2024-04-02 16:00:00 | ES | Futures | 5582.88 | 5585.27 | 5581.82 | 5583.94 | 47940.0 |
| 2024-04-02 18:00:00 | ES | Futures | 5584.47 | 5584.74 | 5580.5 | 5581.03 | 5718.0 |
| 2024-04-02 19:00:00 | ES | Futures | 5581.03 | 5582.09 | 5579.7 | 5580.23 | 3091.0 |
| 2024-04-02 20:00:00 | ES | Futures | 5580.23 | 5580.23 | 5574.13 | 5575.72 | 9223.0 |
| 2024-04-02 21:00:00 | ES | Futures | 5575.72 | 5576.25 | 5572.8 | 5572.8 | 8825.0 |
| 2024-04-02 22:00:00 | ES | Futures | 5573.07 | 5575.72 | 5572.8 | 5573.86 | 4558.0 |
| 2024-04-02 23:00:00 | ES | Futures | 5573.86 | 5577.05 | 5573.86 | 5576.52 | 4303.0 |
| 2024-04-02 00:00:00 | NQ | Futures | 19773.1 | 19776.57 | 19761.86 | 19769.62 | 1745.0 |
| 2024-04-02 01:00:00 | NQ | Futures | 19769.35 | 19770.69 | 19748.75 | 19762.66 | 2998.0 |
| 2024-04-02 02:00:00 | NQ | Futures | 19762.4 | 19791.82 | 19760.79 | 19773.63 | 5425.0 |
| 2024-04-02 03:00:00 | NQ | Futures | 19772.29 | 19795.3 | 19738.59 | 19756.78 | 11502.0 |
| 2024-04-02 04:00:00 | NQ | Futures | 19757.31 | 19807.07 | 19757.31 | 19770.15 | 12343.0 |
| 2024-04-02 05:00:00 | NQ | Futures | 19769.89 | 19785.67 | 19751.16 | 19751.96 | 6768.0 |
| 2024-04-02 06:00:00 | NQ | Futures | 19751.16 | 19754.9 | 19710.5 | 19728.15 | 11375.0 |
| 2024-04-02 07:00:00 | NQ | Futures | 19728.42 | 19734.57 | 19687.49 | 19691.51 | 12922.0 |
| 2024-04-02 08:00:00 | NQ | Futures | 19691.77 | 19703.81 | 19610.99 | 19621.69 | 27448.0 |
| 2024-04-02 09:00:00 | NQ | Futures | 19621.96 | 19623.83 | 19499.17 | 19532.88 | 123444.0 |
| 2024-04-02 10:00:00 | NQ | Futures | 19533.14 | 19555.35 | 19475.9 | 19490.88 | 105034.0 |
| 2024-04-02 11:00:00 | NQ | Futures | 19491.41 | 19565.24 | 19487.13 | 19509.87 | 70112.0 |
| 2024-04-02 12:00:00 | NQ | Futures | 19509.6 | 19571.4 | 19507.73 | 19570.86 | 42604.0 |
| 2024-04-02 13:00:00 | NQ | Futures | 19570.33 | 19582.1 | 19548.66 | 19556.95 | 38141.0 |
| 2024-04-02 14:00:00 | NQ | Futures | 19557.49 | 19578.35 | 19547.05 | 19558.02 | 30072.0 |
| 2024-04-02 15:00:00 | NQ | Futures | 19557.75 | 19631.59 | 19555.61 | 19613.93 | 73995.0 |
| 2024-04-02 16:00:00 | NQ | Futures | 19613.93 | 19633.46 | 19611.52 | 19628.91 | 12522.0 |
| 2024-04-02 18:00:00 | NQ | Futures | 19629.45 | 19629.45 | 19607.51 | 19610.99 | 3411.0 |
| 2024-04-02 19:00:00 | NQ | Futures | 19610.99 | 19616.87 | 19607.24 | 19611.79 | 2033.0 |
| 2024-04-02 20:00:00 | NQ | Futures | 19610.99 | 19612.59 | 19581.83 | 19592.53 | 5589.0 |
| 2024-04-02 21:00:00 | NQ | Futures | 19592.8 | 19592.8 | 19572.47 | 19574.61 | 4879.0 |
| 2024-04-02 22:00:00 | NQ | Futures | 19574.61 | 19588.78 | 19573.54 | 19575.94 | 2823.0 |
| 2024-04-02 23:00:00 | NQ | Futures | 19575.68 | 19595.21 | 19575.41 | 19592.0 | 2134.0 |
| 2024-04-02 00:00:00 | YM | Futures | 42214.3 | 42218.6 | 42201.6 | 42210.1 | 405.0 |
| 2024-04-02 01:00:00 | YM | Futures | 42211.2 | 42212.2 | 42192.1 | 42203.7 | 502.0 |
| 2024-04-02 02:00:00 | YM | Futures | 42202.7 | 42230.3 | 42198.4 | 42203.7 | 1889.0 |
| 2024-04-02 03:00:00 | YM | Futures | 42203.7 | 42238.8 | 42192.1 | 42225.0 | 2248.0 |
> showing 50 of 2,100 rows — these rows as CSV