PREVIEW / futures_1hour / 2021-02-21
file: by_date/futures_1hour/2021/2021-02-21.parquet size: 19 KB rows: 400
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-02-21 18:00:00 | ES | Futures | 4384.57 | 4391.31 | 4371.66 | 4382.89 | 21457.0 |
| 2021-02-21 19:00:00 | ES | Futures | 4382.89 | 4388.78 | 4381.2 | 4387.66 | 13103.0 |
| 2021-02-21 20:00:00 | ES | Futures | 4387.66 | 4394.67 | 4380.08 | 4382.89 | 19053.0 |
| 2021-02-21 21:00:00 | ES | Futures | 4382.61 | 4387.94 | 4366.89 | 4371.38 | 24943.0 |
| 2021-02-21 22:00:00 | ES | Futures | 4371.38 | 4374.75 | 4366.89 | 4373.06 | 13544.0 |
| 2021-02-21 23:00:00 | ES | Futures | 4373.34 | 4377.83 | 4371.94 | 4373.9 | 7432.0 |
| 2021-02-21 18:00:00 | NQ | Futures | 15727.83 | 15767.48 | 15684.99 | 15735.93 | 9004.0 |
| 2021-02-21 19:00:00 | NQ | Futures | 15736.22 | 15761.4 | 15728.99 | 15751.56 | 5514.0 |
| 2021-02-21 20:00:00 | NQ | Futures | 15751.56 | 15778.77 | 15716.83 | 15726.38 | 9444.0 |
| 2021-02-21 21:00:00 | NQ | Futures | 15726.09 | 15742.3 | 15661.84 | 15680.07 | 11606.0 |
| 2021-02-21 22:00:00 | NQ | Futures | 15680.65 | 15698.31 | 15665.31 | 15689.33 | 6093.0 |
| 2021-02-21 23:00:00 | NQ | Futures | 15689.05 | 15705.54 | 15672.26 | 15676.89 | 3719.0 |
| 2021-02-21 18:00:00 | YM | Futures | 34895.3 | 34945.2 | 34821.0 | 34890.8 | 3965.0 |
| 2021-02-21 19:00:00 | YM | Futures | 34889.7 | 34925.2 | 34868.7 | 34911.9 | 2491.0 |
| 2021-02-21 20:00:00 | YM | Futures | 34911.9 | 34959.6 | 34868.7 | 34888.6 | 3963.0 |
| 2021-02-21 21:00:00 | YM | Futures | 34887.5 | 34923.0 | 34775.5 | 34813.2 | 4823.0 |
| 2021-02-21 22:00:00 | YM | Futures | 34811.0 | 34829.8 | 34776.6 | 34822.1 | 2565.0 |
| 2021-02-21 23:00:00 | YM | Futures | 34822.1 | 34855.3 | 34821.0 | 34835.4 | 1407.0 |
| 2021-02-21 18:00:00 | CL | Futures | 39.97 | 40.5 | 39.89 | 40.45 | 7969.0 |
| 2021-02-21 19:00:00 | CL | Futures | 40.45 | 40.6 | 40.42 | 40.58 | 5221.0 |
| 2021-02-21 20:00:00 | CL | Futures | 40.58 | 40.72 | 40.46 | 40.51 | 8184.0 |
| 2021-02-21 21:00:00 | CL | Futures | 40.5 | 40.6 | 40.43 | 40.55 | 5823.0 |
| 2021-02-21 22:00:00 | CL | Futures | 40.54 | 40.62 | 40.51 | 40.56 | 5515.0 |
| 2021-02-21 23:00:00 | CL | Futures | 40.57 | 40.69 | 40.56 | 40.68 | 3331.0 |
| 2021-02-21 18:00:00 | GC | Futures | 2155.5 | 2162.0 | 2153.5 | 2156.0 | 4539.0 |
| 2021-02-21 19:00:00 | GC | Futures | 2156.4 | 2160.1 | 2154.7 | 2158.0 | 2809.0 |
| 2021-02-21 20:00:00 | GC | Futures | 2158.0 | 2163.1 | 2157.7 | 2159.2 | 7864.0 |
| 2021-02-21 21:00:00 | GC | Futures | 2159.1 | 2160.8 | 2155.2 | 2155.4 | 6131.0 |
| 2021-02-21 22:00:00 | GC | Futures | 2155.5 | 2158.4 | 2151.4 | 2155.1 | 5403.0 |
| 2021-02-21 23:00:00 | GC | Futures | 2155.0 | 2156.9 | 2154.6 | 2156.4 | 2205.0 |
| 2021-02-21 18:00:00 | ZN | Futures | 135.676516 | 135.707825 | 135.488664 | 135.566935 | 67708.0 |
| 2021-02-21 19:00:00 | ZN | Futures | 135.551281 | 135.629553 | 135.535627 | 135.551281 | 57731.0 |
| 2021-02-21 20:00:00 | ZN | Futures | 135.566935 | 135.566935 | 135.394737 | 135.410392 | 80682.0 |
| 2021-02-21 21:00:00 | ZN | Futures | 135.410392 | 135.535627 | 135.316465 | 135.473009 | 66861.0 |
| 2021-02-21 22:00:00 | ZN | Futures | 135.473009 | 135.504318 | 135.379083 | 135.394737 | 36223.0 |
| 2021-02-21 23:00:00 | ZN | Futures | 135.410392 | 135.426046 | 135.33212 | 135.394737 | 25223.0 |
> showing 36 of 400 rows — these rows as CSV