PREVIEW / futures_30min / 2013-06-21

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-06-21.parquet
  size:    72 KB
  rows:    2,378

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-21 00:00:00	ES	Futures	1642.22	1642.22	1640.41	1641.18	2392.0
2013-06-21 00:30:00	ES	Futures	1640.93	1643.77	1640.93	1643.25	3912.0
2013-06-21 01:00:00	ES	Futures	1643.51	1646.09	1643.25	1645.84	6978.0
2013-06-21 01:30:00	ES	Futures	1645.84	1646.09	1644.8	1645.32	4206.0
2013-06-21 02:00:00	ES	Futures	1645.32	1648.16	1645.06	1647.65	11300.0
2013-06-21 02:30:00	ES	Futures	1647.9	1648.42	1645.58	1645.84	8836.0
2013-06-21 03:00:00	ES	Futures	1645.58	1649.2	1645.58	1648.16	19217.0
2013-06-21 03:30:00	ES	Futures	1647.9	1649.46	1646.87	1647.39	14123.0
2013-06-21 04:00:00	ES	Futures	1647.13	1647.65	1644.54	1646.35	19093.0
2013-06-21 04:30:00	ES	Futures	1646.35	1647.39	1645.32	1646.35	10314.0
2013-06-21 05:00:00	ES	Futures	1646.35	1649.2	1645.84	1648.42	13834.0
2013-06-21 05:30:00	ES	Futures	1648.68	1651.52	1648.68	1649.97	18852.0
2013-06-21 06:00:00	ES	Futures	1650.23	1651.01	1649.2	1650.49	16110.0
2013-06-21 06:30:00	ES	Futures	1650.75	1650.75	1649.46	1650.49	23699.0
2013-06-21 07:00:00	ES	Futures	1650.23	1650.49	1647.65	1648.68	26365.0
2013-06-21 07:30:00	ES	Futures	1648.42	1648.42	1646.61	1647.65	23143.0
2013-06-21 08:00:00	ES	Futures	1647.65	1648.42	1644.29	1644.8	40174.0
2013-06-21 08:30:00	ES	Futures	1644.8	1644.8	1640.41	1642.22	69494.0
2013-06-21 09:00:00	ES	Futures	1642.22	1648.68	1641.96	1646.61	81348.0
2013-06-21 09:30:00	ES	Futures	1646.35	1647.9	1640.41	1640.67	334027.0
2013-06-21 10:00:00	ES	Futures	1640.67	1645.32	1636.27	1637.82	214826.0
2013-06-21 10:30:00	ES	Futures	1637.82	1639.63	1631.88	1637.56	259785.0
2013-06-21 11:00:00	ES	Futures	1637.31	1638.86	1627.22	1627.74	250619.0
2013-06-21 11:30:00	ES	Futures	1627.48	1629.03	1623.86	1626.45	214252.0
2013-06-21 12:00:00	ES	Futures	1626.45	1631.36	1624.9	1627.22	168284.0
2013-06-21 12:30:00	ES	Futures	1626.97	1638.86	1626.19	1638.86	171482.0
2013-06-21 13:00:00	ES	Futures	1638.86	1642.48	1634.98	1638.08	134743.0
2013-06-21 13:30:00	ES	Futures	1638.34	1640.93	1632.65	1633.95	90597.0
2013-06-21 14:00:00	ES	Futures	1633.95	1638.6	1631.88	1638.08	84424.0
2013-06-21 14:30:00	ES	Futures	1638.08	1640.93	1636.27	1640.93	91615.0
2013-06-21 15:00:00	ES	Futures	1640.93	1646.09	1639.37	1645.58	116035.0
2013-06-21 15:30:00	ES	Futures	1645.58	1646.09	1638.08	1640.67	191032.0
2013-06-21 16:00:00	ES	Futures	1640.67	1641.18	1637.56	1638.08	111895.0
2013-06-21 16:30:00	ES	Futures	1637.56	1637.82	1635.76	1637.05	13008.0
2013-06-21 17:00:00	ES	Futures	1637.05	1638.08	1637.05	1637.56	4185.0
2013-06-21 00:00:00	NQ	Futures	3371.53	3371.82	3368.6	3369.48	260.0
2013-06-21 00:30:00	NQ	Futures	3370.36	3374.45	3370.36	3374.16	255.0
2013-06-21 01:00:00	NQ	Futures	3374.16	3379.42	3374.16	3379.42	711.0
2013-06-21 01:30:00	NQ	Futures	3379.42	3379.42	3376.49	3377.95	311.0
2013-06-21 02:00:00	NQ	Futures	3377.37	3381.75	3377.08	3381.17	1033.0
2013-06-21 02:30:00	NQ	Futures	3381.17	3382.34	3376.49	3376.79	523.0
2013-06-21 03:00:00	NQ	Futures	3376.79	3382.63	3376.79	3380.58	2227.0
2013-06-21 03:30:00	NQ	Futures	3380.58	3382.34	3378.25	3379.12	1526.0
2013-06-21 04:00:00	NQ	Futures	3378.83	3380.0	3375.03	3378.25	2029.0
2013-06-21 04:30:00	NQ	Futures	3378.54	3382.05	3377.37	3381.17	1419.0
2013-06-21 05:00:00	NQ	Futures	3381.17	3387.89	3380.29	3387.31	2212.0
2013-06-21 05:30:00	NQ	Futures	3387.6	3389.06	3385.84	3387.01	1474.0
2013-06-21 06:00:00	NQ	Futures	3387.31	3388.47	3385.55	3387.31	1213.0
2013-06-21 06:30:00	NQ	Futures	3387.31	3388.18	3385.84	3387.6	1251.0
2013-06-21 07:00:00	NQ	Futures	3387.31	3387.6	3382.92	3386.43	1598.0

> showing 50 of 2,378 rows — these rows as CSV

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