PREVIEW / futures_1hour / 2015-02-25

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-02-25.parquet
  size:    49 KB
  rows:    1,537

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-02-25 00:00:00	ES	Futures	2224.16	2224.69	2223.9	2224.42	1264.0
2015-02-25 01:00:00	ES	Futures	2224.42	2225.21	2223.9	2224.42	1158.0
2015-02-25 02:00:00	ES	Futures	2224.69	2224.69	2222.32	2222.84	4714.0
2015-02-25 03:00:00	ES	Futures	2222.84	2225.48	2222.84	2223.37	12610.0
2015-02-25 04:00:00	ES	Futures	2223.63	2224.42	2221.79	2222.32	9329.0
2015-02-25 05:00:00	ES	Futures	2222.32	2223.9	2222.05	2222.84	5655.0
2015-02-25 06:00:00	ES	Futures	2222.84	2223.37	2221.26	2221.53	7722.0
2015-02-25 07:00:00	ES	Futures	2221.53	2223.63	2221.0	2222.84	11338.0
2015-02-25 08:00:00	ES	Futures	2222.84	2223.63	2222.32	2222.84	9085.0
2015-02-25 09:00:00	ES	Futures	2222.84	2224.16	2219.69	2221.26	101719.0
2015-02-25 10:00:00	ES	Futures	2221.26	2223.63	2220.21	2222.58	137882.0
2015-02-25 11:00:00	ES	Futures	2222.84	2225.74	2221.0	2224.16	123579.0
2015-02-25 12:00:00	ES	Futures	2224.42	2226.0	2223.9	2225.21	61835.0
2015-02-25 13:00:00	ES	Futures	2225.21	2229.16	2224.42	2227.84	97408.0
2015-02-25 14:00:00	ES	Futures	2227.84	2228.37	2219.42	2221.79	137261.0
2015-02-25 15:00:00	ES	Futures	2221.79	2223.63	2218.11	2222.58	178610.0
2015-02-25 16:00:00	ES	Futures	2222.32	2223.11	2221.0	2222.05	51135.0
2015-02-25 17:00:00	ES	Futures	2222.05	2222.32	2221.53	2221.53	1873.0
2015-02-25 18:00:00	ES	Futures	2221.53	2222.05	2220.74	2220.74	3484.0
2015-02-25 19:00:00	ES	Futures	2221.0	2222.32	2220.74	2222.05	1924.0
2015-02-25 20:00:00	ES	Futures	2222.05	2222.32	2221.26	2221.53	1483.0
2015-02-25 21:00:00	ES	Futures	2221.79	2222.58	2221.53	2222.05	881.0
2015-02-25 22:00:00	ES	Futures	2222.05	2223.9	2222.05	2222.84	2789.0
2015-02-25 23:00:00	ES	Futures	2222.84	2223.37	2222.58	2222.84	830.0
2015-02-25 00:00:00	NQ	Futures	5224.13	5225.3	5223.54	5225.3	159.0
2015-02-25 01:00:00	NQ	Futures	5224.72	5226.19	5223.54	5224.72	169.0
2015-02-25 02:00:00	NQ	Futures	5224.72	5225.3	5220.9	5222.95	676.0
2015-02-25 03:00:00	NQ	Futures	5222.66	5227.07	5221.78	5223.54	1349.0
2015-02-25 04:00:00	NQ	Futures	5223.54	5225.89	5218.26	5219.14	1541.0
2015-02-25 05:00:00	NQ	Futures	5218.84	5222.07	5218.55	5220.6	636.0
2015-02-25 06:00:00	NQ	Futures	5220.31	5221.19	5217.37	5217.96	1133.0
2015-02-25 07:00:00	NQ	Futures	5217.96	5221.49	5216.79	5220.31	1522.0
2015-02-25 08:00:00	NQ	Futures	5220.6	5222.37	5217.37	5219.14	2141.0
2015-02-25 09:00:00	NQ	Futures	5219.14	5221.78	5213.56	5220.9	22801.0
2015-02-25 10:00:00	NQ	Futures	5220.9	5230.0	5218.26	5228.24	23591.0
2015-02-25 11:00:00	NQ	Futures	5228.53	5234.11	5225.01	5228.53	19050.0
2015-02-25 12:00:00	NQ	Futures	5228.83	5236.76	5227.07	5234.11	10430.0
2015-02-25 13:00:00	NQ	Futures	5234.11	5240.58	5231.77	5237.35	11543.0
2015-02-25 14:00:00	NQ	Futures	5237.35	5237.93	5207.39	5216.49	30566.0
2015-02-25 15:00:00	NQ	Futures	5216.2	5217.37	5203.28	5214.73	39597.0
2015-02-25 16:00:00	NQ	Futures	5214.44	5216.49	5210.03	5213.56	4170.0
2015-02-25 17:00:00	NQ	Futures	5213.56	5216.2	5212.68	5215.32	441.0
2015-02-25 18:00:00	NQ	Futures	5214.14	5214.14	5210.33	5210.91	455.0
2015-02-25 19:00:00	NQ	Futures	5210.91	5213.56	5210.91	5213.26	420.0
2015-02-25 20:00:00	NQ	Futures	5213.26	5214.44	5212.09	5212.38	561.0
2015-02-25 21:00:00	NQ	Futures	5212.09	5214.44	5212.09	5214.44	162.0
2015-02-25 22:00:00	NQ	Futures	5214.14	5217.96	5214.14	5214.44	555.0
2015-02-25 23:00:00	NQ	Futures	5215.02	5215.61	5214.44	5214.73	129.0
2015-02-25 00:00:00	YM	Futures	18977.7	18981.9	18977.7	18981.9	86.0
2015-02-25 01:00:00	YM	Futures	18980.8	18986.0	18975.6	18981.9	302.0

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

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