PREVIEW / futures_30min / 2023-03-19
file: by_date/futures_30min/2023/2023-03-19.parquet size: 32 KB rows: 825
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-03-19 18:00:00 | ES | Futures | 4397.44 | 4406.59 | 4384.96 | 4399.66 | 25243.0 |
| 2023-03-19 18:30:00 | ES | Futures | 4399.38 | 4411.86 | 4398.82 | 4401.88 | 14268.0 |
| 2023-03-19 19:00:00 | ES | Futures | 4401.88 | 4402.71 | 4395.22 | 4399.1 | 7188.0 |
| 2023-03-19 19:30:00 | ES | Futures | 4399.1 | 4409.64 | 4399.1 | 4405.48 | 8657.0 |
| 2023-03-19 20:00:00 | ES | Futures | 4405.48 | 4413.52 | 4404.93 | 4411.86 | 12660.0 |
| 2023-03-19 20:30:00 | ES | Futures | 4411.86 | 4412.97 | 4408.25 | 4410.2 | 7843.0 |
| 2023-03-19 21:00:00 | ES | Futures | 4409.92 | 4409.92 | 4403.82 | 4404.65 | 7924.0 |
| 2023-03-19 21:30:00 | ES | Futures | 4404.93 | 4404.93 | 4389.67 | 4394.94 | 13551.0 |
| 2023-03-19 22:00:00 | ES | Futures | 4394.94 | 4399.1 | 4393.83 | 4395.22 | 4984.0 |
| 2023-03-19 22:30:00 | ES | Futures | 4395.22 | 4396.61 | 4390.78 | 4396.33 | 5957.0 |
| 2023-03-19 23:00:00 | ES | Futures | 4396.33 | 4396.61 | 4386.07 | 4387.18 | 6783.0 |
| 2023-03-19 23:30:00 | ES | Futures | 4387.45 | 4388.01 | 4382.18 | 4384.4 | 6618.0 |
| 2023-03-19 18:00:00 | NQ | Futures | 14291.63 | 14359.2 | 14260.94 | 14308.24 | 8479.0 |
| 2023-03-19 18:30:00 | NQ | Futures | 14307.68 | 14340.62 | 14298.39 | 14305.43 | 5157.0 |
| 2023-03-19 19:00:00 | NQ | Futures | 14305.15 | 14314.16 | 14286.0 | 14297.26 | 2763.0 |
| 2023-03-19 19:30:00 | NQ | Futures | 14297.26 | 14327.11 | 14296.42 | 14309.93 | 2989.0 |
| 2023-03-19 20:00:00 | NQ | Futures | 14309.93 | 14333.86 | 14309.09 | 14329.36 | 3636.0 |
| 2023-03-19 20:30:00 | NQ | Futures | 14329.36 | 14331.05 | 14308.52 | 14315.28 | 2704.0 |
| 2023-03-19 21:00:00 | NQ | Futures | 14315.0 | 14315.0 | 14291.91 | 14299.8 | 3516.0 |
| 2023-03-19 21:30:00 | NQ | Futures | 14300.08 | 14303.46 | 14253.34 | 14275.02 | 5067.0 |
| 2023-03-19 22:00:00 | NQ | Futures | 14273.61 | 14287.97 | 14273.61 | 14282.34 | 2160.0 |
| 2023-03-19 22:30:00 | NQ | Futures | 14282.62 | 14293.6 | 14268.26 | 14293.04 | 2888.0 |
| 2023-03-19 23:00:00 | NQ | Futures | 14293.6 | 14295.01 | 14266.85 | 14271.36 | 2974.0 |
| 2023-03-19 23:30:00 | NQ | Futures | 14272.49 | 14278.96 | 14259.25 | 14265.17 | 2791.0 |
| 2023-03-19 18:00:00 | YM | Futures | 35526.8 | 35588.7 | 35482.6 | 35576.6 | 2697.0 |
| 2023-03-19 18:30:00 | YM | Futures | 35575.5 | 35670.5 | 35573.2 | 35605.3 | 1901.0 |
| 2023-03-19 19:00:00 | YM | Futures | 35605.3 | 35607.5 | 35557.8 | 35590.9 | 1041.0 |
| 2023-03-19 19:30:00 | YM | Futures | 35594.2 | 35679.4 | 35594.2 | 35657.2 | 2325.0 |
| 2023-03-19 20:00:00 | YM | Futures | 35658.4 | 35711.4 | 35651.7 | 35698.1 | 1741.0 |
| 2023-03-19 20:30:00 | YM | Futures | 35700.4 | 35707.0 | 35682.7 | 35692.6 | 1078.0 |
| 2023-03-19 21:00:00 | YM | Futures | 35691.5 | 35691.5 | 35649.5 | 35655.0 | 1204.0 |
| 2023-03-19 21:30:00 | YM | Futures | 35655.0 | 35657.2 | 35547.8 | 35568.8 | 1701.0 |
| 2023-03-19 22:00:00 | YM | Futures | 35571.0 | 35596.5 | 35555.6 | 35563.3 | 935.0 |
| 2023-03-19 22:30:00 | YM | Futures | 35564.4 | 35564.4 | 35534.6 | 35553.3 | 795.0 |
| 2023-03-19 23:00:00 | YM | Futures | 35553.3 | 35556.7 | 35471.6 | 35477.1 | 1789.0 |
| 2023-03-19 23:30:00 | YM | Futures | 35478.2 | 35479.3 | 35438.4 | 35451.7 | 1500.0 |
| 2023-03-19 18:00:00 | CL | Futures | 54.26 | 54.58 | 53.95 | 54.52 | 2619.0 |
| 2023-03-19 18:30:00 | CL | Futures | 54.54 | 54.83 | 54.53 | 54.61 | 1772.0 |
| 2023-03-19 19:00:00 | CL | Futures | 54.61 | 54.62 | 54.36 | 54.53 | 920.0 |
| 2023-03-19 19:30:00 | CL | Futures | 54.54 | 54.66 | 54.53 | 54.56 | 731.0 |
| 2023-03-19 20:00:00 | CL | Futures | 54.55 | 54.68 | 54.52 | 54.54 | 1338.0 |
| 2023-03-19 20:30:00 | CL | Futures | 54.53 | 54.64 | 54.46 | 54.55 | 1049.0 |
| 2023-03-19 21:00:00 | CL | Futures | 54.54 | 54.91 | 54.48 | 54.78 | 4170.0 |
| 2023-03-19 21:30:00 | CL | Futures | 54.78 | 54.86 | 54.36 | 54.41 | 3364.0 |
| 2023-03-19 22:00:00 | CL | Futures | 54.41 | 54.58 | 54.41 | 54.49 | 1144.0 |
| 2023-03-19 22:30:00 | CL | Futures | 54.49 | 54.52 | 54.25 | 54.28 | 1967.0 |
| 2023-03-19 23:00:00 | CL | Futures | 54.28 | 54.32 | 54.0 | 54.02 | 2794.0 |
| 2023-03-19 23:30:00 | CL | Futures | 54.02 | 54.08 | 53.98 | 54.01 | 1083.0 |
| 2023-03-19 18:00:00 | GC | Futures | 2310.5 | 2316.1 | 2302.7 | 2308.4 | 6905.0 |
| 2023-03-19 18:30:00 | GC | Futures | 2308.2 | 2308.4 | 2298.3 | 2300.8 | 4657.0 |
> showing 50 of 825 rows — these rows as CSV