PREVIEW / futures_1hour / 2021-04-18
file: by_date/futures_1hour/2021/2021-04-18.parquet size: 18 KB rows: 383
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-18 18:00:00 | ES | Futures | 4680.95 | 4684.88 | 4678.7 | 4684.32 | 8360.0 |
| 2021-04-18 19:00:00 | ES | Futures | 4684.6 | 4685.16 | 4680.11 | 4680.39 | 5101.0 |
| 2021-04-18 20:00:00 | ES | Futures | 4680.39 | 4682.92 | 4676.17 | 4682.07 | 11974.0 |
| 2021-04-18 21:00:00 | ES | Futures | 4682.07 | 4684.88 | 4678.42 | 4683.76 | 11094.0 |
| 2021-04-18 22:00:00 | ES | Futures | 4683.48 | 4686.85 | 4682.92 | 4685.73 | 7507.0 |
| 2021-04-18 23:00:00 | ES | Futures | 4685.73 | 4688.54 | 4685.44 | 4686.57 | 6437.0 |
| 2021-04-18 18:00:00 | NQ | Futures | 16199.0 | 16209.42 | 16180.76 | 16202.76 | 4771.0 |
| 2021-04-18 19:00:00 | NQ | Futures | 16203.34 | 16218.68 | 16197.55 | 16202.18 | 3088.0 |
| 2021-04-18 20:00:00 | NQ | Futures | 16201.02 | 16221.29 | 16185.1 | 16217.24 | 5718.0 |
| 2021-04-18 21:00:00 | NQ | Futures | 16217.24 | 16235.76 | 16197.84 | 16227.66 | 6112.0 |
| 2021-04-18 22:00:00 | NQ | Futures | 16227.08 | 16254.29 | 16224.47 | 16251.4 | 4908.0 |
| 2021-04-18 23:00:00 | NQ | Futures | 16251.69 | 16272.24 | 16247.05 | 16261.82 | 4440.0 |
| 2021-04-18 18:00:00 | YM | Futures | 37886.5 | 37914.4 | 37867.6 | 37904.4 | 1550.0 |
| 2021-04-18 19:00:00 | YM | Futures | 37904.4 | 37904.4 | 37853.1 | 37855.3 | 1310.0 |
| 2021-04-18 20:00:00 | YM | Futures | 37854.2 | 37872.1 | 37826.4 | 37858.7 | 2195.0 |
| 2021-04-18 21:00:00 | YM | Futures | 37859.8 | 37869.8 | 37832.0 | 37859.8 | 1577.0 |
| 2021-04-18 22:00:00 | YM | Futures | 37858.7 | 37877.6 | 37844.2 | 37854.2 | 1531.0 |
| 2021-04-18 23:00:00 | YM | Futures | 37854.2 | 37872.1 | 37848.7 | 37854.2 | 1232.0 |
| 2021-04-18 18:00:00 | CL | Futures | 42.71 | 42.83 | 42.59 | 42.62 | 3801.0 |
| 2021-04-18 19:00:00 | CL | Futures | 42.62 | 42.69 | 42.6 | 42.62 | 1328.0 |
| 2021-04-18 20:00:00 | CL | Futures | 42.61 | 42.67 | 42.58 | 42.62 | 2877.0 |
| 2021-04-18 21:00:00 | CL | Futures | 42.62 | 42.68 | 42.48 | 42.66 | 6057.0 |
| 2021-04-18 22:00:00 | CL | Futures | 42.66 | 42.77 | 42.62 | 42.71 | 3621.0 |
| 2021-04-18 23:00:00 | CL | Futures | 42.71 | 42.75 | 42.65 | 42.68 | 1697.0 |
| 2021-04-18 18:00:00 | GC | Futures | 2148.9 | 2149.0 | 2145.4 | 2145.6 | 1609.0 |
| 2021-04-18 19:00:00 | GC | Futures | 2145.5 | 2149.0 | 2144.9 | 2147.0 | 1590.0 |
| 2021-04-18 20:00:00 | GC | Futures | 2146.9 | 2155.1 | 2146.4 | 2153.3 | 4639.0 |
| 2021-04-18 21:00:00 | GC | Futures | 2153.3 | 2154.7 | 2142.2 | 2144.8 | 10635.0 |
| 2021-04-18 22:00:00 | GC | Futures | 2144.9 | 2149.7 | 2144.6 | 2149.7 | 4110.0 |
| 2021-04-18 23:00:00 | GC | Futures | 2149.6 | 2150.2 | 2147.7 | 2147.8 | 1909.0 |
| 2021-04-18 18:00:00 | ZN | Futures | 133.690618 | 133.73797 | 133.611697 | 133.643265 | 11186.0 |
| 2021-04-18 19:00:00 | ZN | Futures | 133.659049 | 133.769538 | 133.659049 | 133.690618 | 19012.0 |
| 2021-04-18 20:00:00 | ZN | Futures | 133.706402 | 133.801106 | 133.706402 | 133.785322 | 13813.0 |
| 2021-04-18 21:00:00 | ZN | Futures | 133.785322 | 133.832674 | 133.785322 | 133.801106 | 13632.0 |
| 2021-04-18 22:00:00 | ZN | Futures | 133.801106 | 133.81689 | 133.769538 | 133.785322 | 11737.0 |
| 2021-04-18 23:00:00 | ZN | Futures | 133.801106 | 133.801106 | 133.769538 | 133.769538 | 4602.0 |
> showing 36 of 383 rows — these rows as CSV