PREVIEW / futures_1hour / 2021-02-19
file: by_date/futures_1hour/2021/2021-02-19.parquet size: 55 KB rows: 1,599
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-02-19 00:00:00 | ES | Futures | 4375.31 | 4383.73 | 4375.31 | 4383.17 | 7789.0 |
| 2021-02-19 01:00:00 | ES | Futures | 4383.17 | 4387.38 | 4382.04 | 4387.1 | 6766.0 |
| 2021-02-19 02:00:00 | ES | Futures | 4386.82 | 4387.94 | 4382.61 | 4386.53 | 10810.0 |
| 2021-02-19 03:00:00 | ES | Futures | 4386.53 | 4394.11 | 4382.32 | 4393.55 | 27252.0 |
| 2021-02-19 04:00:00 | ES | Futures | 4393.27 | 4405.34 | 4389.9 | 4399.73 | 24939.0 |
| 2021-02-19 05:00:00 | ES | Futures | 4400.01 | 4407.02 | 4395.52 | 4403.09 | 25630.0 |
| 2021-02-19 06:00:00 | ES | Futures | 4403.37 | 4404.5 | 4396.08 | 4397.2 | 15299.0 |
| 2021-02-19 07:00:00 | ES | Futures | 4396.92 | 4410.67 | 4396.92 | 4406.74 | 23311.0 |
| 2021-02-19 08:00:00 | ES | Futures | 4406.74 | 4413.2 | 4406.18 | 4410.95 | 30556.0 |
| 2021-02-19 09:00:00 | ES | Futures | 4410.95 | 4411.23 | 4393.83 | 4404.78 | 191458.0 |
| 2021-02-19 10:00:00 | ES | Futures | 4404.5 | 4406.46 | 4396.36 | 4404.5 | 158410.0 |
| 2021-02-19 11:00:00 | ES | Futures | 4404.5 | 4408.99 | 4401.13 | 4401.97 | 93641.0 |
| 2021-02-19 12:00:00 | ES | Futures | 4401.97 | 4402.53 | 4382.89 | 4388.5 | 170434.0 |
| 2021-02-19 13:00:00 | ES | Futures | 4388.78 | 4391.59 | 4380.36 | 4391.03 | 118307.0 |
| 2021-02-19 14:00:00 | ES | Futures | 4391.31 | 4393.83 | 4378.4 | 4386.25 | 114089.0 |
| 2021-02-19 15:00:00 | ES | Futures | 4386.25 | 4392.71 | 4376.99 | 4382.32 | 216130.0 |
| 2021-02-19 16:00:00 | ES | Futures | 4382.61 | 4383.17 | 4374.75 | 4377.55 | 61583.0 |
| 2021-02-19 00:00:00 | NQ | Futures | 15720.88 | 15767.77 | 15720.88 | 15764.59 | 4194.0 |
| 2021-02-19 01:00:00 | NQ | Futures | 15764.59 | 15783.4 | 15755.04 | 15778.77 | 3915.0 |
| 2021-02-19 02:00:00 | NQ | Futures | 15778.77 | 15786.29 | 15757.93 | 15776.74 | 4739.0 |
| 2021-02-19 03:00:00 | NQ | Futures | 15777.03 | 15812.34 | 15767.77 | 15805.98 | 9290.0 |
| 2021-02-19 04:00:00 | NQ | Futures | 15804.82 | 15849.39 | 15792.66 | 15829.13 | 9704.0 |
| 2021-02-19 05:00:00 | NQ | Futures | 15829.71 | 15852.29 | 15808.87 | 15849.97 | 8109.0 |
| 2021-02-19 06:00:00 | NQ | Futures | 15850.84 | 15854.89 | 15828.26 | 15833.47 | 5598.0 |
| 2021-02-19 07:00:00 | NQ | Futures | 15833.47 | 15878.05 | 15833.47 | 15867.92 | 8109.0 |
| 2021-02-19 08:00:00 | NQ | Futures | 15868.78 | 15894.54 | 15867.92 | 15891.36 | 11032.0 |
| 2021-02-19 09:00:00 | NQ | Futures | 15891.07 | 15891.65 | 15792.66 | 15827.97 | 71293.0 |
| 2021-02-19 10:00:00 | NQ | Futures | 15828.55 | 15840.13 | 15779.35 | 15833.76 | 67778.0 |
| 2021-02-19 11:00:00 | NQ | Futures | 15833.76 | 15860.68 | 15818.13 | 15819.29 | 47925.0 |
| 2021-02-19 12:00:00 | NQ | Futures | 15819.58 | 15827.39 | 15693.1 | 15725.22 | 73483.0 |
| 2021-02-19 13:00:00 | NQ | Futures | 15725.8 | 15741.14 | 15669.65 | 15733.91 | 50693.0 |
| 2021-02-19 14:00:00 | NQ | Futures | 15734.2 | 15750.98 | 15690.2 | 15733.62 | 42928.0 |
| 2021-02-19 15:00:00 | NQ | Futures | 15733.33 | 15757.35 | 15700.33 | 15720.01 | 57161.0 |
| 2021-02-19 16:00:00 | NQ | Futures | 15719.73 | 15727.83 | 15702.36 | 15713.94 | 13164.0 |
| 2021-02-19 00:00:00 | YM | Futures | 34766.6 | 34817.6 | 34766.6 | 34811.0 | 1601.0 |
| 2021-02-19 01:00:00 | YM | Futures | 34811.0 | 34839.8 | 34802.1 | 34834.3 | 1454.0 |
| 2021-02-19 02:00:00 | YM | Futures | 34833.2 | 34836.5 | 34802.1 | 34826.5 | 2121.0 |
| 2021-02-19 03:00:00 | YM | Futures | 34825.4 | 34877.5 | 34797.7 | 34869.8 | 5561.0 |
| 2021-02-19 04:00:00 | YM | Futures | 34869.8 | 34956.3 | 34848.7 | 34917.5 | 5709.0 |
| 2021-02-19 05:00:00 | YM | Futures | 34918.6 | 34966.3 | 34888.6 | 34939.6 | 4961.0 |
| 2021-02-19 06:00:00 | YM | Futures | 34941.9 | 34948.5 | 34885.3 | 34894.2 | 2661.0 |
| 2021-02-19 07:00:00 | YM | Futures | 34893.1 | 34995.1 | 34893.1 | 34961.8 | 3932.0 |
| 2021-02-19 08:00:00 | YM | Futures | 34962.9 | 34997.3 | 34950.7 | 34970.7 | 4249.0 |
| 2021-02-19 09:00:00 | YM | Futures | 34971.8 | 34977.4 | 34885.3 | 34969.6 | 21915.0 |
| 2021-02-19 10:00:00 | YM | Futures | 34971.8 | 35008.4 | 34944.1 | 35002.9 | 17049.0 |
| 2021-02-19 11:00:00 | YM | Futures | 35002.9 | 35031.7 | 34985.1 | 35010.6 | 10878.0 |
| 2021-02-19 12:00:00 | YM | Futures | 35009.5 | 35017.3 | 34900.8 | 34931.9 | 16140.0 |
| 2021-02-19 13:00:00 | YM | Futures | 34933.0 | 34948.5 | 34883.1 | 34936.3 | 10407.0 |
| 2021-02-19 14:00:00 | YM | Futures | 34936.3 | 34958.5 | 34858.7 | 34897.5 | 11515.0 |
| 2021-02-19 15:00:00 | YM | Futures | 34896.4 | 34964.0 | 34837.6 | 34870.9 | 19803.0 |
> showing 50 of 1,599 rows — these rows as CSV