PREVIEW / futures_30min / 2023-04-16
file: by_date/futures_30min/2023/2023-04-16.parquet size: 28 KB rows: 806
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 |
|---|---|---|---|---|---|---|---|
| 2023-04-16 18:00:00 | ES | Futures | 4630.97 | 4631.52 | 4626.53 | 4627.64 | 4337.0 |
| 2023-04-16 18:30:00 | ES | Futures | 4627.36 | 4630.69 | 4626.25 | 4629.86 | 3172.0 |
| 2023-04-16 19:00:00 | ES | Futures | 4629.86 | 4630.41 | 4626.81 | 4628.2 | 2279.0 |
| 2023-04-16 19:30:00 | ES | Futures | 4627.92 | 4629.31 | 4627.36 | 4628.47 | 2116.0 |
| 2023-04-16 20:00:00 | ES | Futures | 4628.2 | 4629.86 | 4626.81 | 4628.47 | 3745.0 |
| 2023-04-16 20:30:00 | ES | Futures | 4628.47 | 4630.41 | 4625.42 | 4625.7 | 3047.0 |
| 2023-04-16 21:00:00 | ES | Futures | 4625.42 | 4627.09 | 4624.87 | 4625.42 | 3342.0 |
| 2023-04-16 21:30:00 | ES | Futures | 4625.42 | 4630.14 | 4625.42 | 4627.36 | 5169.0 |
| 2023-04-16 22:00:00 | ES | Futures | 4627.09 | 4628.2 | 4625.42 | 4627.64 | 3108.0 |
| 2023-04-16 22:30:00 | ES | Futures | 4627.64 | 4628.75 | 4626.53 | 4627.09 | 2067.0 |
| 2023-04-16 23:00:00 | ES | Futures | 4627.36 | 4627.92 | 4626.25 | 4627.92 | 1308.0 |
| 2023-04-16 23:30:00 | ES | Futures | 4627.64 | 4627.64 | 4626.25 | 4626.81 | 1243.0 |
| 2023-04-16 18:00:00 | NQ | Futures | 14880.08 | 14882.61 | 14855.3 | 14858.12 | 2536.0 |
| 2023-04-16 18:30:00 | NQ | Futures | 14858.4 | 14862.62 | 14850.23 | 14859.52 | 1402.0 |
| 2023-04-16 19:00:00 | NQ | Futures | 14860.09 | 14861.49 | 14840.38 | 14846.85 | 1522.0 |
| 2023-04-16 19:30:00 | NQ | Futures | 14846.01 | 14854.74 | 14844.32 | 14851.08 | 1244.0 |
| 2023-04-16 20:00:00 | NQ | Futures | 14850.8 | 14861.49 | 14848.54 | 14854.46 | 1739.0 |
| 2023-04-16 20:30:00 | NQ | Futures | 14854.17 | 14861.49 | 14838.69 | 14839.81 | 1649.0 |
| 2023-04-16 21:00:00 | NQ | Futures | 14840.38 | 14845.73 | 14836.72 | 14838.69 | 1815.0 |
| 2023-04-16 21:30:00 | NQ | Futures | 14839.53 | 14856.14 | 14837.84 | 14847.98 | 2079.0 |
| 2023-04-16 22:00:00 | NQ | Futures | 14847.98 | 14851.92 | 14840.66 | 14847.7 | 1303.0 |
| 2023-04-16 22:30:00 | NQ | Futures | 14847.98 | 14852.48 | 14844.88 | 14847.42 | 1064.0 |
| 2023-04-16 23:00:00 | NQ | Futures | 14847.98 | 14849.39 | 14842.91 | 14847.98 | 690.0 |
| 2023-04-16 23:30:00 | NQ | Futures | 14847.42 | 14848.54 | 14844.04 | 14846.01 | 587.0 |
| 2023-04-16 18:00:00 | YM | Futures | 37718.6 | 37718.6 | 37666.7 | 37673.3 | 547.0 |
| 2023-04-16 18:30:00 | YM | Futures | 37674.4 | 37707.6 | 37667.8 | 37701.0 | 505.0 |
| 2023-04-16 19:00:00 | YM | Futures | 37703.2 | 37704.3 | 37687.7 | 37696.5 | 486.0 |
| 2023-04-16 19:30:00 | YM | Futures | 37694.3 | 37705.4 | 37694.3 | 37698.8 | 417.0 |
| 2023-04-16 20:00:00 | YM | Futures | 37698.8 | 37706.5 | 37685.5 | 37697.6 | 470.0 |
| 2023-04-16 20:30:00 | YM | Futures | 37697.6 | 37707.6 | 37678.9 | 37678.9 | 461.0 |
| 2023-04-16 21:00:00 | YM | Futures | 37680.0 | 37692.1 | 37674.4 | 37681.1 | 524.0 |
| 2023-04-16 21:30:00 | YM | Futures | 37681.1 | 37708.7 | 37681.1 | 37688.8 | 539.0 |
| 2023-04-16 22:00:00 | YM | Futures | 37689.9 | 37694.3 | 37677.8 | 37688.8 | 359.0 |
| 2023-04-16 22:30:00 | YM | Futures | 37688.8 | 37695.4 | 37682.2 | 37685.5 | 410.0 |
| 2023-04-16 23:00:00 | YM | Futures | 37685.5 | 37693.2 | 37682.2 | 37691.0 | 200.0 |
| 2023-04-16 23:30:00 | YM | Futures | 37691.0 | 37691.0 | 37681.1 | 37683.3 | 241.0 |
| 2023-04-16 18:00:00 | CL | Futures | 66.98 | 67.13 | 66.91 | 66.94 | 583.0 |
| 2023-04-16 18:30:00 | CL | Futures | 66.93 | 67.06 | 66.93 | 67.02 | 339.0 |
| 2023-04-16 19:00:00 | CL | Futures | 67.02 | 67.03 | 66.94 | 66.99 | 392.0 |
| 2023-04-16 19:30:00 | CL | Futures | 66.99 | 67.05 | 66.99 | 67.04 | 135.0 |
| 2023-04-16 20:00:00 | CL | Futures | 67.02 | 67.15 | 66.96 | 66.96 | 597.0 |
| 2023-04-16 20:30:00 | CL | Futures | 66.97 | 67.11 | 66.96 | 67.01 | 429.0 |
| 2023-04-16 21:00:00 | CL | Futures | 67.0 | 67.11 | 66.84 | 66.88 | 827.0 |
| 2023-04-16 21:30:00 | CL | Futures | 66.88 | 67.01 | 66.82 | 67.0 | 656.0 |
| 2023-04-16 22:00:00 | CL | Futures | 67.0 | 67.02 | 66.91 | 66.95 | 220.0 |
| 2023-04-16 22:30:00 | CL | Futures | 66.94 | 67.12 | 66.94 | 67.04 | 551.0 |
| 2023-04-16 23:00:00 | CL | Futures | 67.04 | 67.09 | 66.98 | 67.02 | 148.0 |
| 2023-04-16 23:30:00 | CL | Futures | 67.01 | 67.04 | 66.98 | 67.02 | 134.0 |
| 2023-04-16 18:00:00 | GC | Futures | 2316.2 | 2321.3 | 2311.5 | 2318.7 | 2777.0 |
| 2023-04-16 18:30:00 | GC | Futures | 2318.7 | 2319.0 | 2314.7 | 2316.7 | 967.0 |
> showing 50 of 806 rows — these rows as CSV