PREVIEW / futures_1hour / 2020-12-17

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-17.parquet
  size:    60 KB
  rows:    1,891

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-12-17 00:00:00	ES	Futures	4156.95	4160.88	4155.55	4160.32	6736.0
2020-12-17 01:00:00	ES	Futures	4160.32	4161.44	4159.2	4159.48	3722.0
2020-12-17 02:00:00	ES	Futures	4159.48	4170.14	4159.48	4169.58	12034.0
2020-12-17 03:00:00	ES	Futures	4169.58	4171.83	4167.05	4167.05	17739.0
2020-12-17 04:00:00	ES	Futures	4167.05	4173.51	4166.77	4168.74	11689.0
2020-12-17 05:00:00	ES	Futures	4168.74	4170.7	4167.9	4169.3	6411.0
2020-12-17 06:00:00	ES	Futures	4169.3	4171.26	4167.05	4169.02	7884.0
2020-12-17 07:00:00	ES	Futures	4169.3	4169.3	4165.65	4167.05	10104.0
2020-12-17 08:00:00	ES	Futures	4166.77	4170.7	4162.28	4164.25	24723.0
2020-12-17 09:00:00	ES	Futures	4164.53	4172.95	4161.72	4163.97	145400.0
2020-12-17 10:00:00	ES	Futures	4163.97	4167.62	4159.48	4162.28	174566.0
2020-12-17 11:00:00	ES	Futures	4162.28	4165.93	4156.11	4163.12	137705.0
2020-12-17 12:00:00	ES	Futures	4163.12	4164.81	4157.79	4163.12	73354.0
2020-12-17 13:00:00	ES	Futures	4163.12	4168.46	4163.12	4168.46	59783.0
2020-12-17 14:00:00	ES	Futures	4168.18	4169.3	4166.21	4167.9	83896.0
2020-12-17 15:00:00	ES	Futures	4167.62	4169.86	4161.16	4169.02	217698.0
2020-12-17 16:00:00	ES	Futures	4168.74	4171.83	4166.77	4170.14	48746.0
2020-12-17 18:00:00	ES	Futures	4168.46	4170.42	4167.05	4169.02	5320.0
2020-12-17 19:00:00	ES	Futures	4169.3	4169.58	4163.41	4163.97	5751.0
2020-12-17 20:00:00	ES	Futures	4163.97	4166.21	4162.0	4162.84	5851.0
2020-12-17 21:00:00	ES	Futures	4162.84	4163.12	4157.79	4158.63	5860.0
2020-12-17 22:00:00	ES	Futures	4158.63	4164.25	4158.35	4161.44	5029.0
2020-12-17 23:00:00	ES	Futures	4161.44	4162.28	4158.91	4159.2	3483.0
2020-12-17 00:00:00	NQ	Futures	14709.89	14718.86	14702.65	14716.55	3056.0
2020-12-17 01:00:00	NQ	Futures	14716.84	14720.6	14711.92	14715.68	1498.0
2020-12-17 02:00:00	NQ	Futures	14715.1	14748.39	14715.1	14745.49	6087.0
2020-12-17 03:00:00	NQ	Futures	14745.49	14759.09	14740.86	14744.91	5364.0
2020-12-17 04:00:00	NQ	Futures	14745.2	14761.12	14736.23	14739.41	4600.0
2020-12-17 05:00:00	NQ	Futures	14738.83	14748.39	14736.52	14739.7	2220.0
2020-12-17 06:00:00	NQ	Futures	14739.41	14745.2	14730.73	14734.49	4230.0
2020-12-17 07:00:00	NQ	Futures	14734.49	14743.75	14731.31	14741.73	3682.0
2020-12-17 08:00:00	NQ	Futures	14741.44	14750.41	14731.31	14742.6	8068.0
2020-12-17 09:00:00	NQ	Futures	14742.89	14775.59	14735.94	14749.83	53978.0
2020-12-17 10:00:00	NQ	Futures	14749.83	14755.62	14704.1	14707.86	67560.0
2020-12-17 11:00:00	NQ	Futures	14707.86	14735.07	14684.42	14718.57	50411.0
2020-12-17 12:00:00	NQ	Futures	14718.57	14740.86	14702.08	14734.49	28987.0
2020-12-17 13:00:00	NQ	Futures	14734.2	14748.39	14718.28	14742.02	21392.0
2020-12-17 14:00:00	NQ	Futures	14742.02	14747.81	14721.18	14737.1	23034.0
2020-12-17 15:00:00	NQ	Futures	14737.68	14766.62	14710.18	14761.41	48525.0
2020-12-17 16:00:00	NQ	Futures	14761.41	14780.51	14758.81	14764.59	9086.0
2020-12-17 18:00:00	NQ	Futures	14758.23	14765.17	14753.6	14761.7	2398.0
2020-12-17 19:00:00	NQ	Futures	14761.99	14765.75	14741.73	14742.89	3197.0
2020-12-17 20:00:00	NQ	Futures	14743.18	14749.25	14727.84	14732.47	3310.0
2020-12-17 21:00:00	NQ	Futures	14732.18	14737.1	14724.36	14728.7	3134.0
2020-12-17 22:00:00	NQ	Futures	14728.7	14742.02	14728.7	14734.49	2189.0
2020-12-17 23:00:00	NQ	Futures	14734.78	14735.65	14722.92	14733.05	2173.0
2020-12-17 00:00:00	YM	Futures	33438.9	33467.7	33425.6	33458.9	1226.0
2020-12-17 01:00:00	YM	Futures	33457.8	33468.9	33444.5	33453.3	700.0
2020-12-17 02:00:00	YM	Futures	33454.4	33529.9	33452.2	33513.2	3135.0
2020-12-17 03:00:00	YM	Futures	33513.2	33537.6	33481.1	33483.3	4297.0

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

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