PREVIEW / futures_1hour / 2014-09-12

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-12.parquet
  size:    41 KB
  rows:    1,228

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-12 00:00:00	ES	Futures	2082.05	2082.57	2081.78	2082.05	1295.0
2014-09-12 01:00:00	ES	Futures	2081.78	2083.09	2081.52	2082.83	2016.0
2014-09-12 02:00:00	ES	Futures	2082.57	2082.83	2081.78	2082.31	3401.0
2014-09-12 03:00:00	ES	Futures	2082.31	2082.83	2080.22	2081.0	9865.0
2014-09-12 04:00:00	ES	Futures	2081.0	2081.78	2079.96	2079.96	4994.0
2014-09-12 05:00:00	ES	Futures	2079.96	2081.52	2079.96	2081.26	3063.0
2014-09-12 06:00:00	ES	Futures	2081.0	2082.31	2081.0	2081.26	3850.0
2014-09-12 07:00:00	ES	Futures	2081.52	2083.35	2081.26	2082.31	8850.0
2014-09-12 08:00:00	ES	Futures	2082.05	2082.57	2078.92	2080.22	19203.0
2014-09-12 09:00:00	ES	Futures	2080.22	2081.52	2073.71	2073.71	81667.0
2014-09-12 10:00:00	ES	Futures	2073.71	2077.88	2070.58	2076.83	108560.0
2014-09-12 11:00:00	ES	Futures	2076.57	2077.09	2071.1	2073.18	41143.0
2014-09-12 12:00:00	ES	Futures	2073.18	2073.97	2068.75	2070.06	44513.0
2014-09-12 13:00:00	ES	Futures	2070.06	2071.1	2065.11	2067.19	59286.0
2014-09-12 14:00:00	ES	Futures	2067.45	2070.06	2063.54	2064.58	46339.0
2014-09-12 15:00:00	ES	Futures	2064.58	2070.32	2063.8	2069.8	75396.0
2014-09-12 16:00:00	ES	Futures	2069.8	2070.06	2068.49	2068.49	22396.0
2014-09-12 17:00:00	ES	Futures	2068.75	2068.75	2067.97	2068.23	845.0
2014-09-12 00:00:00	NQ	Futures	4780.57	4780.57	4779.4	4779.4	168.0
2014-09-12 01:00:00	NQ	Futures	4779.4	4780.57	4779.11	4779.99	317.0
2014-09-12 02:00:00	NQ	Futures	4780.28	4781.45	4779.99	4780.57	276.0
2014-09-12 03:00:00	NQ	Futures	4780.86	4782.03	4775.9	4777.36	1431.0
2014-09-12 04:00:00	NQ	Futures	4777.65	4779.7	4774.44	4774.73	699.0
2014-09-12 05:00:00	NQ	Futures	4774.44	4778.53	4774.44	4777.36	496.0
2014-09-12 06:00:00	NQ	Futures	4777.36	4779.4	4777.36	4777.36	522.0
2014-09-12 07:00:00	NQ	Futures	4777.65	4781.74	4776.48	4778.53	960.0
2014-09-12 08:00:00	NQ	Futures	4778.24	4778.82	4772.98	4777.07	1646.0
2014-09-12 09:00:00	NQ	Futures	4777.07	4777.94	4756.34	4756.63	16384.0
2014-09-12 10:00:00	NQ	Futures	4756.63	4768.6	4749.91	4767.14	19057.0
2014-09-12 11:00:00	NQ	Futures	4767.43	4769.77	4755.46	4761.88	7544.0
2014-09-12 12:00:00	NQ	Futures	4761.88	4764.8	4751.66	4757.21	6684.0
2014-09-12 13:00:00	NQ	Futures	4756.63	4759.55	4743.49	4749.62	6673.0
2014-09-12 14:00:00	NQ	Futures	4749.33	4758.09	4738.52	4742.03	7719.0
2014-09-12 15:00:00	NQ	Futures	4742.32	4754.58	4739.4	4754.0	9994.0
2014-09-12 16:00:00	NQ	Futures	4754.58	4756.04	4750.49	4751.08	1731.0
2014-09-12 17:00:00	NQ	Futures	4751.08	4751.66	4748.45	4748.45	843.0
2014-09-12 00:00:00	YM	Futures	17634.4	17637.5	17633.3	17633.3	257.0
2014-09-12 01:00:00	YM	Futures	17633.3	17641.7	17629.2	17641.7	636.0
2014-09-12 02:00:00	YM	Futures	17640.6	17641.7	17635.4	17638.5	496.0
2014-09-12 03:00:00	YM	Futures	17637.5	17642.7	17622.9	17628.1	2875.0
2014-09-12 04:00:00	YM	Futures	17628.1	17632.3	17618.8	17618.8	1526.0
2014-09-12 05:00:00	YM	Futures	17619.8	17630.2	17619.8	17627.1	1371.0
2014-09-12 06:00:00	YM	Futures	17628.1	17639.6	17628.1	17635.4	1504.0
2014-09-12 07:00:00	YM	Futures	17635.4	17645.8	17632.3	17638.5	1434.0
2014-09-12 08:00:00	YM	Futures	17637.5	17640.6	17614.6	17621.9	2514.0
2014-09-12 09:00:00	YM	Futures	17621.9	17628.1	17578.2	17580.3	13608.0
2014-09-12 10:00:00	YM	Futures	17580.3	17630.2	17555.4	17622.9	20399.0
2014-09-12 11:00:00	YM	Futures	17622.9	17625.0	17574.1	17587.6	11390.0
2014-09-12 12:00:00	YM	Futures	17586.6	17593.8	17558.5	17569.9	11985.0
2014-09-12 13:00:00	YM	Futures	17568.9	17578.2	17528.3	17543.9	14535.0

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

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