PREVIEW / futures_1hour / 2021-02-28
file: by_date/futures_1hour/2021/2021-02-28.parquet size: 19 KB rows: 408
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 |
|---|---|---|---|---|---|---|---|
| 2021-02-28 18:00:00 | ES | Futures | 4285.5 | 4307.67 | 4280.16 | 4306.83 | 30871.0 |
| 2021-02-28 19:00:00 | ES | Futures | 4306.83 | 4313.84 | 4303.18 | 4312.16 | 19606.0 |
| 2021-02-28 20:00:00 | ES | Futures | 4311.88 | 4318.61 | 4307.39 | 4316.65 | 17380.0 |
| 2021-02-28 21:00:00 | ES | Futures | 4316.37 | 4318.89 | 4309.35 | 4310.19 | 11152.0 |
| 2021-02-28 22:00:00 | ES | Futures | 4310.19 | 4315.81 | 4307.11 | 4309.91 | 12548.0 |
| 2021-02-28 23:00:00 | ES | Futures | 4309.91 | 4314.68 | 4304.58 | 4308.23 | 9345.0 |
| 2021-02-28 18:00:00 | NQ | Futures | 15001.35 | 15059.82 | 14988.33 | 15055.19 | 10818.0 |
| 2021-02-28 19:00:00 | NQ | Futures | 15056.34 | 15111.05 | 15047.95 | 15108.15 | 9528.0 |
| 2021-02-28 20:00:00 | NQ | Futures | 15108.15 | 15149.83 | 15082.68 | 15131.02 | 10452.0 |
| 2021-02-28 21:00:00 | NQ | Futures | 15130.73 | 15139.41 | 15099.18 | 15102.07 | 5826.0 |
| 2021-02-28 22:00:00 | NQ | Futures | 15102.36 | 15146.65 | 15097.15 | 15109.89 | 6476.0 |
| 2021-02-28 23:00:00 | NQ | Futures | 15110.76 | 15127.83 | 15086.44 | 15096.86 | 5128.0 |
| 2021-02-28 18:00:00 | YM | Futures | 34364.0 | 34494.9 | 34311.8 | 34488.2 | 5676.0 |
| 2021-02-28 19:00:00 | YM | Futures | 34493.8 | 34538.1 | 34477.1 | 34525.9 | 4362.0 |
| 2021-02-28 20:00:00 | YM | Futures | 34525.9 | 34565.8 | 34497.1 | 34551.4 | 3602.0 |
| 2021-02-28 21:00:00 | YM | Futures | 34549.2 | 34572.5 | 34517.0 | 34521.5 | 2437.0 |
| 2021-02-28 22:00:00 | YM | Futures | 34521.5 | 34555.9 | 34492.6 | 34519.3 | 2564.0 |
| 2021-02-28 23:00:00 | YM | Futures | 34518.2 | 34549.2 | 34477.1 | 34502.6 | 2091.0 |
| 2021-02-28 18:00:00 | CL | Futures | 42.01 | 42.4 | 41.94 | 42.38 | 6097.0 |
| 2021-02-28 19:00:00 | CL | Futures | 42.39 | 42.5 | 42.37 | 42.48 | 3740.0 |
| 2021-02-28 20:00:00 | CL | Futures | 42.48 | 42.67 | 42.45 | 42.49 | 12948.0 |
| 2021-02-28 21:00:00 | CL | Futures | 42.49 | 42.54 | 42.4 | 42.41 | 4550.0 |
| 2021-02-28 22:00:00 | CL | Futures | 42.41 | 42.47 | 42.36 | 42.41 | 3831.0 |
| 2021-02-28 23:00:00 | CL | Futures | 42.41 | 42.41 | 42.29 | 42.33 | 2689.0 |
| 2021-02-28 18:00:00 | GC | Futures | 2096.0 | 2102.6 | 2094.5 | 2102.0 | 5420.0 |
| 2021-02-28 19:00:00 | GC | Futures | 2102.0 | 2104.8 | 2099.2 | 2100.3 | 3964.0 |
| 2021-02-28 20:00:00 | GC | Futures | 2100.2 | 2108.3 | 2100.2 | 2108.1 | 7714.0 |
| 2021-02-28 21:00:00 | GC | Futures | 2108.1 | 2112.4 | 2107.3 | 2111.2 | 6985.0 |
| 2021-02-28 22:00:00 | GC | Futures | 2111.2 | 2116.3 | 2111.0 | 2115.6 | 4754.0 |
| 2021-02-28 23:00:00 | GC | Futures | 2115.4 | 2115.9 | 2111.4 | 2114.1 | 3965.0 |
| 2021-02-28 18:00:00 | ZN | Futures | 134.518092 | 134.705944 | 134.43982 | 134.705944 | 210.0 |
| 2021-02-28 19:00:00 | ZN | Futures | 134.721599 | 134.83118 | 134.627673 | 134.643327 | 745.0 |
| 2021-02-28 20:00:00 | ZN | Futures | 134.658981 | 134.705944 | 134.627673 | 134.643327 | 205.0 |
| 2021-02-28 21:00:00 | ZN | Futures | 134.627673 | 134.627673 | 134.533746 | 134.627673 | 126.0 |
| 2021-02-28 22:00:00 | ZN | Futures | 134.643327 | 134.705944 | 134.627673 | 134.705944 | 212.0 |
| 2021-02-28 23:00:00 | ZN | Futures | 134.69029 | 134.705944 | 134.658981 | 134.658981 | 20.0 |
> showing 36 of 408 rows — these rows as CSV