PREVIEW / futures_1hour / 2021-09-19
file: by_date/futures_1hour/2021/2021-09-19.parquet size: 19 KB rows: 402
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-09-19 18:00:00 | ES | Futures | 4980.2 | 4983.59 | 4971.74 | 4982.18 | 18636.0 |
| 2021-09-19 19:00:00 | ES | Futures | 4982.46 | 4985.28 | 4978.79 | 4984.72 | 7034.0 |
| 2021-09-19 20:00:00 | ES | Futures | 4984.72 | 4987.26 | 4979.64 | 4981.61 | 9855.0 |
| 2021-09-19 21:00:00 | ES | Futures | 4981.33 | 4981.61 | 4969.48 | 4970.04 | 15414.0 |
| 2021-09-19 22:00:00 | ES | Futures | 4970.32 | 4970.61 | 4946.62 | 4948.88 | 28718.0 |
| 2021-09-19 23:00:00 | ES | Futures | 4948.88 | 4957.63 | 4945.77 | 4953.67 | 13381.0 |
| 2021-09-19 18:00:00 | NQ | Futures | 17718.26 | 17765.5 | 17717.39 | 17762.6 | 5628.0 |
| 2021-09-19 19:00:00 | NQ | Futures | 17762.89 | 17769.85 | 17752.46 | 17766.66 | 2915.0 |
| 2021-09-19 20:00:00 | NQ | Futures | 17766.37 | 17781.15 | 17755.07 | 17760.0 | 3816.0 |
| 2021-09-19 21:00:00 | NQ | Futures | 17759.71 | 17760.28 | 17725.51 | 17730.72 | 5500.0 |
| 2021-09-19 22:00:00 | NQ | Futures | 17730.14 | 17733.91 | 17628.13 | 17633.06 | 12311.0 |
| 2021-09-19 23:00:00 | NQ | Futures | 17632.19 | 17675.95 | 17626.97 | 17666.09 | 6145.0 |
| 2021-09-19 18:00:00 | YM | Futures | 38559.2 | 38573.8 | 38476.3 | 38521.1 | 3528.0 |
| 2021-09-19 19:00:00 | YM | Futures | 38521.1 | 38546.9 | 38479.6 | 38539.0 | 2883.0 |
| 2021-09-19 20:00:00 | YM | Futures | 38542.4 | 38559.2 | 38511.0 | 38529.0 | 3211.0 |
| 2021-09-19 21:00:00 | YM | Futures | 38525.6 | 38527.8 | 38404.5 | 38404.5 | 3682.0 |
| 2021-09-19 22:00:00 | YM | Futures | 38405.7 | 38411.3 | 38202.8 | 38221.8 | 6846.0 |
| 2021-09-19 23:00:00 | YM | Futures | 38221.8 | 38293.6 | 38188.2 | 38270.0 | 3959.0 |
| 2021-09-19 18:00:00 | CL | Futures | 49.79 | 49.87 | 49.48 | 49.63 | 2847.0 |
| 2021-09-19 19:00:00 | CL | Futures | 49.63 | 49.69 | 49.58 | 49.58 | 1359.0 |
| 2021-09-19 20:00:00 | CL | Futures | 49.58 | 49.67 | 49.52 | 49.59 | 2091.0 |
| 2021-09-19 21:00:00 | CL | Futures | 49.59 | 49.59 | 49.4 | 49.42 | 3063.0 |
| 2021-09-19 22:00:00 | CL | Futures | 49.43 | 49.47 | 49.33 | 49.37 | 3303.0 |
| 2021-09-19 23:00:00 | CL | Futures | 49.38 | 49.44 | 49.31 | 49.41 | 2754.0 |
| 2021-09-19 18:00:00 | GC | Futures | 2111.7 | 2112.4 | 2108.0 | 2111.4 | 2662.0 |
| 2021-09-19 19:00:00 | GC | Futures | 2111.4 | 2113.4 | 2109.6 | 2111.9 | 1737.0 |
| 2021-09-19 20:00:00 | GC | Futures | 2112.0 | 2112.4 | 2109.3 | 2109.9 | 2002.0 |
| 2021-09-19 21:00:00 | GC | Futures | 2109.8 | 2110.2 | 2107.2 | 2107.6 | 2686.0 |
| 2021-09-19 22:00:00 | GC | Futures | 2107.4 | 2107.4 | 2097.4 | 2105.5 | 9272.0 |
| 2021-09-19 23:00:00 | GC | Futures | 2105.4 | 2106.5 | 2101.9 | 2102.3 | 2438.0 |
| 2021-09-19 18:00:00 | ZN | Futures | 135.654882 | 135.686809 | 135.638919 | 135.686809 | 5085.0 |
| 2021-09-19 19:00:00 | ZN | Futures | 135.686809 | 135.686809 | 135.670845 | 135.686809 | 2466.0 |
| 2021-09-19 20:00:00 | ZN | Futures | 135.686809 | 135.686809 | 135.622956 | 135.654882 | 5862.0 |
| 2021-09-19 21:00:00 | ZN | Futures | 135.638919 | 135.718735 | 135.638919 | 135.718735 | 7503.0 |
| 2021-09-19 22:00:00 | ZN | Futures | 135.702772 | 135.766624 | 135.686809 | 135.750661 | 20492.0 |
| 2021-09-19 23:00:00 | ZN | Futures | 135.750661 | 135.782588 | 135.734698 | 135.766624 | 10953.0 |
> showing 36 of 402 rows — these rows as CSV