PREVIEW / futures_1hour / 2023-05-28
file: by_date/futures_1hour/2023/2023-05-28.parquet size: 17 KB rows: 368
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-05-28 18:00:00 | ES | Futures | 4703.64 | 4707.52 | 4692.54 | 4693.93 | 17965.0 |
| 2023-05-28 19:00:00 | ES | Futures | 4694.21 | 4695.59 | 4692.82 | 4693.65 | 4835.0 |
| 2023-05-28 20:00:00 | ES | Futures | 4693.65 | 4697.81 | 4686.99 | 4688.1 | 12392.0 |
| 2023-05-28 21:00:00 | ES | Futures | 4688.38 | 4689.49 | 4684.22 | 4686.99 | 8585.0 |
| 2023-05-28 22:00:00 | ES | Futures | 4686.99 | 4689.21 | 4685.61 | 4687.27 | 4513.0 |
| 2023-05-28 23:00:00 | ES | Futures | 4687.27 | 4689.21 | 4683.94 | 4683.94 | 5245.0 |
| 2023-05-28 18:00:00 | NQ | Futures | 16259.69 | 16284.74 | 16217.45 | 16230.97 | 9311.0 |
| 2023-05-28 19:00:00 | NQ | Futures | 16230.97 | 16249.55 | 16227.59 | 16236.32 | 3374.0 |
| 2023-05-28 20:00:00 | NQ | Futures | 16236.6 | 16269.26 | 16217.45 | 16223.93 | 8089.0 |
| 2023-05-28 21:00:00 | NQ | Futures | 16223.08 | 16237.44 | 16202.53 | 16221.11 | 6743.0 |
| 2023-05-28 22:00:00 | NQ | Futures | 16220.83 | 16229.28 | 16207.6 | 16215.76 | 3475.0 |
| 2023-05-28 23:00:00 | NQ | Futures | 16216.05 | 16221.68 | 16209.01 | 16209.85 | 2747.0 |
| 2023-05-28 18:00:00 | YM | Futures | 36783.6 | 36839.9 | 36731.6 | 36742.7 | 2148.0 |
| 2023-05-28 19:00:00 | YM | Futures | 36744.9 | 36761.5 | 36733.8 | 36742.7 | 1002.0 |
| 2023-05-28 20:00:00 | YM | Futures | 36741.6 | 36757.0 | 36689.6 | 36697.3 | 1150.0 |
| 2023-05-28 21:00:00 | YM | Futures | 36700.7 | 36700.7 | 36674.1 | 36685.2 | 780.0 |
| 2023-05-28 22:00:00 | YM | Futures | 36685.2 | 36699.6 | 36681.9 | 36684.1 | 487.0 |
| 2023-05-28 23:00:00 | YM | Futures | 36685.2 | 36695.1 | 36656.4 | 36657.6 | 477.0 |
| 2023-05-28 18:00:00 | CL | Futures | 59.57 | 59.77 | 59.44 | 59.52 | 2712.0 |
| 2023-05-28 19:00:00 | CL | Futures | 59.53 | 59.57 | 59.44 | 59.56 | 686.0 |
| 2023-05-28 20:00:00 | CL | Futures | 59.57 | 59.62 | 59.53 | 59.58 | 1942.0 |
| 2023-05-28 21:00:00 | CL | Futures | 59.57 | 59.77 | 59.45 | 59.7 | 3567.0 |
| 2023-05-28 22:00:00 | CL | Futures | 59.71 | 59.83 | 59.66 | 59.68 | 2139.0 |
| 2023-05-28 23:00:00 | CL | Futures | 59.68 | 59.72 | 59.59 | 59.61 | 874.0 |
| 2023-05-28 18:00:00 | GC | Futures | 2234.2 | 2237.7 | 2232.6 | 2235.0 | 2305.0 |
| 2023-05-28 19:00:00 | GC | Futures | 2235.0 | 2235.9 | 2234.1 | 2234.4 | 1033.0 |
| 2023-05-28 20:00:00 | GC | Futures | 2234.4 | 2234.7 | 2231.3 | 2231.9 | 2025.0 |
| 2023-05-28 21:00:00 | GC | Futures | 2231.9 | 2237.2 | 2230.4 | 2233.7 | 3567.0 |
| 2023-05-28 22:00:00 | GC | Futures | 2233.8 | 2236.0 | 2233.0 | 2235.9 | 1958.0 |
| 2023-05-28 23:00:00 | GC | Futures | 2236.0 | 2236.9 | 2235.4 | 2236.3 | 1574.0 |
| 2023-05-28 18:00:00 | ZN | Futures | 115.271191 | 115.287219 | 114.99872 | 115.239135 | 15068.0 |
| 2023-05-28 19:00:00 | ZN | Futures | 115.239135 | 115.255163 | 115.191052 | 115.191052 | 3228.0 |
| 2023-05-28 20:00:00 | ZN | Futures | 115.191052 | 115.255163 | 115.142969 | 115.223108 | 5970.0 |
| 2023-05-28 21:00:00 | ZN | Futures | 115.239135 | 115.287219 | 115.223108 | 115.287219 | 4785.0 |
| 2023-05-28 22:00:00 | ZN | Futures | 115.287219 | 115.303246 | 115.255163 | 115.255163 | 2754.0 |
| 2023-05-28 23:00:00 | ZN | Futures | 115.271191 | 115.271191 | 115.20708 | 115.20708 | 2317.0 |
> showing 36 of 368 rows — these rows as CSV