PREVIEW / futures_1hour / 2015-03-03

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-03.parquet
  size:    50 KB
  rows:    1,531

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
2015-03-03 00:00:00	ES	Futures	2224.16	2224.69	2223.37	2223.37	2285.0
2015-03-03 01:00:00	ES	Futures	2223.37	2223.9	2222.58	2222.84	1621.0
2015-03-03 02:00:00	ES	Futures	2222.58	2223.37	2222.32	2222.58	4573.0
2015-03-03 03:00:00	ES	Futures	2222.84	2223.9	2222.32	2222.84	11642.0
2015-03-03 04:00:00	ES	Futures	2222.84	2223.63	2222.32	2222.84	8650.0
2015-03-03 05:00:00	ES	Futures	2222.84	2224.42	2222.58	2223.63	6855.0
2015-03-03 06:00:00	ES	Futures	2223.9	2223.9	2222.32	2223.11	8667.0
2015-03-03 07:00:00	ES	Futures	2223.11	2223.11	2220.48	2220.74	14031.0
2015-03-03 08:00:00	ES	Futures	2221.0	2221.26	2218.37	2219.95	35293.0
2015-03-03 09:00:00	ES	Futures	2220.21	2221.79	2213.11	2214.42	212294.0
2015-03-03 10:00:00	ES	Futures	2214.42	2217.84	2213.63	2214.42	192670.0
2015-03-03 11:00:00	ES	Futures	2214.69	2215.48	2206.79	2210.21	240626.0
2015-03-03 12:00:00	ES	Futures	2210.21	2213.11	2205.74	2212.58	129387.0
2015-03-03 13:00:00	ES	Futures	2212.84	2214.95	2211.53	2213.11	110255.0
2015-03-03 14:00:00	ES	Futures	2213.11	2218.11	2212.84	2215.74	113125.0
2015-03-03 15:00:00	ES	Futures	2215.74	2218.11	2213.63	2216.79	165707.0
2015-03-03 16:00:00	ES	Futures	2217.05	2217.32	2214.95	2215.48	63147.0
2015-03-03 17:00:00	ES	Futures	2215.48	2216.0	2215.21	2215.48	2029.0
2015-03-03 18:00:00	ES	Futures	2215.48	2215.48	2213.63	2214.16	6984.0
2015-03-03 19:00:00	ES	Futures	2214.42	2214.42	2212.32	2212.32	4774.0
2015-03-03 20:00:00	ES	Futures	2212.32	2213.37	2212.32	2212.84	2840.0
2015-03-03 21:00:00	ES	Futures	2212.84	2213.63	2212.84	2213.63	1327.0
2015-03-03 22:00:00	ES	Futures	2213.63	2214.69	2213.37	2214.16	1315.0
2015-03-03 23:00:00	ES	Futures	2214.16	2214.69	2213.63	2214.16	2084.0
2015-03-03 00:00:00	NQ	Futures	5258.2	5258.78	5256.73	5257.32	270.0
2015-03-03 01:00:00	NQ	Futures	5257.32	5257.32	5254.67	5254.97	297.0
2015-03-03 02:00:00	NQ	Futures	5254.67	5257.32	5254.38	5255.85	600.0
2015-03-03 03:00:00	NQ	Futures	5255.85	5258.2	5254.67	5256.43	1228.0
2015-03-03 04:00:00	NQ	Futures	5256.43	5257.32	5254.38	5256.43	954.0
2015-03-03 05:00:00	NQ	Futures	5256.43	5259.37	5255.85	5258.2	1075.0
2015-03-03 06:00:00	NQ	Futures	5258.2	5258.49	5255.85	5256.14	1120.0
2015-03-03 07:00:00	NQ	Futures	5256.14	5256.14	5252.03	5252.32	1819.0
2015-03-03 08:00:00	NQ	Futures	5252.62	5252.91	5247.33	5249.09	4623.0
2015-03-03 09:00:00	NQ	Futures	5249.39	5254.09	5231.77	5236.17	38042.0
2015-03-03 10:00:00	NQ	Futures	5236.46	5244.39	5226.48	5229.12	31528.0
2015-03-03 11:00:00	NQ	Futures	5229.42	5230.3	5212.97	5220.9	32015.0
2015-03-03 12:00:00	NQ	Futures	5220.9	5225.89	5207.1	5225.3	19970.0
2015-03-03 13:00:00	NQ	Futures	5225.6	5231.18	5222.07	5227.07	15147.0
2015-03-03 14:00:00	NQ	Futures	5227.65	5242.34	5226.48	5236.17	18534.0
2015-03-03 15:00:00	NQ	Futures	5235.88	5241.16	5231.18	5238.81	22195.0
2015-03-03 16:00:00	NQ	Futures	5238.81	5241.16	5234.11	5237.05	6777.0
2015-03-03 17:00:00	NQ	Futures	5236.46	5237.64	5236.17	5236.76	384.0
2015-03-03 18:00:00	NQ	Futures	5237.35	5237.35	5231.18	5233.82	402.0
2015-03-03 19:00:00	NQ	Futures	5233.82	5233.82	5229.12	5229.71	269.0
2015-03-03 20:00:00	NQ	Futures	5229.71	5231.47	5229.12	5230.3	334.0
2015-03-03 21:00:00	NQ	Futures	5230.59	5233.23	5230.3	5232.35	188.0
2015-03-03 22:00:00	NQ	Futures	5232.35	5234.7	5232.35	5234.41	108.0
2015-03-03 23:00:00	NQ	Futures	5234.11	5234.7	5232.06	5234.41	294.0
2015-03-03 00:00:00	YM	Futures	19042.4	19044.5	19038.2	19039.3	335.0
2015-03-03 01:00:00	YM	Futures	19039.3	19041.4	19035.1	19037.2	469.0

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

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