PREVIEW / futures_1hour / 2021-04-25
file: by_date/futures_1hour/2021/2021-04-25.parquet size: 18 KB rows: 381
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-25 18:00:00 | ES | Futures | 4687.41 | 4689.66 | 4684.32 | 4686.85 | 7049.0 |
| 2021-04-25 19:00:00 | ES | Futures | 4686.85 | 4687.97 | 4682.07 | 4682.92 | 4775.0 |
| 2021-04-25 20:00:00 | ES | Futures | 4682.92 | 4688.25 | 4680.39 | 4686.57 | 9770.0 |
| 2021-04-25 21:00:00 | ES | Futures | 4686.57 | 4691.34 | 4683.76 | 4689.94 | 10542.0 |
| 2021-04-25 22:00:00 | ES | Futures | 4690.22 | 4693.03 | 4689.66 | 4691.91 | 6484.0 |
| 2021-04-25 23:00:00 | ES | Futures | 4691.91 | 4693.03 | 4690.78 | 4691.63 | 3290.0 |
| 2021-04-25 18:00:00 | NQ | Futures | 16118.81 | 16127.78 | 16103.46 | 16119.97 | 3628.0 |
| 2021-04-25 19:00:00 | NQ | Futures | 16119.68 | 16126.05 | 16103.75 | 16108.1 | 2487.0 |
| 2021-04-25 20:00:00 | NQ | Futures | 16108.68 | 16136.18 | 16101.73 | 16128.94 | 4231.0 |
| 2021-04-25 21:00:00 | NQ | Futures | 16128.36 | 16144.57 | 16115.62 | 16139.36 | 4330.0 |
| 2021-04-25 22:00:00 | NQ | Futures | 16139.94 | 16147.18 | 16137.05 | 16137.63 | 2395.0 |
| 2021-04-25 23:00:00 | NQ | Futures | 16137.91 | 16141.97 | 16131.55 | 16132.7 | 1426.0 |
| 2021-04-25 18:00:00 | YM | Futures | 37818.6 | 37827.5 | 37789.6 | 37795.2 | 1115.0 |
| 2021-04-25 19:00:00 | YM | Futures | 37796.3 | 37803.0 | 37762.9 | 37765.1 | 820.0 |
| 2021-04-25 20:00:00 | YM | Futures | 37767.4 | 37811.9 | 37747.3 | 37790.7 | 1622.0 |
| 2021-04-25 21:00:00 | YM | Futures | 37788.5 | 37829.7 | 37774.0 | 37820.8 | 1432.0 |
| 2021-04-25 22:00:00 | YM | Futures | 37821.9 | 37850.9 | 37816.4 | 37843.1 | 948.0 |
| 2021-04-25 23:00:00 | YM | Futures | 37843.1 | 37853.1 | 37836.4 | 37848.7 | 564.0 |
| 2021-04-25 18:00:00 | CL | Futures | 42.07 | 42.2 | 42.07 | 42.08 | 1797.0 |
| 2021-04-25 19:00:00 | CL | Futures | 42.08 | 42.08 | 41.97 | 41.98 | 2146.0 |
| 2021-04-25 20:00:00 | CL | Futures | 41.98 | 42.12 | 41.97 | 42.09 | 2029.0 |
| 2021-04-25 21:00:00 | CL | Futures | 42.09 | 42.24 | 42.07 | 42.15 | 6725.0 |
| 2021-04-25 22:00:00 | CL | Futures | 42.15 | 42.18 | 42.04 | 42.05 | 2856.0 |
| 2021-04-25 23:00:00 | CL | Futures | 42.05 | 42.05 | 41.95 | 41.97 | 3912.0 |
| 2021-04-25 18:00:00 | GC | Futures | 2145.6 | 2146.0 | 2143.3 | 2143.7 | 1270.0 |
| 2021-04-25 19:00:00 | GC | Futures | 2143.5 | 2144.8 | 2142.6 | 2143.9 | 1087.0 |
| 2021-04-25 20:00:00 | GC | Futures | 2143.9 | 2149.0 | 2143.8 | 2148.1 | 2303.0 |
| 2021-04-25 21:00:00 | GC | Futures | 2148.0 | 2151.5 | 2147.4 | 2150.7 | 4756.0 |
| 2021-04-25 22:00:00 | GC | Futures | 2150.7 | 2152.2 | 2148.9 | 2150.8 | 2515.0 |
| 2021-04-25 23:00:00 | GC | Futures | 2150.8 | 2153.8 | 2149.7 | 2151.4 | 2980.0 |
| 2021-04-25 18:00:00 | ZN | Futures | 133.73797 | 133.785322 | 133.706402 | 133.769538 | 10430.0 |
| 2021-04-25 19:00:00 | ZN | Futures | 133.769538 | 133.785322 | 133.753754 | 133.769538 | 7062.0 |
| 2021-04-25 20:00:00 | ZN | Futures | 133.769538 | 133.81689 | 133.73797 | 133.769538 | 14708.0 |
| 2021-04-25 21:00:00 | ZN | Futures | 133.769538 | 133.769538 | 133.73797 | 133.73797 | 11326.0 |
| 2021-04-25 22:00:00 | ZN | Futures | 133.753754 | 133.753754 | 133.674834 | 133.690618 | 12209.0 |
| 2021-04-25 23:00:00 | ZN | Futures | 133.690618 | 133.706402 | 133.659049 | 133.674834 | 11951.0 |
> showing 36 of 381 rows — these rows as CSV