PREVIEW / futures_1hour / 2020-10-28

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-28.parquet
  size:    64 KB
  rows:    1,926

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-10-28 00:00:00	ES	Futures	3768.67	3769.79	3765.31	3769.51	4742.0
2020-10-28 01:00:00	ES	Futures	3769.79	3775.39	3767.83	3773.99	10512.0
2020-10-28 02:00:00	ES	Futures	3773.99	3775.67	3765.31	3766.99	10484.0
2020-10-28 03:00:00	ES	Futures	3766.99	3768.95	3747.1	3756.07	39550.0
2020-10-28 04:00:00	ES	Futures	3756.07	3761.39	3731.7	3744.02	63213.0
2020-10-28 05:00:00	ES	Futures	3744.02	3748.5	3734.5	3740.1	31237.0
2020-10-28 06:00:00	ES	Futures	3740.1	3746.26	3733.66	3734.78	22174.0
2020-10-28 07:00:00	ES	Futures	3735.06	3740.38	3728.62	3735.06	36526.0
2020-10-28 08:00:00	ES	Futures	3735.06	3735.34	3712.09	3716.57	72543.0
2020-10-28 09:00:00	ES	Futures	3716.57	3728.9	3707.05	3711.53	278920.0
2020-10-28 10:00:00	ES	Futures	3711.53	3713.49	3670.92	3680.44	437569.0
2020-10-28 11:00:00	ES	Futures	3680.44	3697.53	3669.52	3693.33	326857.0
2020-10-28 12:00:00	ES	Futures	3693.05	3700.89	3672.32	3678.48	219997.0
2020-10-28 13:00:00	ES	Futures	3678.2	3684.08	3664.48	3682.4	206723.0
2020-10-28 14:00:00	ES	Futures	3682.4	3687.44	3667.0	3682.96	202832.0
2020-10-28 15:00:00	ES	Futures	3683.24	3695.01	3653.27	3659.99	443119.0
2020-10-28 16:00:00	ES	Futures	3659.99	3673.44	3654.39	3668.96	96510.0
2020-10-28 18:00:00	ES	Futures	3673.72	3677.64	3668.4	3676.52	10641.0
2020-10-28 19:00:00	ES	Futures	3676.24	3677.92	3666.16	3677.08	8333.0
2020-10-28 20:00:00	ES	Futures	3677.08	3688.84	3674.28	3685.76	18404.0
2020-10-28 21:00:00	ES	Futures	3685.76	3695.85	3685.48	3691.09	16437.0
2020-10-28 22:00:00	ES	Futures	3690.81	3691.65	3687.44	3689.4	7299.0
2020-10-28 23:00:00	ES	Futures	3689.4	3694.73	3687.16	3694.73	6510.0
2020-10-28 00:00:00	NQ	Futures	13357.24	13363.03	13350.59	13362.45	1737.0
2020-10-28 01:00:00	NQ	Futures	13363.03	13389.66	13357.53	13383.59	4280.0
2020-10-28 02:00:00	NQ	Futures	13383.87	13392.85	13354.93	13360.14	5596.0
2020-10-28 03:00:00	NQ	Futures	13360.14	13365.93	13295.01	13336.11	13636.0
2020-10-28 04:00:00	NQ	Futures	13335.53	13347.98	13244.35	13297.03	20611.0
2020-10-28 05:00:00	NQ	Futures	13295.59	13303.69	13264.61	13282.56	7845.0
2020-10-28 06:00:00	NQ	Futures	13282.27	13295.01	13239.72	13245.22	6478.0
2020-10-28 07:00:00	NQ	Futures	13245.22	13286.03	13244.93	13246.67	10232.0
2020-10-28 08:00:00	NQ	Futures	13246.96	13257.96	13178.93	13195.14	23527.0
2020-10-28 09:00:00	NQ	Futures	13195.43	13226.4	13044.91	13087.17	96481.0
2020-10-28 10:00:00	NQ	Futures	13087.75	13093.83	12970.8	13013.35	115224.0
2020-10-28 11:00:00	NQ	Futures	13013.07	13040.28	12962.7	13017.7	94854.0
2020-10-28 12:00:00	NQ	Futures	13017.7	13044.91	12957.2	12971.96	70494.0
2020-10-28 13:00:00	NQ	Futures	12971.67	13015.96	12923.04	13012.78	64716.0
2020-10-28 14:00:00	NQ	Futures	13013.07	13022.33	12951.99	13006.12	54171.0
2020-10-28 15:00:00	NQ	Futures	13006.41	13053.88	12879.91	12895.83	109070.0
2020-10-28 16:00:00	NQ	Futures	12895.54	12961.25	12887.44	12942.44	20471.0
2020-10-28 18:00:00	NQ	Futures	12945.62	12968.2	12927.67	12962.41	4962.0
2020-10-28 19:00:00	NQ	Futures	12961.54	12969.93	12929.99	12956.04	4374.0
2020-10-28 20:00:00	NQ	Futures	12955.46	12989.91	12944.46	12981.8	7748.0
2020-10-28 21:00:00	NQ	Futures	12981.8	13016.54	12980.36	13006.12	7019.0
2020-10-28 22:00:00	NQ	Futures	13006.12	13014.22	12995.7	13007.57	4283.0
2020-10-28 23:00:00	NQ	Futures	13007.57	13021.75	12999.17	13020.01	3574.0
2020-10-28 00:00:00	YM	Futures	30080.6	30089.4	30043.0	30080.6	1108.0
2020-10-28 01:00:00	YM	Futures	30082.8	30125.9	30059.6	30111.5	1931.0
2020-10-28 02:00:00	YM	Futures	30111.5	30122.6	30034.2	30050.7	2372.0
2020-10-28 03:00:00	YM	Futures	30050.7	30069.5	29846.2	29935.8	10050.0

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

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