PREVIEW / futures_1hour / 2021-07-04
file: by_date/futures_1hour/2021/2021-07-04.parquet size: 16 KB rows: 324
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-07-04 18:00:00 | ES | Futures | 4889.39 | 4891.36 | 4887.14 | 4889.39 | 3322.0 |
| 2021-07-04 19:00:00 | ES | Futures | 4889.39 | 4889.96 | 4886.58 | 4887.42 | 1946.0 |
| 2021-07-04 20:00:00 | ES | Futures | 4887.42 | 4887.7 | 4882.07 | 4885.17 | 6991.0 |
| 2021-07-04 21:00:00 | ES | Futures | 4885.17 | 4886.58 | 4884.33 | 4884.61 | 4843.0 |
| 2021-07-04 22:00:00 | ES | Futures | 4884.61 | 4885.45 | 4883.76 | 4884.04 | 2538.0 |
| 2021-07-04 23:00:00 | ES | Futures | 4884.33 | 4885.45 | 4883.2 | 4884.61 | 2942.0 |
| 2021-07-04 18:00:00 | NQ | Futures | 17038.18 | 17058.46 | 17034.42 | 17050.64 | 2508.0 |
| 2021-07-04 19:00:00 | NQ | Futures | 17050.35 | 17058.17 | 17046.0 | 17050.35 | 1232.0 |
| 2021-07-04 20:00:00 | NQ | Futures | 17050.64 | 17054.98 | 17039.05 | 17046.58 | 2462.0 |
| 2021-07-04 21:00:00 | NQ | Futures | 17046.87 | 17049.77 | 17040.5 | 17042.82 | 1957.0 |
| 2021-07-04 22:00:00 | NQ | Futures | 17042.53 | 17046.58 | 17037.89 | 17041.66 | 1570.0 |
| 2021-07-04 23:00:00 | NQ | Futures | 17041.66 | 17044.56 | 17028.91 | 17036.15 | 2377.0 |
| 2021-07-04 18:00:00 | YM | Futures | 38741.8 | 38741.8 | 38713.9 | 38724.0 | 713.0 |
| 2021-07-04 19:00:00 | YM | Futures | 38725.1 | 38731.8 | 38697.1 | 38705.0 | 517.0 |
| 2021-07-04 20:00:00 | YM | Futures | 38705.0 | 38705.0 | 38642.4 | 38679.3 | 2538.0 |
| 2021-07-04 21:00:00 | YM | Futures | 38678.1 | 38698.3 | 38672.6 | 38681.5 | 1036.0 |
| 2021-07-04 22:00:00 | YM | Futures | 38681.5 | 38681.5 | 38665.9 | 38671.4 | 509.0 |
| 2021-07-04 23:00:00 | YM | Futures | 38673.7 | 38688.2 | 38672.6 | 38679.3 | 365.0 |
| 2021-07-04 18:00:00 | CL | Futures | 51.37 | 51.37 | 51.12 | 51.28 | 2648.0 |
| 2021-07-04 19:00:00 | CL | Futures | 51.29 | 51.29 | 51.21 | 51.22 | 700.0 |
| 2021-07-04 20:00:00 | CL | Futures | 51.22 | 51.23 | 51.03 | 51.14 | 2550.0 |
| 2021-07-04 21:00:00 | CL | Futures | 51.13 | 51.15 | 50.96 | 51.12 | 6027.0 |
| 2021-07-04 22:00:00 | CL | Futures | 51.12 | 51.23 | 51.1 | 51.15 | 3553.0 |
| 2021-07-04 23:00:00 | CL | Futures | 51.15 | 51.2 | 51.13 | 51.18 | 1628.0 |
| 2021-07-04 18:00:00 | GC | Futures | 2156.7 | 2157.3 | 2154.6 | 2154.7 | 859.0 |
| 2021-07-04 19:00:00 | GC | Futures | 2154.7 | 2156.5 | 2154.6 | 2155.4 | 928.0 |
| 2021-07-04 20:00:00 | GC | Futures | 2155.6 | 2155.6 | 2153.3 | 2155.1 | 1373.0 |
| 2021-07-04 21:00:00 | GC | Futures | 2155.2 | 2160.4 | 2154.1 | 2159.5 | 4763.0 |
| 2021-07-04 22:00:00 | GC | Futures | 2159.5 | 2159.8 | 2156.7 | 2157.5 | 2548.0 |
| 2021-07-04 23:00:00 | GC | Futures | 2157.5 | 2158.1 | 2154.4 | 2154.5 | 1553.0 |
| 2021-07-04 18:00:00 | ZN | Futures | 134.988987 | 135.004875 | 134.941321 | 134.941321 | 6738.0 |
| 2021-07-04 19:00:00 | ZN | Futures | 134.941321 | 134.988987 | 134.941321 | 134.988987 | 2480.0 |
| 2021-07-04 20:00:00 | ZN | Futures | 134.973098 | 135.036652 | 134.973098 | 135.036652 | 4646.0 |
| 2021-07-04 21:00:00 | ZN | Futures | 135.036652 | 135.036652 | 134.988987 | 134.988987 | 6407.0 |
| 2021-07-04 22:00:00 | ZN | Futures | 134.988987 | 135.004875 | 134.988987 | 135.004875 | 2562.0 |
| 2021-07-04 23:00:00 | ZN | Futures | 135.004875 | 135.004875 | 134.957209 | 134.973098 | 3953.0 |
> showing 36 of 324 rows — these rows as CSV