PREVIEW / futures_1hour / 2016-06-07

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-07.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-07 00:00:00	ES	Futures	2276.74	2277.55	2276.47	2277.01	3380.0
2016-06-07 01:00:00	ES	Futures	2276.74	2278.36	2276.47	2277.28	3354.0
2016-06-07 02:00:00	ES	Futures	2277.55	2279.98	2277.55	2278.63	7955.0
2016-06-07 03:00:00	ES	Futures	2278.63	2284.03	2278.63	2282.95	42119.0
2016-06-07 04:00:00	ES	Futures	2282.95	2284.84	2282.41	2284.03	19597.0
2016-06-07 05:00:00	ES	Futures	2283.76	2285.38	2283.49	2283.76	16741.0
2016-06-07 06:00:00	ES	Futures	2284.03	2284.03	2282.14	2282.41	14626.0
2016-06-07 07:00:00	ES	Futures	2282.41	2283.22	2280.79	2281.87	18874.0
2016-06-07 08:00:00	ES	Futures	2281.87	2282.14	2278.9	2279.71	26787.0
2016-06-07 09:00:00	ES	Futures	2279.44	2281.6	2277.82	2281.06	159816.0
2016-06-07 10:00:00	ES	Futures	2281.06	2284.57	2280.52	2282.41	177807.0
2016-06-07 11:00:00	ES	Futures	2282.14	2285.65	2281.87	2284.03	113371.0
2016-06-07 12:00:00	ES	Futures	2284.03	2286.46	2283.76	2286.19	55443.0
2016-06-07 13:00:00	ES	Futures	2286.19	2287.27	2284.3	2284.57	67420.0
2016-06-07 14:00:00	ES	Futures	2284.84	2286.73	2283.76	2283.76	69004.0
2016-06-07 15:00:00	ES	Futures	2283.49	2284.57	2278.63	2279.98	204295.0
2016-06-07 16:00:00	ES	Futures	2279.98	2280.52	2278.36	2278.9	45372.0
2016-06-07 18:00:00	ES	Futures	2278.9	2279.17	2277.82	2278.9	2950.0
2016-06-07 19:00:00	ES	Futures	2279.17	2279.71	2278.09	2278.09	3375.0
2016-06-07 20:00:00	ES	Futures	2278.09	2278.36	2276.47	2277.28	6031.0
2016-06-07 21:00:00	ES	Futures	2277.28	2277.55	2274.85	2275.39	7130.0
2016-06-07 22:00:00	ES	Futures	2275.12	2276.74	2275.12	2276.47	3043.0
2016-06-07 23:00:00	ES	Futures	2276.74	2278.36	2276.47	2277.82	4269.0
2016-06-07 00:00:00	NQ	Futures	5385.88	5387.67	5385.59	5386.48	256.0
2016-06-07 01:00:00	NQ	Futures	5386.18	5389.45	5385.59	5387.37	272.0
2016-06-07 02:00:00	NQ	Futures	5387.97	5394.21	5387.97	5390.94	778.0
2016-06-07 03:00:00	NQ	Futures	5391.24	5406.71	5391.24	5402.84	4868.0
2016-06-07 04:00:00	NQ	Futures	5403.14	5408.2	5402.25	5406.11	1686.0
2016-06-07 05:00:00	NQ	Futures	5405.82	5409.69	5405.52	5405.82	1745.0
2016-06-07 06:00:00	NQ	Futures	5406.41	5407.3	5404.03	5404.03	2535.0
2016-06-07 07:00:00	NQ	Futures	5404.03	5405.22	5394.51	5396.0	3747.0
2016-06-07 08:00:00	NQ	Futures	5396.0	5396.89	5390.64	5391.54	3473.0
2016-06-07 09:00:00	NQ	Futures	5391.24	5393.62	5382.91	5389.75	26163.0
2016-06-07 10:00:00	NQ	Futures	5389.75	5393.62	5375.77	5379.04	28932.0
2016-06-07 11:00:00	NQ	Futures	5379.04	5388.56	5376.96	5382.01	17838.0
2016-06-07 12:00:00	NQ	Futures	5382.01	5393.02	5381.72	5391.54	10637.0
2016-06-07 13:00:00	NQ	Futures	5391.54	5393.62	5382.91	5383.8	9619.0
2016-06-07 14:00:00	NQ	Futures	5383.5	5387.37	5379.04	5379.63	10834.0
2016-06-07 15:00:00	NQ	Futures	5379.63	5382.31	5368.92	5372.2	23006.0
2016-06-07 16:00:00	NQ	Futures	5371.6	5373.68	5370.41	5371.6	4390.0
2016-06-07 18:00:00	NQ	Futures	5370.41	5371.9	5368.63	5371.3	309.0
2016-06-07 19:00:00	NQ	Futures	5371.3	5372.79	5370.11	5370.11	387.0
2016-06-07 20:00:00	NQ	Futures	5369.82	5370.71	5366.25	5367.73	789.0
2016-06-07 21:00:00	NQ	Futures	5367.44	5368.03	5361.49	5362.08	601.0
2016-06-07 22:00:00	NQ	Futures	5361.78	5365.95	5361.78	5365.95	280.0
2016-06-07 23:00:00	NQ	Futures	5365.95	5371.6	5365.95	5369.82	626.0
2016-06-07 00:00:00	YM	Futures	19180.3	19187.8	19179.2	19184.6	728.0
2016-06-07 01:00:00	YM	Futures	19183.5	19194.2	19180.3	19185.7	503.0
2016-06-07 02:00:00	YM	Futures	19186.7	19208.1	19186.7	19200.7	1209.0
2016-06-07 03:00:00	YM	Futures	19200.7	19241.3	19200.7	19231.7	4938.0

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

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