PREVIEW / futures_1hour / 2021-05-09
file: by_date/futures_1hour/2021/2021-05-09.parquet size: 19 KB rows: 393
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-05-09 18:00:00 | ES | Futures | 4750.35 | 4754.56 | 4747.54 | 4752.6 | 5990.0 |
| 2021-05-09 19:00:00 | ES | Futures | 4752.6 | 4757.37 | 4751.75 | 4755.97 | 5884.0 |
| 2021-05-09 20:00:00 | ES | Futures | 4755.69 | 4763.27 | 4754.56 | 4759.9 | 12232.0 |
| 2021-05-09 21:00:00 | ES | Futures | 4759.9 | 4762.99 | 4758.78 | 4761.03 | 9629.0 |
| 2021-05-09 22:00:00 | ES | Futures | 4761.03 | 4761.87 | 4758.5 | 4759.06 | 6701.0 |
| 2021-05-09 23:00:00 | ES | Futures | 4759.06 | 4759.9 | 4757.09 | 4757.65 | 4909.0 |
| 2021-05-09 18:00:00 | NQ | Futures | 15885.19 | 15912.98 | 15877.08 | 15907.19 | 3716.0 |
| 2021-05-09 19:00:00 | NQ | Futures | 15907.19 | 15917.61 | 15899.37 | 15909.5 | 2154.0 |
| 2021-05-09 20:00:00 | NQ | Futures | 15909.21 | 15916.74 | 15894.45 | 15910.95 | 3892.0 |
| 2021-05-09 21:00:00 | NQ | Futures | 15910.66 | 15924.56 | 15898.21 | 15912.98 | 4107.0 |
| 2021-05-09 22:00:00 | NQ | Futures | 15914.13 | 15919.92 | 15908.06 | 15911.82 | 2641.0 |
| 2021-05-09 23:00:00 | NQ | Futures | 15912.11 | 15915.29 | 15890.98 | 15894.45 | 2431.0 |
| 2021-05-09 18:00:00 | YM | Futures | 38674.0 | 38691.8 | 38636.1 | 38668.4 | 1390.0 |
| 2021-05-09 19:00:00 | YM | Futures | 38668.4 | 38699.6 | 38659.5 | 38687.4 | 1249.0 |
| 2021-05-09 20:00:00 | YM | Futures | 38686.3 | 38768.7 | 38675.1 | 38744.2 | 2833.0 |
| 2021-05-09 21:00:00 | YM | Futures | 38744.2 | 38777.6 | 38734.1 | 38756.4 | 1864.0 |
| 2021-05-09 22:00:00 | YM | Futures | 38756.4 | 38763.1 | 38727.5 | 38731.9 | 1087.0 |
| 2021-05-09 23:00:00 | YM | Futures | 38731.9 | 38736.4 | 38720.8 | 38731.9 | 913.0 |
| 2021-05-09 18:00:00 | CL | Futures | 44.45 | 44.45 | 44.17 | 44.3 | 8518.0 |
| 2021-05-09 19:00:00 | CL | Futures | 44.29 | 44.43 | 44.24 | 44.37 | 3162.0 |
| 2021-05-09 20:00:00 | CL | Futures | 44.37 | 44.54 | 44.35 | 44.45 | 4377.0 |
| 2021-05-09 21:00:00 | CL | Futures | 44.45 | 44.57 | 44.41 | 44.46 | 5703.0 |
| 2021-05-09 22:00:00 | CL | Futures | 44.46 | 44.47 | 44.18 | 44.18 | 6734.0 |
| 2021-05-09 23:00:00 | CL | Futures | 44.18 | 44.18 | 44.08 | 44.16 | 3688.0 |
| 2021-05-09 18:00:00 | GC | Futures | 2217.2 | 2217.4 | 2214.0 | 2214.8 | 2184.0 |
| 2021-05-09 19:00:00 | GC | Futures | 2215.1 | 2219.9 | 2214.3 | 2219.0 | 2144.0 |
| 2021-05-09 20:00:00 | GC | Futures | 2219.0 | 2219.2 | 2211.8 | 2215.1 | 5390.0 |
| 2021-05-09 21:00:00 | GC | Futures | 2215.2 | 2217.7 | 2211.3 | 2212.3 | 8917.0 |
| 2021-05-09 22:00:00 | GC | Futures | 2212.4 | 2216.1 | 2212.4 | 2214.8 | 5809.0 |
| 2021-05-09 23:00:00 | GC | Futures | 2214.8 | 2214.8 | 2212.2 | 2213.9 | 3088.0 |
| 2021-05-09 18:00:00 | ZN | Futures | 134.05365 | 134.101002 | 134.037866 | 134.069434 | 11444.0 |
| 2021-05-09 19:00:00 | ZN | Futures | 134.085218 | 134.13257 | 134.069434 | 134.069434 | 8397.0 |
| 2021-05-09 20:00:00 | ZN | Futures | 134.069434 | 134.069434 | 133.943162 | 133.990514 | 26290.0 |
| 2021-05-09 21:00:00 | ZN | Futures | 134.006298 | 134.022082 | 133.927378 | 133.943162 | 14344.0 |
| 2021-05-09 22:00:00 | ZN | Futures | 133.943162 | 134.006298 | 133.943162 | 133.990514 | 9253.0 |
| 2021-05-09 23:00:00 | ZN | Futures | 133.990514 | 134.006298 | 133.97473 | 133.990514 | 4618.0 |
> showing 36 of 393 rows — these rows as CSV