PREVIEW / futures_1hour / 2021-08-05
file: by_date/futures_1hour/2021/2021-08-05.parquet size: 62 KB rows: 1,954
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-08-05 00:00:00 | ES | Futures | 4958.38 | 4958.66 | 4957.54 | 4958.38 | 1600.0 |
| 2021-08-05 01:00:00 | ES | Futures | 4958.38 | 4960.07 | 4956.13 | 4956.97 | 4180.0 |
| 2021-08-05 02:00:00 | ES | Futures | 4956.97 | 4957.25 | 4948.81 | 4949.93 | 9853.0 |
| 2021-08-05 03:00:00 | ES | Futures | 4949.93 | 4960.63 | 4949.93 | 4959.23 | 18950.0 |
| 2021-08-05 04:00:00 | ES | Futures | 4959.23 | 4959.79 | 4955.0 | 4959.23 | 10643.0 |
| 2021-08-05 05:00:00 | ES | Futures | 4958.94 | 4965.7 | 4958.94 | 4964.58 | 14039.0 |
| 2021-08-05 06:00:00 | ES | Futures | 4964.86 | 4964.86 | 4958.1 | 4958.94 | 13200.0 |
| 2021-08-05 07:00:00 | ES | Futures | 4959.23 | 4962.89 | 4957.54 | 4962.32 | 11983.0 |
| 2021-08-05 08:00:00 | ES | Futures | 4962.04 | 4963.45 | 4956.97 | 4958.38 | 20647.0 |
| 2021-08-05 09:00:00 | ES | Futures | 4958.38 | 4969.36 | 4957.82 | 4969.08 | 108637.0 |
| 2021-08-05 10:00:00 | ES | Futures | 4969.36 | 4972.18 | 4964.01 | 4971.05 | 109276.0 |
| 2021-08-05 11:00:00 | ES | Futures | 4971.33 | 4972.74 | 4968.8 | 4969.93 | 73155.0 |
| 2021-08-05 12:00:00 | ES | Futures | 4970.21 | 4971.62 | 4965.14 | 4965.14 | 48102.0 |
| 2021-08-05 13:00:00 | ES | Futures | 4965.14 | 4971.33 | 4964.58 | 4971.05 | 41928.0 |
| 2021-08-05 14:00:00 | ES | Futures | 4971.33 | 4972.74 | 4967.67 | 4968.24 | 49083.0 |
| 2021-08-05 15:00:00 | ES | Futures | 4968.52 | 4981.47 | 4967.39 | 4980.06 | 133466.0 |
| 2021-08-05 16:00:00 | ES | Futures | 4980.34 | 4980.63 | 4976.97 | 4979.5 | 50837.0 |
| 2021-08-05 18:00:00 | ES | Futures | 4978.66 | 4979.5 | 4975.84 | 4976.4 | 3741.0 |
| 2021-08-05 19:00:00 | ES | Futures | 4976.4 | 4977.25 | 4974.43 | 4974.99 | 3149.0 |
| 2021-08-05 20:00:00 | ES | Futures | 4974.99 | 4977.53 | 4973.87 | 4975.56 | 5712.0 |
| 2021-08-05 21:00:00 | ES | Futures | 4975.28 | 4976.68 | 4973.87 | 4975.84 | 5745.0 |
| 2021-08-05 22:00:00 | ES | Futures | 4975.84 | 4976.4 | 4974.99 | 4975.84 | 3014.0 |
| 2021-08-05 23:00:00 | ES | Futures | 4976.12 | 4978.66 | 4975.84 | 4978.37 | 3063.0 |
| 2021-08-05 00:00:00 | NQ | Futures | 17483.71 | 17488.93 | 17481.68 | 17484.58 | 1499.0 |
| 2021-08-05 01:00:00 | NQ | Futures | 17484.58 | 17489.8 | 17474.73 | 17477.92 | 1948.0 |
| 2021-08-05 02:00:00 | NQ | Futures | 17478.21 | 17479.95 | 17461.12 | 17467.78 | 3144.0 |
| 2021-08-05 03:00:00 | NQ | Futures | 17468.94 | 17493.85 | 17468.65 | 17490.66 | 4721.0 |
| 2021-08-05 04:00:00 | NQ | Futures | 17490.09 | 17492.4 | 17479.37 | 17488.93 | 2794.0 |
| 2021-08-05 05:00:00 | NQ | Futures | 17489.22 | 17514.42 | 17485.74 | 17511.52 | 4466.0 |
| 2021-08-05 06:00:00 | NQ | Futures | 17511.52 | 17516.74 | 17499.36 | 17502.54 | 4273.0 |
| 2021-08-05 07:00:00 | NQ | Futures | 17503.12 | 17516.16 | 17493.27 | 17510.07 | 4751.0 |
| 2021-08-05 08:00:00 | NQ | Futures | 17510.07 | 17511.23 | 17487.48 | 17490.38 | 6740.0 |
| 2021-08-05 09:00:00 | NQ | Futures | 17490.66 | 17530.06 | 17465.46 | 17524.85 | 60065.0 |
| 2021-08-05 10:00:00 | NQ | Futures | 17525.43 | 17558.16 | 17500.22 | 17550.34 | 69265.0 |
| 2021-08-05 11:00:00 | NQ | Futures | 17550.34 | 17573.8 | 17543.97 | 17552.08 | 44402.0 |
| 2021-08-05 12:00:00 | NQ | Futures | 17552.08 | 17560.77 | 17539.91 | 17543.39 | 23742.0 |
| 2021-08-05 13:00:00 | NQ | Futures | 17542.81 | 17561.06 | 17537.88 | 17560.48 | 17623.0 |
| 2021-08-05 14:00:00 | NQ | Futures | 17560.48 | 17569.17 | 17553.24 | 17557.29 | 23093.0 |
| 2021-08-05 15:00:00 | NQ | Futures | 17557.29 | 17580.47 | 17542.81 | 17573.51 | 39517.0 |
| 2021-08-05 16:00:00 | NQ | Futures | 17573.8 | 17580.76 | 17560.77 | 17579.89 | 10052.0 |
| 2021-08-05 18:00:00 | NQ | Futures | 17575.25 | 17576.7 | 17567.14 | 17570.04 | 1858.0 |
| 2021-08-05 19:00:00 | NQ | Futures | 17570.33 | 17574.38 | 17565.4 | 17566.85 | 1223.0 |
| 2021-08-05 20:00:00 | NQ | Futures | 17566.85 | 17576.7 | 17563.95 | 17567.72 | 2317.0 |
| 2021-08-05 21:00:00 | NQ | Futures | 17567.14 | 17572.93 | 17562.8 | 17568.3 | 2727.0 |
| 2021-08-05 22:00:00 | NQ | Futures | 17568.01 | 17570.04 | 17563.66 | 17567.72 | 1520.0 |
| 2021-08-05 23:00:00 | NQ | Futures | 17567.43 | 17577.57 | 17566.85 | 17575.83 | 1662.0 |
| 2021-08-05 00:00:00 | YM | Futures | 38823.4 | 38824.5 | 38813.3 | 38822.3 | 525.0 |
| 2021-08-05 01:00:00 | YM | Futures | 38822.3 | 38836.8 | 38805.5 | 38814.5 | 795.0 |
| 2021-08-05 02:00:00 | YM | Futures | 38815.6 | 38816.7 | 38731.8 | 38745.2 | 2495.0 |
| 2021-08-05 03:00:00 | YM | Futures | 38747.4 | 38842.4 | 38746.3 | 38815.6 | 4266.0 |
> showing 50 of 1,954 rows — these rows as CSV