PREVIEW / futures_1hour / 2021-04-02
file: by_date/futures_1hour/2021/2021-04-02.parquet size: 18 KB rows: 397
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-04-02 00:00:00 | ES | Futures | 4514.05 | 4514.33 | 4513.77 | 4514.33 | 2074.0 |
| 2021-04-02 01:00:00 | ES | Futures | 4514.05 | 4516.86 | 4512.93 | 4516.02 | 2965.0 |
| 2021-04-02 02:00:00 | ES | Futures | 4516.3 | 4519.11 | 4516.02 | 4517.42 | 2342.0 |
| 2021-04-02 03:00:00 | ES | Futures | 4517.14 | 4518.55 | 4516.86 | 4517.71 | 1176.0 |
| 2021-04-02 04:00:00 | ES | Futures | 4517.71 | 4520.23 | 4515.74 | 4520.23 | 1374.0 |
| 2021-04-02 05:00:00 | ES | Futures | 4520.23 | 4520.23 | 4517.42 | 4519.11 | 735.0 |
| 2021-04-02 06:00:00 | ES | Futures | 4518.83 | 4519.67 | 4516.3 | 4519.67 | 1253.0 |
| 2021-04-02 07:00:00 | ES | Futures | 4519.67 | 4520.8 | 4518.27 | 4520.8 | 2112.0 |
| 2021-04-02 08:00:00 | ES | Futures | 4520.8 | 4538.22 | 4517.99 | 4531.47 | 23724.0 |
| 2021-04-02 09:00:00 | ES | Futures | 4531.47 | 4532.04 | 4524.17 | 4526.13 | 6858.0 |
| 2021-04-02 00:00:00 | NQ | Futures | 15469.76 | 15476.71 | 15468.31 | 15474.1 | 1407.0 |
| 2021-04-02 01:00:00 | NQ | Futures | 15473.81 | 15474.1 | 15451.52 | 15456.44 | 2677.0 |
| 2021-04-02 02:00:00 | NQ | Futures | 15456.15 | 15466.0 | 15455.86 | 15461.36 | 1562.0 |
| 2021-04-02 03:00:00 | NQ | Futures | 15460.79 | 15481.92 | 15460.79 | 15475.26 | 2179.0 |
| 2021-04-02 04:00:00 | NQ | Futures | 15475.55 | 15480.76 | 15466.86 | 15480.76 | 1265.0 |
| 2021-04-02 05:00:00 | NQ | Futures | 15480.47 | 15480.76 | 15470.63 | 15472.08 | 703.0 |
| 2021-04-02 06:00:00 | NQ | Futures | 15472.65 | 15475.84 | 15453.26 | 15463.39 | 1856.0 |
| 2021-04-02 07:00:00 | NQ | Futures | 15463.1 | 15472.36 | 15459.05 | 15470.34 | 1623.0 |
| 2021-04-02 08:00:00 | NQ | Futures | 15470.63 | 15508.84 | 15450.36 | 15489.73 | 10034.0 |
| 2021-04-02 09:00:00 | NQ | Futures | 15489.16 | 15489.45 | 15452.39 | 15452.39 | 2526.0 |
| 2021-04-02 00:00:00 | YM | Futures | 36790.5 | 36792.8 | 36778.3 | 36783.9 | 317.0 |
| 2021-04-02 01:00:00 | YM | Futures | 36782.7 | 36835.1 | 36778.3 | 36832.9 | 1005.0 |
| 2021-04-02 02:00:00 | YM | Futures | 36832.9 | 36854.0 | 36830.6 | 36834.0 | 815.0 |
| 2021-04-02 03:00:00 | YM | Futures | 36835.1 | 36849.6 | 36822.8 | 36826.2 | 490.0 |
| 2021-04-02 04:00:00 | YM | Futures | 36826.2 | 36849.6 | 36816.2 | 36848.5 | 368.0 |
| 2021-04-02 05:00:00 | YM | Futures | 36850.7 | 36850.7 | 36825.1 | 36841.8 | 318.0 |
| 2021-04-02 06:00:00 | YM | Futures | 36840.7 | 36870.7 | 36830.6 | 36868.5 | 610.0 |
| 2021-04-02 07:00:00 | YM | Futures | 36868.5 | 36876.3 | 36855.1 | 36867.4 | 816.0 |
| 2021-04-02 08:00:00 | YM | Futures | 36867.4 | 37050.1 | 36842.9 | 36989.9 | 6232.0 |
| 2021-04-02 09:00:00 | YM | Futures | 36991.0 | 37008.8 | 36957.6 | 36967.6 | 1038.0 |
| 2021-04-02 00:00:00 | ZN | Futures | 132.68044 | 132.696225 | 132.68044 | 132.68044 | 3195.0 |
| 2021-04-02 01:00:00 | ZN | Futures | 132.68044 | 132.696225 | 132.664656 | 132.68044 | 2450.0 |
| 2021-04-02 02:00:00 | ZN | Futures | 132.68044 | 132.696225 | 132.664656 | 132.68044 | 3970.0 |
| 2021-04-02 03:00:00 | ZN | Futures | 132.68044 | 132.712009 | 132.664656 | 132.712009 | 8189.0 |
| 2021-04-02 04:00:00 | ZN | Futures | 132.696225 | 132.727793 | 132.68044 | 132.696225 | 4369.0 |
| 2021-04-02 05:00:00 | ZN | Futures | 132.712009 | 132.727793 | 132.712009 | 132.712009 | 3701.0 |
| 2021-04-02 06:00:00 | ZN | Futures | 132.727793 | 132.759361 | 132.712009 | 132.727793 | 8074.0 |
| 2021-04-02 07:00:00 | ZN | Futures | 132.727793 | 132.743577 | 132.696225 | 132.712009 | 17400.0 |
| 2021-04-02 08:00:00 | ZN | Futures | 132.727793 | 132.964553 | 132.538384 | 132.554168 | 170072.0 |
| 2021-04-02 09:00:00 | ZN | Futures | 132.554168 | 132.569952 | 132.301624 | 132.301624 | 139650.0 |
| 2021-04-02 10:00:00 | ZN | Futures | 132.317408 | 132.36476 | 132.254272 | 132.270056 | 72321.0 |
| 2021-04-02 11:00:00 | ZN | Futures | 132.28584 | 132.333192 | 132.270056 | 132.333192 | 20499.0 |
> showing 42 of 397 rows — these rows as CSV