PREVIEW / futures_1hour / 2014-09-10

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-10.parquet
  size:    47 KB
  rows:    1,480

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
2014-09-10 00:00:00	ES	Futures	2071.36	2072.14	2071.1	2072.14	1811.0
2014-09-10 01:00:00	ES	Futures	2072.14	2072.14	2070.58	2070.84	4658.0
2014-09-10 02:00:00	ES	Futures	2070.84	2072.4	2070.58	2071.36	9994.0
2014-09-10 03:00:00	ES	Futures	2071.1	2072.4	2069.8	2071.62	33113.0
2014-09-10 04:00:00	ES	Futures	2071.62	2072.66	2070.32	2072.14	21440.0
2014-09-10 05:00:00	ES	Futures	2072.14	2075.79	2071.1	2075.79	24434.0
2014-09-10 06:00:00	ES	Futures	2075.53	2076.83	2074.23	2075.53	19946.0
2014-09-10 07:00:00	ES	Futures	2075.53	2076.57	2071.62	2073.71	29339.0
2014-09-10 08:00:00	ES	Futures	2073.97	2074.49	2070.84	2072.14	25693.0
2014-09-10 09:00:00	ES	Futures	2072.14	2074.49	2067.19	2068.49	181975.0
2014-09-10 10:00:00	ES	Futures	2068.75	2071.36	2065.63	2068.23	262372.0
2014-09-10 11:00:00	ES	Futures	2067.97	2073.97	2066.41	2072.92	150126.0
2014-09-10 12:00:00	ES	Futures	2072.92	2076.57	2071.62	2074.49	102230.0
2014-09-10 13:00:00	ES	Futures	2074.49	2080.48	2074.23	2077.35	173953.0
2014-09-10 14:00:00	ES	Futures	2077.61	2079.18	2075.79	2076.83	93819.0
2014-09-10 15:00:00	ES	Futures	2076.57	2081.0	2076.57	2079.96	143797.0
2014-09-10 16:00:00	ES	Futures	2079.7	2080.48	2079.44	2080.22	55820.0
2014-09-10 17:00:00	ES	Futures	2079.96	2080.22	2079.44	2079.44	2221.0
2014-09-10 18:00:00	ES	Futures	2079.18	2079.7	2077.61	2078.66	4362.0
2014-09-10 19:00:00	ES	Futures	2078.66	2079.44	2077.88	2078.92	1904.0
2014-09-10 20:00:00	ES	Futures	2078.92	2079.18	2077.88	2078.14	3213.0
2014-09-10 21:00:00	ES	Futures	2078.14	2079.18	2077.35	2077.61	4395.0
2014-09-10 22:00:00	ES	Futures	2077.35	2078.66	2076.57	2077.35	5291.0
2014-09-10 23:00:00	ES	Futures	2077.35	2077.61	2076.31	2077.35	3886.0
2014-09-10 00:00:00	NQ	Futures	4742.32	4744.95	4742.03	4744.65	365.0
2014-09-10 01:00:00	NQ	Futures	4744.65	4744.95	4741.44	4742.32	680.0
2014-09-10 02:00:00	NQ	Futures	4742.32	4746.41	4741.73	4743.19	1588.0
2014-09-10 03:00:00	NQ	Futures	4742.9	4747.28	4740.27	4744.65	4902.0
2014-09-10 04:00:00	NQ	Futures	4744.65	4746.41	4739.98	4745.24	4038.0
2014-09-10 05:00:00	NQ	Futures	4745.24	4756.34	4744.07	4756.34	3919.0
2014-09-10 06:00:00	NQ	Futures	4756.04	4758.09	4753.71	4756.04	3306.0
2014-09-10 07:00:00	NQ	Futures	4756.04	4757.21	4745.82	4749.03	4216.0
2014-09-10 08:00:00	NQ	Futures	4749.03	4750.49	4742.32	4746.99	5246.0
2014-09-10 09:00:00	NQ	Futures	4746.7	4758.38	4739.11	4743.19	41109.0
2014-09-10 10:00:00	NQ	Futures	4743.19	4753.71	4736.19	4749.33	50558.0
2014-09-10 11:00:00	NQ	Futures	4749.03	4760.72	4742.9	4759.26	28738.0
2014-09-10 12:00:00	NQ	Futures	4758.96	4772.69	4756.04	4769.18	21190.0
2014-09-10 13:00:00	NQ	Futures	4768.89	4782.03	4768.89	4774.44	26728.0
2014-09-10 14:00:00	NQ	Futures	4774.44	4778.82	4769.77	4772.98	15890.0
2014-09-10 15:00:00	NQ	Futures	4772.69	4784.66	4772.1	4782.03	23167.0
2014-09-10 16:00:00	NQ	Futures	4782.32	4782.91	4780.28	4781.45	5211.0
2014-09-10 17:00:00	NQ	Futures	4782.03	4782.32	4780.86	4781.45	344.0
2014-09-10 18:00:00	NQ	Futures	4780.86	4781.45	4776.78	4777.65	989.0
2014-09-10 19:00:00	NQ	Futures	4777.94	4780.57	4777.36	4779.99	254.0
2014-09-10 20:00:00	NQ	Futures	4779.99	4779.99	4777.07	4778.24	713.0
2014-09-10 21:00:00	NQ	Futures	4778.24	4780.28	4776.19	4776.19	489.0
2014-09-10 22:00:00	NQ	Futures	4776.48	4779.7	4774.44	4776.78	929.0
2014-09-10 23:00:00	NQ	Futures	4776.78	4778.53	4775.32	4778.53	747.0
2014-09-10 00:00:00	YM	Futures	17595.9	17601.1	17594.9	17601.1	34.0
2014-09-10 01:00:00	YM	Futures	17601.1	17601.1	17590.7	17590.7	10.0

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

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