PREVIEW / futures_1hour / 2021-09-07
file: by_date/futures_1hour/2021/2021-09-07.parquet size: 62 KB rows: 1,942
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-07 00:00:00 | ES | Futures | 5112.41 | 5114.1 | 5110.72 | 5111.84 | 2780.0 |
| 2021-09-07 01:00:00 | ES | Futures | 5112.13 | 5113.81 | 5110.72 | 5112.69 | 5039.0 |
| 2021-09-07 02:00:00 | ES | Futures | 5112.69 | 5114.66 | 5111.84 | 5113.25 | 6732.0 |
| 2021-09-07 03:00:00 | ES | Futures | 5112.97 | 5113.81 | 5110.44 | 5112.97 | 11720.0 |
| 2021-09-07 04:00:00 | ES | Futures | 5112.69 | 5112.97 | 5105.09 | 5110.44 | 18485.0 |
| 2021-09-07 05:00:00 | ES | Futures | 5110.44 | 5110.72 | 5101.43 | 5106.21 | 22292.0 |
| 2021-09-07 06:00:00 | ES | Futures | 5106.21 | 5108.18 | 5103.96 | 5106.49 | 13488.0 |
| 2021-09-07 07:00:00 | ES | Futures | 5106.78 | 5111.56 | 5106.21 | 5110.15 | 14527.0 |
| 2021-09-07 08:00:00 | ES | Futures | 5110.15 | 5111.28 | 5105.37 | 5106.78 | 21799.0 |
| 2021-09-07 09:00:00 | ES | Futures | 5106.49 | 5107.62 | 5087.35 | 5092.41 | 206567.0 |
| 2021-09-07 10:00:00 | ES | Futures | 5092.13 | 5092.98 | 5080.59 | 5091.29 | 189291.0 |
| 2021-09-07 11:00:00 | ES | Futures | 5091.29 | 5091.85 | 5081.15 | 5086.78 | 116174.0 |
| 2021-09-07 12:00:00 | ES | Futures | 5086.78 | 5097.76 | 5086.22 | 5096.92 | 90262.0 |
| 2021-09-07 13:00:00 | ES | Futures | 5097.2 | 5099.74 | 5095.51 | 5098.61 | 67031.0 |
| 2021-09-07 14:00:00 | ES | Futures | 5098.89 | 5099.17 | 5091.85 | 5096.36 | 83902.0 |
| 2021-09-07 15:00:00 | ES | Futures | 5096.36 | 5098.33 | 5088.75 | 5089.88 | 147550.0 |
| 2021-09-07 16:00:00 | ES | Futures | 5090.16 | 5090.72 | 5085.66 | 5088.47 | 47154.0 |
| 2021-09-07 18:00:00 | ES | Futures | 5088.19 | 5090.44 | 5087.63 | 5088.75 | 3872.0 |
| 2021-09-07 19:00:00 | ES | Futures | 5088.75 | 5089.04 | 5083.4 | 5084.81 | 5282.0 |
| 2021-09-07 20:00:00 | ES | Futures | 5084.81 | 5093.82 | 5084.53 | 5093.54 | 9941.0 |
| 2021-09-07 21:00:00 | ES | Futures | 5093.54 | 5096.36 | 5092.41 | 5094.67 | 7142.0 |
| 2021-09-07 22:00:00 | ES | Futures | 5094.95 | 5096.07 | 5093.82 | 5094.1 | 4821.0 |
| 2021-09-07 23:00:00 | ES | Futures | 5094.1 | 5095.23 | 5087.35 | 5089.6 | 7764.0 |
| 2021-09-07 00:00:00 | NQ | Futures | 18165.33 | 18169.39 | 18160.99 | 18163.59 | 1352.0 |
| 2021-09-07 01:00:00 | NQ | Futures | 18163.59 | 18178.37 | 18160.41 | 18175.47 | 3431.0 |
| 2021-09-07 02:00:00 | NQ | Futures | 18175.76 | 18184.74 | 18173.15 | 18180.4 | 3625.0 |
| 2021-09-07 03:00:00 | NQ | Futures | 18180.4 | 18182.71 | 18166.2 | 18172.57 | 4354.0 |
| 2021-09-07 04:00:00 | NQ | Futures | 18172.28 | 18172.28 | 18132.31 | 18150.85 | 9663.0 |
| 2021-09-07 05:00:00 | NQ | Futures | 18151.14 | 18155.77 | 18101.31 | 18123.04 | 11405.0 |
| 2021-09-07 06:00:00 | NQ | Futures | 18122.75 | 18128.83 | 18105.95 | 18116.67 | 6536.0 |
| 2021-09-07 07:00:00 | NQ | Futures | 18116.96 | 18138.39 | 18114.64 | 18135.5 | 6598.0 |
| 2021-09-07 08:00:00 | NQ | Futures | 18135.78 | 18147.95 | 18124.78 | 18134.05 | 8526.0 |
| 2021-09-07 09:00:00 | NQ | Futures | 18133.76 | 18155.77 | 18091.75 | 18125.65 | 85651.0 |
| 2021-09-07 10:00:00 | NQ | Futures | 18125.65 | 18166.2 | 18083.93 | 18162.15 | 90856.0 |
| 2021-09-07 11:00:00 | NQ | Futures | 18161.86 | 18165.33 | 18113.77 | 18155.19 | 64300.0 |
| 2021-09-07 12:00:00 | NQ | Futures | 18154.9 | 18193.72 | 18153.46 | 18182.13 | 43227.0 |
| 2021-09-07 13:00:00 | NQ | Futures | 18182.13 | 18192.85 | 18171.42 | 18182.71 | 29947.0 |
| 2021-09-07 14:00:00 | NQ | Futures | 18182.71 | 18187.64 | 18164.17 | 18180.4 | 33513.0 |
| 2021-09-07 15:00:00 | NQ | Futures | 18180.4 | 18185.61 | 18155.48 | 18160.99 | 48231.0 |
| 2021-09-07 16:00:00 | NQ | Futures | 18161.28 | 18162.44 | 18141.29 | 18159.54 | 10173.0 |
| 2021-09-07 18:00:00 | NQ | Futures | 18158.38 | 18164.75 | 18156.06 | 18160.99 | 1406.0 |
| 2021-09-07 19:00:00 | NQ | Futures | 18161.57 | 18162.44 | 18143.9 | 18148.53 | 2178.0 |
| 2021-09-07 20:00:00 | NQ | Futures | 18147.95 | 18176.34 | 18147.95 | 18174.02 | 3879.0 |
| 2021-09-07 21:00:00 | NQ | Futures | 18174.31 | 18181.55 | 18167.36 | 18178.08 | 3042.0 |
| 2021-09-07 22:00:00 | NQ | Futures | 18178.08 | 18180.69 | 18172.0 | 18175.47 | 2076.0 |
| 2021-09-07 23:00:00 | NQ | Futures | 18175.47 | 18177.79 | 18156.64 | 18165.04 | 2589.0 |
| 2021-09-07 00:00:00 | YM | Futures | 39553.0 | 39567.5 | 39536.2 | 39551.8 | 550.0 |
| 2021-09-07 01:00:00 | YM | Futures | 39551.8 | 39561.9 | 39532.8 | 39545.1 | 1105.0 |
| 2021-09-07 02:00:00 | YM | Futures | 39546.3 | 39558.5 | 39518.3 | 39534.0 | 1510.0 |
| 2021-09-07 03:00:00 | YM | Futures | 39532.8 | 39544.0 | 39498.2 | 39538.4 | 2293.0 |
> showing 50 of 1,942 rows — these rows as CSV