PREVIEW / futures_1hour / 2016-05-30

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-30.parquet
  size:    35 KB
  rows:    1,106

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
2016-05-30 00:00:00	ES	Futures	2271.07	2271.07	2270.26	2270.8	856.0
2016-05-30 01:00:00	ES	Futures	2270.8	2271.88	2270.26	2270.8	2136.0
2016-05-30 02:00:00	ES	Futures	2270.8	2270.8	2269.18	2269.45	5419.0
2016-05-30 03:00:00	ES	Futures	2269.45	2269.99	2268.1	2268.64	7619.0
2016-05-30 04:00:00	ES	Futures	2268.64	2269.72	2267.29	2268.1	4575.0
2016-05-30 05:00:00	ES	Futures	2268.1	2269.99	2267.83	2269.18	3265.0
2016-05-30 06:00:00	ES	Futures	2268.91	2269.72	2268.37	2269.72	2200.0
2016-05-30 07:00:00	ES	Futures	2269.72	2270.8	2269.18	2270.53	2395.0
2016-05-30 08:00:00	ES	Futures	2270.53	2271.07	2269.18	2269.99	4286.0
2016-05-30 09:00:00	ES	Futures	2269.99	2270.26	2267.56	2268.64	6277.0
2016-05-30 10:00:00	ES	Futures	2268.64	2269.18	2268.1	2268.64	5698.0
2016-05-30 11:00:00	ES	Futures	2268.64	2270.53	2268.37	2270.26	6824.0
2016-05-30 12:00:00	ES	Futures	2270.26	2270.8	2268.91	2269.99	4855.0
2016-05-30 18:00:00	ES	Futures	2269.45	2269.99	2267.29	2267.83	2489.0
2016-05-30 19:00:00	ES	Futures	2268.1	2269.72	2268.1	2269.18	2190.0
2016-05-30 20:00:00	ES	Futures	2269.18	2269.18	2267.56	2267.56	3444.0
2016-05-30 21:00:00	ES	Futures	2267.83	2269.72	2265.67	2269.18	6265.0
2016-05-30 22:00:00	ES	Futures	2269.18	2270.8	2268.91	2269.99	3702.0
2016-05-30 23:00:00	ES	Futures	2269.99	2270.53	2269.99	2270.53	2652.0
2016-05-30 00:00:00	NQ	Futures	5383.5	5384.1	5382.01	5383.5	157.0
2016-05-30 01:00:00	NQ	Futures	5383.5	5383.5	5381.12	5381.42	209.0
2016-05-30 02:00:00	NQ	Futures	5381.42	5382.61	5377.55	5378.44	639.0
2016-05-30 03:00:00	NQ	Futures	5378.15	5379.04	5373.98	5375.47	1400.0
2016-05-30 04:00:00	NQ	Futures	5375.77	5377.55	5371.3	5373.98	734.0
2016-05-30 05:00:00	NQ	Futures	5373.68	5378.74	5373.68	5376.06	262.0
2016-05-30 06:00:00	NQ	Futures	5376.06	5378.15	5375.17	5377.25	303.0
2016-05-30 07:00:00	NQ	Futures	5376.66	5380.53	5376.66	5379.04	382.0
2016-05-30 08:00:00	NQ	Futures	5379.34	5382.01	5378.74	5379.63	786.0
2016-05-30 09:00:00	NQ	Futures	5380.23	5380.82	5373.68	5376.06	1967.0
2016-05-30 10:00:00	NQ	Futures	5376.06	5380.53	5375.47	5379.04	1983.0
2016-05-30 11:00:00	NQ	Futures	5379.04	5383.2	5378.44	5382.91	1592.0
2016-05-30 12:00:00	NQ	Futures	5382.91	5384.1	5381.42	5381.72	1058.0
2016-05-30 18:00:00	NQ	Futures	5382.61	5382.61	5376.66	5378.44	449.0
2016-05-30 19:00:00	NQ	Futures	5378.74	5382.01	5378.74	5380.53	355.0
2016-05-30 20:00:00	NQ	Futures	5380.23	5380.23	5376.96	5377.55	593.0
2016-05-30 21:00:00	NQ	Futures	5377.85	5383.8	5374.28	5382.01	923.0
2016-05-30 22:00:00	NQ	Futures	5382.31	5388.26	5381.72	5386.78	968.0
2016-05-30 23:00:00	NQ	Futures	5387.07	5389.16	5386.48	5388.56	488.0
2016-05-30 00:00:00	YM	Futures	19165.3	19165.3	19156.8	19163.2	466.0
2016-05-30 01:00:00	YM	Futures	19162.1	19164.3	19157.8	19160.0	311.0
2016-05-30 02:00:00	YM	Futures	19158.9	19161.1	19149.3	19152.5	771.0
2016-05-30 03:00:00	YM	Futures	19151.4	19157.8	19141.8	19149.3	1146.0
2016-05-30 04:00:00	YM	Futures	19149.3	19153.6	19136.4	19142.9	642.0
2016-05-30 05:00:00	YM	Futures	19141.8	19155.7	19141.8	19147.1	490.0
2016-05-30 06:00:00	YM	Futures	19147.1	19154.6	19145.0	19151.4	272.0
2016-05-30 07:00:00	YM	Futures	19152.5	19162.1	19150.3	19160.0	442.0
2016-05-30 08:00:00	YM	Futures	19160.0	19163.2	19149.3	19154.6	727.0
2016-05-30 09:00:00	YM	Futures	19154.6	19156.8	19140.7	19147.1	1552.0
2016-05-30 10:00:00	YM	Futures	19146.1	19150.3	19141.8	19141.8	1343.0
2016-05-30 11:00:00	YM	Futures	19141.8	19157.8	19140.7	19155.7	1025.0

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

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