PREVIEW / futures_1hour / 2013-02-14

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-02-14.parquet
  size:    50 KB
  rows:    1,544

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
2013-02-14 00:00:00	ES	Futures	1557.51	1558.02	1557.25	1557.51	3379.0
2013-02-14 01:00:00	ES	Futures	1557.51	1557.51	1555.97	1555.97	4821.0
2013-02-14 02:00:00	ES	Futures	1555.97	1556.48	1555.46	1555.97	6423.0
2013-02-14 03:00:00	ES	Futures	1555.97	1557.25	1555.46	1557.25	18326.0
2013-02-14 04:00:00	ES	Futures	1557.25	1557.25	1554.43	1554.43	19269.0
2013-02-14 05:00:00	ES	Futures	1554.43	1554.69	1550.58	1551.09	55651.0
2013-02-14 06:00:00	ES	Futures	1550.84	1552.12	1549.81	1551.61	36066.0
2013-02-14 07:00:00	ES	Futures	1551.86	1553.66	1550.84	1552.89	52122.0
2013-02-14 08:00:00	ES	Futures	1552.89	1555.46	1552.12	1552.89	65444.0
2013-02-14 09:00:00	ES	Futures	1552.89	1555.71	1550.58	1553.92	237161.0
2013-02-14 10:00:00	ES	Futures	1553.92	1558.79	1553.92	1557.76	253325.0
2013-02-14 11:00:00	ES	Futures	1557.76	1558.53	1555.71	1556.99	128369.0
2013-02-14 12:00:00	ES	Futures	1556.74	1559.05	1556.48	1558.79	81470.0
2013-02-14 13:00:00	ES	Futures	1558.53	1559.82	1556.99	1558.02	87057.0
2013-02-14 14:00:00	ES	Futures	1558.02	1560.33	1557.76	1559.3	79702.0
2013-02-14 15:00:00	ES	Futures	1559.56	1560.84	1558.02	1559.05	146498.0
2013-02-14 16:00:00	ES	Futures	1559.05	1559.82	1558.02	1558.53	64795.0
2013-02-14 17:00:00	ES	Futures	1558.79	1559.3	1558.53	1558.79	1817.0
2013-02-14 18:00:00	ES	Futures	1558.79	1559.05	1558.28	1558.53	3834.0
2013-02-14 19:00:00	ES	Futures	1558.28	1559.05	1558.28	1558.53	2118.0
2013-02-14 20:00:00	ES	Futures	1558.53	1558.53	1557.25	1557.76	3440.0
2013-02-14 21:00:00	ES	Futures	1557.76	1558.28	1557.51	1558.02	2022.0
2013-02-14 22:00:00	ES	Futures	1558.02	1558.28	1556.74	1556.74	6193.0
2013-02-14 23:00:00	ES	Futures	1556.74	1556.99	1555.2	1555.2	6606.0
2013-02-14 00:00:00	NQ	Futures	3223.59	3224.17	3223.01	3223.59	190.0
2013-02-14 01:00:00	NQ	Futures	3223.59	3223.59	3220.97	3220.97	296.0
2013-02-14 02:00:00	NQ	Futures	3221.26	3221.84	3219.52	3220.1	462.0
2013-02-14 03:00:00	NQ	Futures	3220.1	3222.43	3218.64	3221.84	1537.0
2013-02-14 04:00:00	NQ	Futures	3221.55	3222.13	3217.48	3218.06	2402.0
2013-02-14 05:00:00	NQ	Futures	3218.06	3218.06	3209.62	3211.07	4639.0
2013-02-14 06:00:00	NQ	Futures	3210.78	3213.98	3208.75	3213.11	2787.0
2013-02-14 07:00:00	NQ	Futures	3213.11	3215.44	3211.37	3213.4	2576.0
2013-02-14 08:00:00	NQ	Futures	3213.4	3218.93	3212.82	3213.98	5990.0
2013-02-14 09:00:00	NQ	Futures	3213.69	3219.52	3209.91	3212.24	30651.0
2013-02-14 10:00:00	NQ	Futures	3212.24	3225.05	3211.95	3222.72	31931.0
2013-02-14 11:00:00	NQ	Futures	3222.72	3224.46	3219.81	3221.84	12996.0
2013-02-14 12:00:00	NQ	Futures	3221.84	3229.7	3221.55	3229.12	11427.0
2013-02-14 13:00:00	NQ	Futures	3229.12	3230.87	3224.17	3226.21	12340.0
2013-02-14 14:00:00	NQ	Futures	3226.5	3230.28	3223.88	3224.75	11274.0
2013-02-14 15:00:00	NQ	Futures	3225.05	3229.12	3221.84	3225.05	17500.0
2013-02-14 16:00:00	NQ	Futures	3225.05	3225.05	3222.72	3223.59	3939.0
2013-02-14 17:00:00	NQ	Futures	3223.59	3227.08	3223.3	3226.5	234.0
2013-02-14 18:00:00	NQ	Futures	3224.17	3225.05	3223.59	3224.17	385.0
2013-02-14 19:00:00	NQ	Futures	3224.17	3224.75	3223.59	3224.46	228.0
2013-02-14 20:00:00	NQ	Futures	3224.46	3224.46	3220.97	3222.13	496.0
2013-02-14 21:00:00	NQ	Futures	3221.55	3222.72	3221.26	3222.43	195.0
2013-02-14 22:00:00	NQ	Futures	3222.43	3223.3	3220.68	3220.68	275.0
2013-02-14 23:00:00	NQ	Futures	3220.97	3220.97	3218.35	3218.64	310.0
2013-02-14 00:00:00	YM	Futures	14047.1	14049.1	14044.1	14044.1	145.0
2013-02-14 01:00:00	YM	Futures	14045.1	14045.1	14035.1	14037.1	263.0

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

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