PREVIEW / futures_1hour / 2021-10-03
file: by_date/futures_1hour/2021/2021-10-03.parquet size: 19 KB rows: 396
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-10-03 18:00:00 | ES | Futures | 4909.37 | 4924.04 | 4907.67 | 4922.63 | 17520.0 |
| 2021-10-03 19:00:00 | ES | Futures | 4922.63 | 4923.76 | 4917.83 | 4919.81 | 7673.0 |
| 2021-10-03 20:00:00 | ES | Futures | 4919.81 | 4920.37 | 4899.77 | 4903.44 | 23728.0 |
| 2021-10-03 21:00:00 | ES | Futures | 4903.44 | 4906.54 | 4883.97 | 4888.77 | 27255.0 |
| 2021-10-03 22:00:00 | ES | Futures | 4889.05 | 4901.18 | 4885.38 | 4898.08 | 18920.0 |
| 2021-10-03 23:00:00 | ES | Futures | 4898.08 | 4898.64 | 4886.79 | 4888.48 | 10796.0 |
| 2021-10-03 18:00:00 | NQ | Futures | 17139.79 | 17194.27 | 17126.74 | 17181.23 | 7815.0 |
| 2021-10-03 19:00:00 | NQ | Futures | 17182.1 | 17197.75 | 17167.32 | 17173.7 | 3346.0 |
| 2021-10-03 20:00:00 | NQ | Futures | 17174.56 | 17178.62 | 17109.65 | 17120.37 | 8015.0 |
| 2021-10-03 21:00:00 | NQ | Futures | 17119.79 | 17133.12 | 17048.2 | 17070.23 | 10982.0 |
| 2021-10-03 22:00:00 | NQ | Futures | 17069.07 | 17099.79 | 17049.94 | 17081.24 | 6625.0 |
| 2021-10-03 23:00:00 | NQ | Futures | 17080.95 | 17082.69 | 17036.61 | 17043.57 | 5303.0 |
| 2021-10-03 18:00:00 | YM | Futures | 38368.7 | 38439.3 | 38330.5 | 38428.1 | 2683.0 |
| 2021-10-03 19:00:00 | YM | Futures | 38429.2 | 38435.9 | 38396.7 | 38405.7 | 1396.0 |
| 2021-10-03 20:00:00 | YM | Futures | 38406.8 | 38412.4 | 38231.9 | 38267.8 | 3687.0 |
| 2021-10-03 21:00:00 | YM | Futures | 38266.7 | 38291.3 | 38125.4 | 38164.7 | 4192.0 |
| 2021-10-03 22:00:00 | YM | Futures | 38165.8 | 38273.4 | 38136.6 | 38253.2 | 2845.0 |
| 2021-10-03 23:00:00 | YM | Futures | 38254.3 | 38261.1 | 38170.3 | 38181.5 | 1919.0 |
| 2021-10-03 18:00:00 | CL | Futures | 52.63 | 52.83 | 52.61 | 52.61 | 3639.0 |
| 2021-10-03 19:00:00 | CL | Futures | 52.61 | 52.62 | 52.52 | 52.58 | 1457.0 |
| 2021-10-03 20:00:00 | CL | Futures | 52.59 | 52.61 | 52.35 | 52.42 | 3692.0 |
| 2021-10-03 21:00:00 | CL | Futures | 52.43 | 52.53 | 52.31 | 52.37 | 3607.0 |
| 2021-10-03 22:00:00 | CL | Futures | 52.37 | 52.47 | 52.34 | 52.44 | 2457.0 |
| 2021-10-03 23:00:00 | CL | Futures | 52.44 | 52.49 | 52.37 | 52.41 | 2408.0 |
| 2021-10-03 18:00:00 | GC | Futures | 2121.8 | 2126.3 | 2119.5 | 2124.3 | 3028.0 |
| 2021-10-03 19:00:00 | GC | Futures | 2124.3 | 2125.8 | 2122.9 | 2123.5 | 1299.0 |
| 2021-10-03 20:00:00 | GC | Futures | 2123.2 | 2126.5 | 2122.9 | 2124.4 | 2483.0 |
| 2021-10-03 21:00:00 | GC | Futures | 2124.4 | 2125.9 | 2121.8 | 2121.8 | 2012.0 |
| 2021-10-03 22:00:00 | GC | Futures | 2121.9 | 2122.3 | 2117.1 | 2117.9 | 3815.0 |
| 2021-10-03 23:00:00 | GC | Futures | 2117.9 | 2118.7 | 2116.1 | 2117.5 | 2088.0 |
| 2021-10-03 18:00:00 | ZN | Futures | 135.048282 | 135.096172 | 135.000393 | 135.048282 | 19529.0 |
| 2021-10-03 19:00:00 | ZN | Futures | 135.048282 | 135.112135 | 135.032319 | 135.096172 | 8154.0 |
| 2021-10-03 20:00:00 | ZN | Futures | 135.080209 | 135.128098 | 135.080209 | 135.080209 | 26056.0 |
| 2021-10-03 21:00:00 | ZN | Futures | 135.096172 | 135.112135 | 135.048282 | 135.048282 | 14609.0 |
| 2021-10-03 22:00:00 | ZN | Futures | 135.048282 | 135.064246 | 134.98443 | 135.000393 | 22044.0 |
| 2021-10-03 23:00:00 | ZN | Futures | 135.016356 | 135.016356 | 134.98443 | 134.98443 | 9560.0 |
> showing 36 of 396 rows — these rows as CSV