PREVIEW / futures_1hour / 2020-05-10
file: by_date/futures_1hour/2020/2020-05-10.parquet size: 17 KB rows: 358
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 |
|---|---|---|---|---|---|---|---|
| 2020-05-10 18:00:00 | ES | Futures | 3205.98 | 3214.21 | 3200.77 | 3212.29 | 18619.0 |
| 2020-05-10 19:00:00 | ES | Futures | 3212.29 | 3226.01 | 3209.82 | 3224.92 | 25559.0 |
| 2020-05-10 20:00:00 | ES | Futures | 3224.92 | 3229.31 | 3222.17 | 3228.21 | 18517.0 |
| 2020-05-10 21:00:00 | ES | Futures | 3228.21 | 3234.8 | 3223.82 | 3232.33 | 24461.0 |
| 2020-05-10 22:00:00 | ES | Futures | 3232.33 | 3233.42 | 3227.39 | 3228.48 | 12541.0 |
| 2020-05-10 23:00:00 | ES | Futures | 3228.76 | 3230.41 | 3227.39 | 3229.31 | 6168.0 |
| 2020-05-10 18:00:00 | NQ | Futures | 10505.58 | 10534.71 | 10482.73 | 10531.57 | 5644.0 |
| 2020-05-10 19:00:00 | NQ | Futures | 10531.86 | 10576.99 | 10526.43 | 10572.99 | 7954.0 |
| 2020-05-10 20:00:00 | NQ | Futures | 10572.99 | 10589.56 | 10564.7 | 10585.84 | 6893.0 |
| 2020-05-10 21:00:00 | NQ | Futures | 10586.13 | 10608.69 | 10572.7 | 10602.41 | 8306.0 |
| 2020-05-10 22:00:00 | NQ | Futures | 10602.69 | 10608.12 | 10589.56 | 10592.98 | 5856.0 |
| 2020-05-10 23:00:00 | NQ | Futures | 10592.7 | 10596.98 | 10586.98 | 10595.84 | 2707.0 |
| 2020-05-10 18:00:00 | YM | Futures | 26537.4 | 26609.6 | 26477.1 | 26589.9 | 3322.0 |
| 2020-05-10 19:00:00 | YM | Futures | 26589.9 | 26718.1 | 26581.2 | 26708.2 | 3731.0 |
| 2020-05-10 20:00:00 | YM | Futures | 26709.3 | 26743.3 | 26689.6 | 26735.6 | 3458.0 |
| 2020-05-10 21:00:00 | YM | Futures | 26735.6 | 26803.5 | 26702.7 | 26780.5 | 4160.0 |
| 2020-05-10 22:00:00 | YM | Futures | 26784.9 | 26796.9 | 26748.7 | 26758.6 | 2221.0 |
| 2020-05-10 23:00:00 | YM | Futures | 26757.5 | 26777.2 | 26748.7 | 26773.9 | 1167.0 |
| 2020-05-10 18:00:00 | CL | Futures | 17.31 | 17.5 | 17.06 | 17.24 | 2406.0 |
| 2020-05-10 19:00:00 | CL | Futures | 17.27 | 17.45 | 17.21 | 17.33 | 1324.0 |
| 2020-05-10 20:00:00 | CL | Futures | 17.33 | 17.33 | 16.9 | 16.92 | 2665.0 |
| 2020-05-10 21:00:00 | CL | Futures | 16.92 | 17.16 | 16.8 | 17.14 | 1812.0 |
| 2020-05-10 22:00:00 | CL | Futures | 17.14 | 17.2 | 17.04 | 17.19 | 775.0 |
| 2020-05-10 23:00:00 | CL | Futures | 17.2 | 17.38 | 17.17 | 17.36 | 985.0 |
| 2020-05-10 18:00:00 | GC | Futures | 2128.7 | 2135.3 | 2126.1 | 2131.5 | 2465.0 |
| 2020-05-10 19:00:00 | GC | Futures | 2131.5 | 2134.4 | 2127.1 | 2132.0 | 3145.0 |
| 2020-05-10 20:00:00 | GC | Futures | 2131.9 | 2134.3 | 2129.4 | 2130.8 | 1995.0 |
| 2020-05-10 21:00:00 | GC | Futures | 2130.5 | 2138.4 | 2128.2 | 2136.5 | 4478.0 |
| 2020-05-10 22:00:00 | GC | Futures | 2136.4 | 2137.4 | 2133.7 | 2136.0 | 3068.0 |
| 2020-05-10 23:00:00 | GC | Futures | 2136.0 | 2136.8 | 2131.4 | 2132.8 | 2455.0 |
| 2020-05-10 18:00:00 | ZN | Futures | 138.130457 | 138.161525 | 138.021717 | 138.021717 | 10016.0 |
| 2020-05-10 19:00:00 | ZN | Futures | 138.037252 | 138.06832 | 138.021717 | 138.021717 | 4619.0 |
| 2020-05-10 20:00:00 | ZN | Futures | 138.037252 | 138.037252 | 137.95958 | 137.990649 | 10515.0 |
| 2020-05-10 21:00:00 | ZN | Futures | 137.990649 | 138.037252 | 137.912978 | 137.95958 | 8809.0 |
| 2020-05-10 22:00:00 | ZN | Futures | 137.95958 | 138.021717 | 137.928512 | 137.990649 | 9349.0 |
| 2020-05-10 23:00:00 | ZN | Futures | 137.990649 | 138.021717 | 137.975115 | 137.990649 | 5186.0 |
> showing 36 of 358 rows — these rows as CSV