PREVIEW / futures_1hour / 2021-09-29
file: by_date/futures_1hour/2021/2021-09-29.parquet size: 66 KB rows: 1,986
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-29 00:00:00 | ES | Futures | 4927.71 | 4934.77 | 4924.32 | 4933.92 | 10883.0 |
| 2021-09-29 01:00:00 | ES | Futures | 4933.64 | 4934.2 | 4922.63 | 4930.25 | 22127.0 |
| 2021-09-29 02:00:00 | ES | Futures | 4930.25 | 4935.61 | 4923.2 | 4929.12 | 21125.0 |
| 2021-09-29 03:00:00 | ES | Futures | 4928.84 | 4942.95 | 4923.48 | 4939.0 | 36502.0 |
| 2021-09-29 04:00:00 | ES | Futures | 4938.72 | 4940.69 | 4929.69 | 4937.87 | 29134.0 |
| 2021-09-29 05:00:00 | ES | Futures | 4938.15 | 4941.82 | 4932.51 | 4939.28 | 18170.0 |
| 2021-09-29 06:00:00 | ES | Futures | 4939.28 | 4942.1 | 4933.64 | 4933.64 | 16671.0 |
| 2021-09-29 07:00:00 | ES | Futures | 4933.35 | 4936.46 | 4922.07 | 4930.25 | 28699.0 |
| 2021-09-29 08:00:00 | ES | Futures | 4929.97 | 4933.35 | 4916.99 | 4922.63 | 53795.0 |
| 2021-09-29 09:00:00 | ES | Futures | 4922.63 | 4933.92 | 4905.98 | 4930.82 | 234412.0 |
| 2021-09-29 10:00:00 | ES | Futures | 4930.53 | 4940.41 | 4922.63 | 4936.46 | 244663.0 |
| 2021-09-29 11:00:00 | ES | Futures | 4936.46 | 4937.59 | 4916.7 | 4924.61 | 182920.0 |
| 2021-09-29 12:00:00 | ES | Futures | 4924.61 | 4927.43 | 4908.24 | 4916.99 | 145520.0 |
| 2021-09-29 13:00:00 | ES | Futures | 4916.7 | 4921.22 | 4904.0 | 4916.14 | 159861.0 |
| 2021-09-29 14:00:00 | ES | Futures | 4916.14 | 4939.28 | 4915.01 | 4935.61 | 167896.0 |
| 2021-09-29 15:00:00 | ES | Futures | 4935.61 | 4938.43 | 4905.13 | 4911.06 | 249542.0 |
| 2021-09-29 16:00:00 | ES | Futures | 4911.06 | 4920.09 | 4909.65 | 4917.83 | 59383.0 |
| 2021-09-29 18:00:00 | ES | Futures | 4921.78 | 4922.63 | 4916.42 | 4919.81 | 7126.0 |
| 2021-09-29 19:00:00 | ES | Futures | 4919.81 | 4928.84 | 4919.81 | 4924.61 | 8261.0 |
| 2021-09-29 20:00:00 | ES | Futures | 4924.32 | 4930.82 | 4922.63 | 4928.56 | 10086.0 |
| 2021-09-29 21:00:00 | ES | Futures | 4928.56 | 4934.2 | 4923.48 | 4932.51 | 13172.0 |
| 2021-09-29 22:00:00 | ES | Futures | 4932.79 | 4936.46 | 4931.66 | 4932.79 | 7390.0 |
| 2021-09-29 23:00:00 | ES | Futures | 4933.07 | 4937.31 | 4932.23 | 4935.89 | 6719.0 |
| 2021-09-29 00:00:00 | NQ | Futures | 17201.52 | 17233.11 | 17188.19 | 17222.96 | 5220.0 |
| 2021-09-29 01:00:00 | NQ | Futures | 17222.67 | 17228.18 | 17180.65 | 17212.82 | 9842.0 |
| 2021-09-29 02:00:00 | NQ | Futures | 17212.82 | 17239.19 | 17183.26 | 17229.34 | 10798.0 |
| 2021-09-29 03:00:00 | NQ | Futures | 17228.76 | 17303.24 | 17207.02 | 17281.8 | 18324.0 |
| 2021-09-29 04:00:00 | NQ | Futures | 17282.67 | 17296.0 | 17240.35 | 17271.36 | 11523.0 |
| 2021-09-29 05:00:00 | NQ | Futures | 17271.94 | 17289.62 | 17251.66 | 17279.19 | 5713.0 |
| 2021-09-29 06:00:00 | NQ | Futures | 17279.19 | 17296.0 | 17258.9 | 17262.96 | 5422.0 |
| 2021-09-29 07:00:00 | NQ | Futures | 17262.09 | 17273.39 | 17206.15 | 17240.35 | 14270.0 |
| 2021-09-29 08:00:00 | NQ | Futures | 17239.48 | 17262.67 | 17187.9 | 17209.92 | 16947.0 |
| 2021-09-29 09:00:00 | NQ | Futures | 17209.63 | 17276.87 | 17142.68 | 17253.39 | 96848.0 |
| 2021-09-29 10:00:00 | NQ | Futures | 17253.39 | 17280.35 | 17179.49 | 17247.6 | 89973.0 |
| 2021-09-29 11:00:00 | NQ | Futures | 17246.73 | 17253.1 | 17107.62 | 17153.12 | 67801.0 |
| 2021-09-29 12:00:00 | NQ | Futures | 17153.41 | 17164.71 | 17070.23 | 17117.76 | 60822.0 |
| 2021-09-29 13:00:00 | NQ | Futures | 17118.05 | 17138.34 | 17054.0 | 17113.99 | 58524.0 |
| 2021-09-29 14:00:00 | NQ | Futures | 17113.7 | 17218.33 | 17108.49 | 17207.02 | 51121.0 |
| 2021-09-29 15:00:00 | NQ | Futures | 17205.86 | 17216.59 | 17061.54 | 17090.23 | 56928.0 |
| 2021-09-29 16:00:00 | NQ | Futures | 17090.23 | 17131.09 | 17085.01 | 17113.7 | 14526.0 |
| 2021-09-29 18:00:00 | NQ | Futures | 17122.11 | 17136.31 | 17104.72 | 17116.31 | 3665.0 |
| 2021-09-29 19:00:00 | NQ | Futures | 17116.6 | 17158.62 | 17116.31 | 17144.42 | 4370.0 |
| 2021-09-29 20:00:00 | NQ | Futures | 17143.84 | 17177.46 | 17138.34 | 17170.51 | 4741.0 |
| 2021-09-29 21:00:00 | NQ | Futures | 17170.8 | 17195.72 | 17136.6 | 17189.35 | 7992.0 |
| 2021-09-29 22:00:00 | NQ | Futures | 17188.19 | 17197.75 | 17178.62 | 17182.97 | 4302.0 |
| 2021-09-29 23:00:00 | NQ | Futures | 17183.26 | 17208.18 | 17178.33 | 17198.91 | 3892.0 |
| 2021-09-29 00:00:00 | YM | Futures | 38478.5 | 38548.0 | 38441.5 | 38516.6 | 5240.0 |
| 2021-09-29 01:00:00 | YM | Futures | 38521.1 | 38546.9 | 38443.8 | 38508.8 | 7379.0 |
| 2021-09-29 02:00:00 | YM | Futures | 38509.9 | 38555.9 | 38443.8 | 38476.3 | 4871.0 |
| 2021-09-29 03:00:00 | YM | Futures | 38477.4 | 38561.5 | 38430.3 | 38536.8 | 5898.0 |
> showing 50 of 1,986 rows — these rows as CSV