PREVIEW / futures_1hour / 2021-10-13
file: by_date/futures_1hour/2021/2021-10-13.parquet size: 66 KB rows: 1,992
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-10-13 00:00:00 | ES | Futures | 4893.28 | 4898.36 | 4893.0 | 4897.51 | 3958.0 |
| 2021-10-13 01:00:00 | ES | Futures | 4897.8 | 4898.64 | 4890.18 | 4892.72 | 7417.0 |
| 2021-10-13 02:00:00 | ES | Futures | 4892.43 | 4896.67 | 4888.2 | 4893.28 | 8191.0 |
| 2021-10-13 03:00:00 | ES | Futures | 4893.28 | 4901.18 | 4880.3 | 4899.77 | 32758.0 |
| 2021-10-13 04:00:00 | ES | Futures | 4900.05 | 4914.73 | 4896.39 | 4910.21 | 22684.0 |
| 2021-10-13 05:00:00 | ES | Futures | 4910.21 | 4912.75 | 4906.54 | 4909.08 | 13362.0 |
| 2021-10-13 06:00:00 | ES | Futures | 4909.37 | 4914.45 | 4904.85 | 4906.54 | 16258.0 |
| 2021-10-13 07:00:00 | ES | Futures | 4906.54 | 4911.91 | 4902.03 | 4909.08 | 18982.0 |
| 2021-10-13 08:00:00 | ES | Futures | 4909.37 | 4915.86 | 4891.59 | 4898.08 | 81177.0 |
| 2021-10-13 09:00:00 | ES | Futures | 4898.08 | 4918.68 | 4888.77 | 4893.28 | 210528.0 |
| 2021-10-13 10:00:00 | ES | Futures | 4893.28 | 4896.95 | 4875.22 | 4889.05 | 217468.0 |
| 2021-10-13 11:00:00 | ES | Futures | 4889.05 | 4906.54 | 4884.25 | 4899.21 | 138097.0 |
| 2021-10-13 12:00:00 | ES | Futures | 4899.21 | 4904.85 | 4895.54 | 4899.77 | 66026.0 |
| 2021-10-13 13:00:00 | ES | Futures | 4899.77 | 4917.55 | 4898.08 | 4912.19 | 79402.0 |
| 2021-10-13 14:00:00 | ES | Futures | 4912.47 | 4927.15 | 4902.88 | 4909.08 | 152652.0 |
| 2021-10-13 15:00:00 | ES | Futures | 4908.8 | 4918.96 | 4904.85 | 4916.42 | 169728.0 |
| 2021-10-13 16:00:00 | ES | Futures | 4916.42 | 4918.4 | 4913.32 | 4916.42 | 43722.0 |
| 2021-10-13 18:00:00 | ES | Futures | 4915.86 | 4925.17 | 4915.01 | 4922.35 | 7102.0 |
| 2021-10-13 19:00:00 | ES | Futures | 4922.35 | 4926.58 | 4920.94 | 4924.61 | 4991.0 |
| 2021-10-13 20:00:00 | ES | Futures | 4924.32 | 4934.77 | 4923.76 | 4931.66 | 13216.0 |
| 2021-10-13 21:00:00 | ES | Futures | 4931.66 | 4932.79 | 4927.71 | 4927.99 | 6771.0 |
| 2021-10-13 22:00:00 | ES | Futures | 4927.99 | 4931.66 | 4927.43 | 4930.53 | 3995.0 |
| 2021-10-13 23:00:00 | ES | Futures | 4930.25 | 4935.33 | 4929.12 | 4932.51 | 4598.0 |
| 2021-10-13 00:00:00 | NQ | Futures | 16947.35 | 16972.85 | 16945.03 | 16971.69 | 2920.0 |
| 2021-10-13 01:00:00 | NQ | Futures | 16973.14 | 16977.49 | 16945.61 | 16955.17 | 3730.0 |
| 2021-10-13 02:00:00 | NQ | Futures | 16952.56 | 16972.85 | 16942.71 | 16963.0 | 4252.0 |
| 2021-10-13 03:00:00 | NQ | Futures | 16962.42 | 17014.88 | 16915.47 | 17011.11 | 16084.0 |
| 2021-10-13 04:00:00 | NQ | Futures | 17011.98 | 17076.32 | 16996.33 | 17054.87 | 12481.0 |
| 2021-10-13 05:00:00 | NQ | Futures | 17053.42 | 17075.45 | 17042.41 | 17060.67 | 7175.0 |
| 2021-10-13 06:00:00 | NQ | Futures | 17061.54 | 17093.42 | 17049.65 | 17057.19 | 8271.0 |
| 2021-10-13 07:00:00 | NQ | Futures | 17058.06 | 17069.07 | 17029.08 | 17055.45 | 10285.0 |
| 2021-10-13 08:00:00 | NQ | Futures | 17056.32 | 17086.46 | 16981.55 | 17020.38 | 33266.0 |
| 2021-10-13 09:00:00 | NQ | Futures | 17020.67 | 17132.54 | 17011.11 | 17058.64 | 111493.0 |
| 2021-10-13 10:00:00 | NQ | Futures | 17059.22 | 17087.62 | 17002.99 | 17038.06 | 90062.0 |
| 2021-10-13 11:00:00 | NQ | Futures | 17038.06 | 17087.04 | 16995.46 | 17071.97 | 52440.0 |
| 2021-10-13 12:00:00 | NQ | Futures | 17071.97 | 17075.74 | 17036.9 | 17047.33 | 30015.0 |
| 2021-10-13 13:00:00 | NQ | Futures | 17047.33 | 17122.98 | 17043.86 | 17098.34 | 30624.0 |
| 2021-10-13 14:00:00 | NQ | Futures | 17100.37 | 17152.25 | 17067.33 | 17092.26 | 50984.0 |
| 2021-10-13 15:00:00 | NQ | Futures | 17092.26 | 17120.66 | 17077.48 | 17118.05 | 45689.0 |
| 2021-10-13 16:00:00 | NQ | Futures | 17117.76 | 17125.3 | 17106.46 | 17119.79 | 9836.0 |
| 2021-10-13 18:00:00 | NQ | Futures | 17122.69 | 17158.62 | 17119.5 | 17150.8 | 3917.0 |
| 2021-10-13 19:00:00 | NQ | Futures | 17150.8 | 17168.48 | 17144.42 | 17162.1 | 3386.0 |
| 2021-10-13 20:00:00 | NQ | Futures | 17160.36 | 17199.49 | 17159.78 | 17184.42 | 5777.0 |
| 2021-10-13 21:00:00 | NQ | Futures | 17184.42 | 17190.5 | 17168.77 | 17169.93 | 4000.0 |
| 2021-10-13 22:00:00 | NQ | Futures | 17169.06 | 17179.2 | 17165.58 | 17176.59 | 2212.0 |
| 2021-10-13 23:00:00 | NQ | Futures | 17176.59 | 17190.21 | 17169.64 | 17182.39 | 2352.0 |
| 2021-10-13 00:00:00 | YM | Futures | 38391.1 | 38421.3 | 38391.1 | 38418.0 | 1102.0 |
| 2021-10-13 01:00:00 | YM | Futures | 38419.1 | 38426.9 | 38366.4 | 38379.9 | 1466.0 |
| 2021-10-13 02:00:00 | YM | Futures | 38377.6 | 38405.7 | 38332.8 | 38375.4 | 2407.0 |
| 2021-10-13 03:00:00 | YM | Futures | 38375.4 | 38411.3 | 38274.5 | 38401.2 | 8239.0 |
> showing 50 of 1,992 rows — these rows as CSV