PREVIEW / futures_1hour / 2021-03-07
file: by_date/futures_1hour/2021/2021-03-07.parquet size: 18 KB rows: 395
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-03-07 18:00:00 | ES | Futures | 4327.59 | 4340.51 | 4323.1 | 4327.03 | 30482.0 |
| 2021-03-07 19:00:00 | ES | Futures | 4327.03 | 4327.03 | 4309.91 | 4323.39 | 23085.0 |
| 2021-03-07 20:00:00 | ES | Futures | 4323.39 | 4327.88 | 4313.0 | 4321.7 | 22777.0 |
| 2021-03-07 21:00:00 | ES | Futures | 4321.98 | 4323.39 | 4295.04 | 4305.7 | 28029.0 |
| 2021-03-07 22:00:00 | ES | Futures | 4305.42 | 4306.83 | 4292.23 | 4299.53 | 20051.0 |
| 2021-03-07 23:00:00 | ES | Futures | 4299.53 | 4303.74 | 4293.07 | 4298.41 | 11271.0 |
| 2021-03-07 18:00:00 | NQ | Futures | 14720.6 | 14774.15 | 14653.16 | 14667.63 | 14016.0 |
| 2021-03-07 19:00:00 | NQ | Futures | 14668.5 | 14673.13 | 14589.2 | 14651.14 | 15194.0 |
| 2021-03-07 20:00:00 | NQ | Futures | 14649.4 | 14682.97 | 14605.69 | 14642.74 | 11838.0 |
| 2021-03-07 21:00:00 | NQ | Futures | 14645.35 | 14652.87 | 14502.08 | 14544.05 | 13346.0 |
| 2021-03-07 22:00:00 | NQ | Futures | 14544.33 | 14558.23 | 14487.03 | 14518.29 | 11837.0 |
| 2021-03-07 23:00:00 | NQ | Futures | 14518.29 | 14552.44 | 14490.5 | 14522.92 | 7768.0 |
| 2021-03-07 18:00:00 | YM | Futures | 35008.4 | 35167.0 | 35008.4 | 35083.8 | 6027.0 |
| 2021-03-07 19:00:00 | YM | Futures | 35082.7 | 35083.8 | 34960.7 | 35057.2 | 5209.0 |
| 2021-03-07 20:00:00 | YM | Futures | 35055.0 | 35089.4 | 34986.2 | 35055.0 | 3976.0 |
| 2021-03-07 21:00:00 | YM | Futures | 35053.9 | 35069.4 | 34895.3 | 34968.5 | 5394.0 |
| 2021-03-07 22:00:00 | YM | Futures | 34968.5 | 34974.0 | 34873.1 | 34921.9 | 4679.0 |
| 2021-03-07 23:00:00 | YM | Futures | 34920.8 | 34948.5 | 34878.6 | 34909.7 | 2190.0 |
| 2021-03-07 18:00:00 | CL | Futures | 45.22 | 46.02 | 45.21 | 45.54 | 11718.0 |
| 2021-03-07 19:00:00 | CL | Futures | 45.54 | 45.89 | 45.51 | 45.82 | 7561.0 |
| 2021-03-07 20:00:00 | CL | Futures | 45.81 | 46.0 | 45.61 | 45.97 | 11443.0 |
| 2021-03-07 21:00:00 | CL | Futures | 45.98 | 46.1 | 45.89 | 45.97 | 10051.0 |
| 2021-03-07 22:00:00 | CL | Futures | 45.97 | 45.99 | 45.66 | 45.79 | 7246.0 |
| 2021-03-07 23:00:00 | CL | Futures | 45.79 | 45.83 | 45.64 | 45.74 | 4309.0 |
| 2021-03-07 18:00:00 | GC | Futures | 2058.2 | 2070.8 | 2056.7 | 2062.7 | 6700.0 |
| 2021-03-07 19:00:00 | GC | Futures | 2062.7 | 2063.3 | 2059.4 | 2061.9 | 3138.0 |
| 2021-03-07 20:00:00 | GC | Futures | 2061.7 | 2069.4 | 2061.6 | 2068.9 | 8416.0 |
| 2021-03-07 21:00:00 | GC | Futures | 2069.0 | 2070.0 | 2061.6 | 2064.4 | 7656.0 |
| 2021-03-07 22:00:00 | GC | Futures | 2064.5 | 2064.9 | 2059.3 | 2059.6 | 4024.0 |
| 2021-03-07 23:00:00 | GC | Futures | 2059.7 | 2062.2 | 2057.9 | 2062.1 | 3331.0 |
| 2021-03-07 18:00:00 | ZN | Futures | 133.390977 | 133.390977 | 133.328359 | 133.344013 | 117.0 |
| 2021-03-07 19:00:00 | ZN | Futures | 133.43794 | 133.469248 | 133.43794 | 133.43794 | 38.0 |
| 2021-03-07 20:00:00 | ZN | Futures | 133.43794 | 133.453594 | 133.43794 | 133.453594 | 4.0 |
| 2021-03-07 21:00:00 | ZN | Futures | 133.422285 | 133.422285 | 133.422285 | 133.422285 | 1.0 |
| 2021-03-07 22:00:00 | ZN | Futures | 133.43794 | 133.453594 | 133.43794 | 133.453594 | 60.0 |
| 2021-03-07 23:00:00 | ZN | Futures | 133.406631 | 133.422285 | 133.406631 | 133.422285 | 55.0 |
> showing 36 of 395 rows — these rows as CSV