PREVIEW / futures_1hour / 2014-06-19

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-19.parquet
  size:    49 KB
  rows:    1,533

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-06-19 00:00:00	ES	Futures	2032.79	2032.79	2032.01	2032.53	930.0
2014-06-19 01:00:00	ES	Futures	2032.53	2033.05	2032.01	2032.79	2305.0
2014-06-19 02:00:00	ES	Futures	2032.79	2033.83	2032.27	2033.05	8208.0
2014-06-19 03:00:00	ES	Futures	2033.31	2033.31	2031.23	2031.75	20045.0
2014-06-19 04:00:00	ES	Futures	2031.75	2032.79	2031.49	2032.53	9875.0
2014-06-19 05:00:00	ES	Futures	2032.53	2033.83	2031.75	2032.01	14722.0
2014-06-19 06:00:00	ES	Futures	2032.27	2032.53	2030.96	2031.23	8823.0
2014-06-19 07:00:00	ES	Futures	2031.49	2032.01	2030.96	2031.49	8071.0
2014-06-19 08:00:00	ES	Futures	2031.75	2033.57	2031.49	2033.05	24960.0
2014-06-19 09:00:00	ES	Futures	2032.79	2035.13	2031.49	2032.01	156668.0
2014-06-19 10:00:00	ES	Futures	2032.01	2033.83	2029.14	2029.4	230555.0
2014-06-19 11:00:00	ES	Futures	2029.4	2030.96	2028.62	2030.44	121812.0
2014-06-19 12:00:00	ES	Futures	2030.44	2031.23	2028.36	2028.62	78461.0
2014-06-19 13:00:00	ES	Futures	2028.62	2030.18	2026.53	2029.4	125898.0
2014-06-19 14:00:00	ES	Futures	2029.66	2031.49	2028.88	2031.23	101545.0
2014-06-19 15:00:00	ES	Futures	2031.23	2034.09	2030.7	2033.83	176718.0
2014-06-19 16:00:00	ES	Futures	2033.83	2034.09	2032.01	2032.79	62221.0
2014-06-19 17:00:00	ES	Futures	2032.79	2032.79	2032.01	2032.27	2783.0
2014-06-19 18:00:00	ES	Futures	2031.75	2032.53	2031.75	2032.01	2684.0
2014-06-19 19:00:00	ES	Futures	2031.75	2032.53	2031.49	2032.01	1492.0
2014-06-19 20:00:00	ES	Futures	2032.01	2032.27	2031.23	2031.23	3062.0
2014-06-19 21:00:00	ES	Futures	2031.49	2032.79	2031.23	2032.01	3419.0
2014-06-19 22:00:00	ES	Futures	2032.27	2033.31	2032.01	2033.31	2084.0
2014-06-19 23:00:00	ES	Futures	2033.05	2033.31	2032.27	2032.53	1370.0
2014-06-19 00:00:00	NQ	Futures	4437.16	4437.16	4436.0	4436.87	191.0
2014-06-19 01:00:00	NQ	Futures	4436.58	4438.33	4435.7	4437.75	340.0
2014-06-19 02:00:00	NQ	Futures	4437.75	4441.84	4436.58	4441.25	1594.0
2014-06-19 03:00:00	NQ	Futures	4440.96	4441.54	4435.41	4437.75	2828.0
2014-06-19 04:00:00	NQ	Futures	4437.75	4440.38	4436.29	4439.79	1471.0
2014-06-19 05:00:00	NQ	Futures	4439.79	4442.42	4438.04	4438.33	2225.0
2014-06-19 06:00:00	NQ	Futures	4438.33	4439.5	4435.7	4436.58	1411.0
2014-06-19 07:00:00	NQ	Futures	4436.87	4437.46	4435.41	4436.0	1089.0
2014-06-19 08:00:00	NQ	Futures	4436.0	4438.92	4435.7	4438.04	4499.0
2014-06-19 09:00:00	NQ	Futures	4437.75	4441.54	4428.69	4430.74	24540.0
2014-06-19 10:00:00	NQ	Futures	4430.74	4437.46	4420.23	4422.27	42228.0
2014-06-19 11:00:00	NQ	Futures	4422.27	4426.07	4421.1	4423.44	19760.0
2014-06-19 12:00:00	NQ	Futures	4423.15	4427.82	4413.51	4414.97	16469.0
2014-06-19 13:00:00	NQ	Futures	4415.26	4417.31	4408.55	4414.97	22209.0
2014-06-19 14:00:00	NQ	Futures	4415.26	4424.9	4412.63	4423.15	19231.0
2014-06-19 15:00:00	NQ	Futures	4423.44	4430.15	4422.56	4428.99	26385.0
2014-06-19 16:00:00	NQ	Futures	4428.99	4429.57	4422.56	4424.02	7716.0
2014-06-19 17:00:00	NQ	Futures	4424.31	4424.31	4423.15	4423.15	111.0
2014-06-19 18:00:00	NQ	Futures	4422.27	4422.85	4421.39	4421.69	398.0
2014-06-19 19:00:00	NQ	Futures	4421.69	4423.15	4421.39	4422.27	206.0
2014-06-19 20:00:00	NQ	Futures	4422.27	4422.85	4420.81	4421.39	493.0
2014-06-19 21:00:00	NQ	Futures	4421.39	4424.02	4420.81	4422.56	299.0
2014-06-19 22:00:00	NQ	Futures	4422.56	4424.9	4422.56	4424.9	242.0
2014-06-19 23:00:00	NQ	Futures	4424.9	4424.9	4423.15	4423.15	336.0
2014-06-19 00:00:00	YM	Futures	17405.6	17407.6	17402.5	17404.5	237.0
2014-06-19 01:00:00	YM	Futures	17403.5	17408.7	17400.4	17407.6	432.0

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

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