PREVIEW / futures_1hour / 2020-02-21

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-21.parquet
  size:    52 KB
  rows:    1,535

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
2020-02-21 00:00:00	ES	Futures	3639.4	3640.8	3633.7	3635.6	13676.0
2020-02-21 01:00:00	ES	Futures	3635.6	3637.0	3630.5	3634.0	15719.0
2020-02-21 02:00:00	ES	Futures	3633.7	3634.5	3629.1	3631.5	29013.0
2020-02-21 03:00:00	ES	Futures	3631.8	3641.3	3625.8	3637.5	74819.0
2020-02-21 04:00:00	ES	Futures	3637.5	3641.0	3632.4	3634.0	43158.0
2020-02-21 05:00:00	ES	Futures	3634.0	3641.6	3633.7	3638.3	46858.0
2020-02-21 06:00:00	ES	Futures	3638.3	3641.6	3634.8	3638.9	31055.0
2020-02-21 07:00:00	ES	Futures	3639.1	3644.5	3637.5	3642.1	31036.0
2020-02-21 08:00:00	ES	Futures	3642.1	3644.0	3636.4	3637.0	40104.0
2020-02-21 09:00:00	ES	Futures	3637.2	3642.9	3616.4	3624.0	367280.0
2020-02-21 10:00:00	ES	Futures	3623.7	3629.1	3611.8	3620.7	381713.0
2020-02-21 11:00:00	ES	Futures	3620.7	3630.5	3619.1	3627.2	186864.0
2020-02-21 12:00:00	ES	Futures	3626.9	3631.5	3619.9	3622.3	102966.0
2020-02-21 13:00:00	ES	Futures	3622.1	3625.6	3607.4	3612.6	176686.0
2020-02-21 14:00:00	ES	Futures	3612.6	3617.7	3608.8	3615.3	176203.0
2020-02-21 15:00:00	ES	Futures	3615.6	3621.8	3607.4	3617.2	284267.0
2020-02-21 16:00:00	ES	Futures	3617.2	3621.0	3616.4	3618.5	101523.0
2020-02-21 00:00:00	NQ	Futures	11079.38	11084.59	11053.36	11061.46	8430.0
2020-02-21 01:00:00	NQ	Futures	11060.88	11068.4	11042.08	11056.83	8374.0
2020-02-21 02:00:00	NQ	Futures	11057.12	11061.17	11037.17	11049.89	15823.0
2020-02-21 03:00:00	NQ	Futures	11050.76	11089.22	11032.83	11073.89	25603.0
2020-02-21 04:00:00	NQ	Futures	11073.89	11086.61	11057.41	11062.61	17313.0
2020-02-21 05:00:00	NQ	Futures	11062.61	11090.95	11062.32	11081.41	14755.0
2020-02-21 06:00:00	NQ	Futures	11081.12	11094.13	11066.37	11084.3	11781.0
2020-02-21 07:00:00	NQ	Futures	11084.59	11110.9	11078.23	11102.81	11748.0
2020-02-21 08:00:00	NQ	Futures	11102.52	11110.04	11085.17	11089.79	15241.0
2020-02-21 09:00:00	NQ	Futures	11089.79	11110.62	10967.47	11003.04	142025.0
2020-02-21 10:00:00	NQ	Futures	11003.62	11024.15	10957.06	10996.68	141053.0
2020-02-21 11:00:00	NQ	Futures	10996.68	11021.84	10981.64	11007.09	81453.0
2020-02-21 12:00:00	NQ	Futures	11007.38	11031.09	10962.27	10972.39	59845.0
2020-02-21 13:00:00	NQ	Futures	10972.1	10986.56	10886.22	10911.38	91817.0
2020-02-21 14:00:00	NQ	Futures	10911.66	10933.06	10887.37	10923.23	78934.0
2020-02-21 15:00:00	NQ	Futures	10923.23	10957.06	10888.53	10933.06	94237.0
2020-02-21 16:00:00	NQ	Futures	10933.06	10945.79	10929.59	10936.53	16048.0
2020-02-21 00:00:00	YM	Futures	31666.1	31682.4	31617.1	31632.3	3930.0
2020-02-21 01:00:00	YM	Futures	31631.2	31644.3	31581.2	31611.6	3929.0
2020-02-21 02:00:00	YM	Futures	31611.6	31620.3	31570.3	31586.6	6449.0
2020-02-21 03:00:00	YM	Futures	31587.7	31677.0	31539.8	31645.4	14243.0
2020-02-21 04:00:00	YM	Futures	31646.5	31677.0	31600.7	31614.9	6562.0
2020-02-21 05:00:00	YM	Futures	31613.8	31672.6	31613.8	31646.5	6800.0
2020-02-21 06:00:00	YM	Futures	31646.5	31671.5	31620.3	31651.9	5838.0
2020-02-21 07:00:00	YM	Futures	31651.9	31703.1	31645.4	31680.2	5906.0
2020-02-21 08:00:00	YM	Futures	31680.2	31698.7	31626.9	31631.2	6721.0
2020-02-21 09:00:00	YM	Futures	31631.2	31687.8	31475.5	31528.9	44235.0
2020-02-21 10:00:00	YM	Futures	31528.9	31575.7	31433.1	31513.6	54713.0
2020-02-21 11:00:00	YM	Futures	31513.6	31616.0	31496.2	31585.5	28868.0
2020-02-21 12:00:00	YM	Futures	31585.5	31632.3	31552.8	31571.4	22035.0
2020-02-21 13:00:00	YM	Futures	31570.3	31597.5	31463.6	31498.4	22136.0
2020-02-21 14:00:00	YM	Futures	31497.3	31549.6	31472.3	31527.8	24780.0
2020-02-21 15:00:00	YM	Futures	31527.8	31575.7	31458.1	31545.2	30406.0

> showing 50 of 1,535 rows — these rows as CSV

> unlock the full archive -- $79 one-time