PREVIEW / futures_1hour / 2016-06-06

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-06.parquet
  size:    51 KB
  rows:    1,584

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-06-06 00:00:00	ES	Futures	2264.86	2265.13	2264.05	2264.59	2126.0
2016-06-06 01:00:00	ES	Futures	2264.32	2265.4	2264.05	2265.13	3256.0
2016-06-06 02:00:00	ES	Futures	2265.13	2265.67	2262.7	2262.97	7790.0
2016-06-06 03:00:00	ES	Futures	2262.7	2270.8	2262.7	2269.18	33561.0
2016-06-06 04:00:00	ES	Futures	2269.18	2269.45	2265.94	2268.37	16556.0
2016-06-06 05:00:00	ES	Futures	2268.1	2268.37	2265.4	2267.29	16793.0
2016-06-06 06:00:00	ES	Futures	2267.56	2267.83	2265.13	2266.75	9961.0
2016-06-06 07:00:00	ES	Futures	2267.02	2269.99	2266.75	2268.91	14557.0
2016-06-06 08:00:00	ES	Futures	2268.91	2272.42	2268.1	2271.07	27590.0
2016-06-06 09:00:00	ES	Futures	2270.8	2276.74	2267.83	2274.85	182470.0
2016-06-06 10:00:00	ES	Futures	2274.85	2277.01	2273.77	2276.47	146130.0
2016-06-06 11:00:00	ES	Futures	2276.47	2277.55	2274.85	2275.12	97682.0
2016-06-06 12:00:00	ES	Futures	2275.39	2276.2	2267.29	2271.07	167680.0
2016-06-06 13:00:00	ES	Futures	2271.07	2278.09	2270.53	2277.01	133339.0
2016-06-06 14:00:00	ES	Futures	2277.01	2281.06	2276.47	2278.63	102505.0
2016-06-06 15:00:00	ES	Futures	2278.63	2279.71	2275.66	2276.47	157111.0
2016-06-06 16:00:00	ES	Futures	2276.47	2278.09	2276.2	2277.01	62830.0
2016-06-06 18:00:00	ES	Futures	2276.74	2277.28	2276.2	2276.2	1933.0
2016-06-06 19:00:00	ES	Futures	2276.2	2277.01	2274.85	2275.39	2902.0
2016-06-06 20:00:00	ES	Futures	2275.12	2277.01	2275.12	2275.66	5410.0
2016-06-06 21:00:00	ES	Futures	2275.66	2276.74	2275.39	2275.66	4484.0
2016-06-06 22:00:00	ES	Futures	2275.66	2277.28	2275.66	2276.47	3162.0
2016-06-06 23:00:00	ES	Futures	2276.2	2277.01	2275.93	2276.74	1858.0
2016-06-06 00:00:00	NQ	Futures	5369.82	5370.41	5368.33	5369.22	266.0
2016-06-06 01:00:00	NQ	Futures	5368.92	5372.49	5368.92	5371.6	430.0
2016-06-06 02:00:00	NQ	Futures	5371.9	5372.79	5365.35	5365.95	698.0
2016-06-06 03:00:00	NQ	Futures	5365.65	5384.99	5365.06	5381.42	3821.0
2016-06-06 04:00:00	NQ	Futures	5381.42	5381.72	5371.3	5377.25	1620.0
2016-06-06 05:00:00	NQ	Futures	5377.25	5377.55	5369.52	5374.87	1263.0
2016-06-06 06:00:00	NQ	Futures	5375.17	5375.77	5368.63	5371.9	1272.0
2016-06-06 07:00:00	NQ	Futures	5371.9	5377.25	5371.6	5373.98	1295.0
2016-06-06 08:00:00	NQ	Futures	5373.98	5382.91	5372.79	5379.93	3078.0
2016-06-06 09:00:00	NQ	Futures	5379.93	5389.16	5368.63	5382.01	27660.0
2016-06-06 10:00:00	NQ	Futures	5382.31	5387.07	5377.55	5385.59	19263.0
2016-06-06 11:00:00	NQ	Futures	5385.59	5390.94	5381.42	5382.01	15155.0
2016-06-06 12:00:00	NQ	Futures	5382.61	5384.99	5365.95	5374.28	22965.0
2016-06-06 13:00:00	NQ	Futures	5374.28	5391.83	5373.39	5389.75	19912.0
2016-06-06 14:00:00	NQ	Futures	5389.75	5398.97	5388.56	5389.45	14703.0
2016-06-06 15:00:00	NQ	Futures	5389.45	5393.32	5383.5	5384.69	18921.0
2016-06-06 16:00:00	NQ	Futures	5384.69	5387.67	5384.4	5385.29	4304.0
2016-06-06 18:00:00	NQ	Futures	5384.69	5385.88	5380.23	5382.31	514.0
2016-06-06 19:00:00	NQ	Futures	5382.31	5384.1	5379.93	5380.23	239.0
2016-06-06 20:00:00	NQ	Futures	5380.82	5384.1	5380.23	5382.31	421.0
2016-06-06 21:00:00	NQ	Futures	5382.01	5385.29	5381.12	5383.5	693.0
2016-06-06 22:00:00	NQ	Futures	5383.8	5387.97	5383.5	5384.99	691.0
2016-06-06 23:00:00	NQ	Futures	5384.69	5386.18	5383.5	5386.18	194.0
2016-06-06 00:00:00	YM	Futures	19056.2	19057.2	19046.5	19051.9	279.0
2016-06-06 01:00:00	YM	Futures	19051.9	19061.5	19049.7	19057.2	479.0
2016-06-06 02:00:00	YM	Futures	19058.3	19061.5	19040.1	19042.2	883.0
2016-06-06 03:00:00	YM	Futures	19041.2	19102.2	19040.1	19090.4	4412.0

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

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