PREVIEW / futures_1hour / 2013-06-24

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-24.parquet
  size:    52 KB
  rows:    1,532

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-06-24 00:00:00	ES	Futures	1631.1	1633.17	1630.07	1632.65	3107.0
2013-06-24 01:00:00	ES	Futures	1632.91	1633.43	1628.26	1628.78	6008.0
2013-06-24 02:00:00	ES	Futures	1628.78	1629.55	1625.93	1627.48	15850.0
2013-06-24 03:00:00	ES	Futures	1627.48	1633.95	1627.22	1631.1	31166.0
2013-06-24 04:00:00	ES	Futures	1630.84	1631.88	1623.35	1625.93	62386.0
2013-06-24 05:00:00	ES	Futures	1625.67	1628.78	1624.12	1626.19	20369.0
2013-06-24 06:00:00	ES	Futures	1626.19	1626.97	1622.31	1623.61	33744.0
2013-06-24 07:00:00	ES	Futures	1623.35	1624.64	1618.18	1621.8	57388.0
2013-06-24 08:00:00	ES	Futures	1621.8	1628.78	1619.99	1628.0	84344.0
2013-06-24 09:00:00	ES	Futures	1628.26	1628.26	1612.49	1613.27	391707.0
2013-06-24 10:00:00	ES	Futures	1613.52	1618.18	1608.87	1614.82	455336.0
2013-06-24 11:00:00	ES	Futures	1614.82	1616.37	1606.29	1611.2	321735.0
2013-06-24 12:00:00	ES	Futures	1611.46	1615.33	1606.03	1614.82	254401.0
2013-06-24 13:00:00	ES	Futures	1614.82	1623.09	1612.23	1622.31	254157.0
2013-06-24 14:00:00	ES	Futures	1622.31	1633.95	1620.5	1628.52	340426.0
2013-06-24 15:00:00	ES	Futures	1628.52	1631.88	1619.21	1619.47	353928.0
2013-06-24 16:00:00	ES	Futures	1619.47	1620.76	1618.69	1620.25	90175.0
2013-06-24 17:00:00	ES	Futures	1620.25	1620.25	1618.95	1619.21	1781.0
2013-06-24 18:00:00	ES	Futures	1619.73	1623.86	1619.47	1623.09	9756.0
2013-06-24 19:00:00	ES	Futures	1623.09	1623.35	1619.73	1623.35	6413.0
2013-06-24 20:00:00	ES	Futures	1623.35	1624.12	1621.02	1623.61	6243.0
2013-06-24 21:00:00	ES	Futures	1623.61	1626.19	1622.31	1625.93	9645.0
2013-06-24 22:00:00	ES	Futures	1625.93	1627.22	1622.31	1622.83	8725.0
2013-06-24 23:00:00	ES	Futures	1622.83	1622.83	1613.78	1614.3	17039.0
2013-06-24 00:00:00	NQ	Futures	3338.5	3342.3	3336.46	3342.01	721.0
2013-06-24 01:00:00	NQ	Futures	3342.01	3343.47	3332.66	3333.83	731.0
2013-06-24 02:00:00	NQ	Futures	3333.83	3335.58	3328.27	3330.9	1490.0
2013-06-24 03:00:00	NQ	Futures	3330.61	3345.52	3330.61	3339.96	2859.0
2013-06-24 04:00:00	NQ	Futures	3340.26	3341.72	3325.94	3332.07	5622.0
2013-06-24 05:00:00	NQ	Futures	3332.07	3339.38	3328.27	3332.07	3680.0
2013-06-24 06:00:00	NQ	Futures	3332.37	3334.41	3325.64	3326.81	2327.0
2013-06-24 07:00:00	NQ	Futures	3327.11	3330.03	3318.63	3324.48	4444.0
2013-06-24 08:00:00	NQ	Futures	3324.48	3338.79	3321.55	3337.33	7747.0
2013-06-24 09:00:00	NQ	Futures	3337.33	3337.63	3302.85	3304.02	63612.0
2013-06-24 10:00:00	NQ	Futures	3304.02	3320.38	3296.13	3312.2	61835.0
2013-06-24 11:00:00	NQ	Futures	3312.2	3315.12	3293.79	3306.65	39211.0
2013-06-24 12:00:00	NQ	Futures	3306.36	3315.71	3296.13	3314.54	35481.0
2013-06-24 13:00:00	NQ	Futures	3314.83	3326.23	3308.99	3325.35	30703.0
2013-06-24 14:00:00	NQ	Futures	3325.06	3347.56	3321.85	3338.5	39499.0
2013-06-24 15:00:00	NQ	Futures	3338.21	3345.52	3321.55	3321.55	41728.0
2013-06-24 16:00:00	NQ	Futures	3321.85	3328.86	3320.97	3327.4	10310.0
2013-06-24 17:00:00	NQ	Futures	3327.69	3327.69	3325.94	3326.52	105.0
2013-06-24 18:00:00	NQ	Futures	3327.11	3334.7	3325.06	3333.24	508.0
2013-06-24 19:00:00	NQ	Futures	3333.24	3333.53	3327.4	3333.53	668.0
2013-06-24 20:00:00	NQ	Futures	3333.24	3334.41	3328.27	3333.53	1175.0
2013-06-24 21:00:00	NQ	Futures	3333.53	3337.92	3331.49	3337.92	1401.0
2013-06-24 22:00:00	NQ	Futures	3337.63	3340.26	3330.61	3330.9	1276.0
2013-06-24 23:00:00	NQ	Futures	3330.9	3330.9	3314.25	3315.71	2901.0
2013-06-24 00:00:00	YM	Futures	14888.9	14903.1	14882.8	14902.1	665.0
2013-06-24 01:00:00	YM	Futures	14903.1	14906.1	14866.5	14870.6	910.0

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

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