PREVIEW / futures_1hour / 2020-09-30

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-30.parquet
  size:    62 KB
  rows:    1,887

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-09-30 00:00:00	ES	Futures	3712.93	3716.29	3701.17	3711.25	22306.0
2020-09-30 01:00:00	ES	Futures	3711.25	3716.85	3693.33	3693.61	19975.0
2020-09-30 02:00:00	ES	Futures	3693.61	3704.81	3687.44	3703.97	31088.0
2020-09-30 03:00:00	ES	Futures	3703.97	3719.09	3700.89	3703.41	39018.0
2020-09-30 04:00:00	ES	Futures	3703.41	3710.13	3701.73	3707.05	24280.0
2020-09-30 05:00:00	ES	Futures	3706.77	3707.89	3693.05	3705.93	25871.0
2020-09-30 06:00:00	ES	Futures	3705.93	3726.38	3697.53	3717.41	34752.0
2020-09-30 07:00:00	ES	Futures	3717.41	3721.34	3710.97	3712.65	20150.0
2020-09-30 08:00:00	ES	Futures	3712.65	3734.22	3709.57	3730.02	44402.0
2020-09-30 09:00:00	ES	Futures	3730.02	3756.91	3728.9	3754.67	164115.0
2020-09-30 10:00:00	ES	Futures	3754.67	3772.59	3754.11	3763.91	226664.0
2020-09-30 11:00:00	ES	Futures	3763.91	3778.19	3761.67	3774.55	153943.0
2020-09-30 12:00:00	ES	Futures	3774.83	3783.24	3774.27	3777.63	98425.0
2020-09-30 13:00:00	ES	Futures	3777.63	3782.68	3767.83	3782.4	112075.0
2020-09-30 14:00:00	ES	Futures	3782.4	3791.36	3745.42	3764.19	346808.0
2020-09-30 15:00:00	ES	Futures	3763.91	3768.95	3730.02	3752.99	500047.0
2020-09-30 16:00:00	ES	Futures	3752.71	3755.51	3735.34	3740.38	115904.0
2020-09-30 18:00:00	ES	Futures	3747.38	3762.23	3745.7	3761.67	15822.0
2020-09-30 19:00:00	ES	Futures	3761.67	3766.43	3760.27	3766.15	11088.0
2020-09-30 20:00:00	ES	Futures	3766.43	3768.39	3759.15	3759.99	13899.0
2020-09-30 21:00:00	ES	Futures	3759.99	3777.91	3759.43	3775.95	14394.0
2020-09-30 22:00:00	ES	Futures	3775.67	3778.75	3772.87	3776.51	5753.0
2020-09-30 23:00:00	ES	Futures	3776.51	3777.91	3771.47	3774.27	4382.0
2020-09-30 00:00:00	NQ	Futures	13040.85	13058.22	13004.67	13045.2	10302.0
2020-09-30 01:00:00	NQ	Futures	13044.62	13067.77	12959.8	12962.41	11320.0
2020-09-30 02:00:00	NQ	Futures	12962.7	13000.91	12929.99	12997.72	14090.0
2020-09-30 03:00:00	NQ	Futures	12996.57	13045.78	12977.46	12982.67	15053.0
2020-09-30 04:00:00	NQ	Futures	12983.54	13020.88	12978.04	13010.46	7985.0
2020-09-30 05:00:00	NQ	Futures	13009.01	13015.38	12951.41	13007.85	8903.0
2020-09-30 06:00:00	NQ	Futures	13009.3	13081.96	12982.09	13055.33	10447.0
2020-09-30 07:00:00	NQ	Futures	13055.04	13068.35	13029.85	13037.67	6764.0
2020-09-30 08:00:00	NQ	Futures	13038.25	13114.38	13022.04	13098.75	16330.0
2020-09-30 09:00:00	NQ	Futures	13098.75	13223.8	13092.09	13220.32	63028.0
2020-09-30 10:00:00	NQ	Futures	13220.32	13292.69	13205.85	13243.77	77760.0
2020-09-30 11:00:00	NQ	Futures	13243.19	13315.56	13229.01	13303.4	52293.0
2020-09-30 12:00:00	NQ	Futures	13302.82	13322.8	13255.35	13268.96	37545.0
2020-09-30 13:00:00	NQ	Futures	13269.53	13314.11	13225.54	13312.67	42095.0
2020-09-30 14:00:00	NQ	Futures	13312.95	13345.66	13177.77	13248.4	93028.0
2020-09-30 15:00:00	NQ	Futures	13247.82	13271.56	13125.38	13202.67	100243.0
2020-09-30 16:00:00	NQ	Futures	13203.25	13222.35	13137.25	13150.27	18001.0
2020-09-30 18:00:00	NQ	Futures	13170.83	13233.93	13170.83	13230.17	6015.0
2020-09-30 19:00:00	NQ	Futures	13229.88	13250.72	13226.69	13249.85	3403.0
2020-09-30 20:00:00	NQ	Futures	13250.72	13260.27	13211.06	13213.96	5491.0
2020-09-30 21:00:00	NQ	Futures	13214.25	13284.59	13211.35	13274.17	7261.0
2020-09-30 22:00:00	NQ	Futures	13275.32	13289.8	13265.77	13281.4	3523.0
2020-09-30 23:00:00	NQ	Futures	13281.98	13284.59	13259.98	13271.27	2266.0
2020-09-30 00:00:00	YM	Futures	30124.8	30149.1	30015.4	30078.4	6221.0
2020-09-30 01:00:00	YM	Futures	30074.0	30119.3	29936.9	29940.2	6235.0
2020-09-30 02:00:00	YM	Futures	29939.1	30028.6	29894.8	30023.1	7278.0
2020-09-30 03:00:00	YM	Futures	30022.0	30161.3	30003.2	30036.4	11111.0

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

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