PREVIEW / futures_30min / 2013-07-26

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-07-26.parquet
  size:    66 KB
  rows:    2,312

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-07-26 00:00:00	ES	Futures	1744.84	1746.39	1744.58	1745.87	3026.0
2013-07-26 00:30:00	ES	Futures	1745.62	1745.87	1745.1	1745.36	974.0
2013-07-26 01:00:00	ES	Futures	1745.1	1745.36	1744.32	1744.84	1911.0
2013-07-26 01:30:00	ES	Futures	1744.58	1745.1	1743.55	1743.81	2335.0
2013-07-26 02:00:00	ES	Futures	1743.81	1744.32	1742.26	1744.32	4931.0
2013-07-26 02:30:00	ES	Futures	1744.06	1744.32	1742.77	1743.29	2126.0
2013-07-26 03:00:00	ES	Futures	1743.29	1745.36	1740.96	1741.48	14473.0
2013-07-26 03:30:00	ES	Futures	1741.22	1741.48	1739.15	1739.93	11153.0
2013-07-26 04:00:00	ES	Futures	1739.93	1741.22	1739.15	1740.19	9594.0
2013-07-26 04:30:00	ES	Futures	1739.93	1741.48	1739.93	1741.22	7052.0
2013-07-26 05:00:00	ES	Futures	1741.22	1741.48	1739.41	1739.67	4875.0
2013-07-26 05:30:00	ES	Futures	1739.67	1739.93	1735.79	1736.31	14933.0
2013-07-26 06:00:00	ES	Futures	1736.31	1737.34	1735.02	1735.79	10351.0
2013-07-26 06:30:00	ES	Futures	1735.79	1736.83	1735.53	1736.83	7548.0
2013-07-26 07:00:00	ES	Futures	1736.57	1737.34	1735.28	1735.79	10581.0
2013-07-26 07:30:00	ES	Futures	1735.79	1735.79	1733.47	1734.24	14400.0
2013-07-26 08:00:00	ES	Futures	1733.98	1735.28	1733.72	1734.5	12656.0
2013-07-26 08:30:00	ES	Futures	1734.5	1734.5	1731.92	1731.92	21609.0
2013-07-26 09:00:00	ES	Futures	1732.17	1735.02	1731.92	1735.02	31993.0
2013-07-26 09:30:00	ES	Futures	1735.02	1737.09	1733.98	1736.57	132302.0
2013-07-26 10:00:00	ES	Futures	1736.57	1738.12	1733.47	1733.47	105259.0
2013-07-26 10:30:00	ES	Futures	1733.72	1734.5	1727.26	1729.07	183009.0
2013-07-26 11:00:00	ES	Futures	1728.81	1731.4	1727.26	1730.36	96181.0
2013-07-26 11:30:00	ES	Futures	1730.11	1733.72	1730.11	1733.21	66153.0
2013-07-26 12:00:00	ES	Futures	1733.21	1735.53	1733.21	1735.53	49099.0
2013-07-26 12:30:00	ES	Futures	1735.53	1736.57	1735.02	1735.02	41215.0
2013-07-26 13:00:00	ES	Futures	1735.28	1739.41	1735.02	1738.89	62316.0
2013-07-26 13:30:00	ES	Futures	1738.89	1739.15	1737.34	1738.12	40112.0
2013-07-26 14:00:00	ES	Futures	1738.12	1740.45	1736.31	1736.57	71073.0
2013-07-26 14:30:00	ES	Futures	1736.57	1740.96	1736.31	1739.67	50533.0
2013-07-26 15:00:00	ES	Futures	1739.67	1742.51	1738.89	1741.22	77039.0
2013-07-26 15:30:00	ES	Futures	1741.22	1744.58	1740.19	1744.32	132348.0
2013-07-26 16:00:00	ES	Futures	1744.32	1745.1	1743.29	1744.06	67329.0
2013-07-26 16:30:00	ES	Futures	1744.06	1744.32	1743.81	1744.32	3259.0
2013-07-26 17:00:00	ES	Futures	1744.06	1744.84	1743.81	1744.32	2086.0
2013-07-26 00:00:00	NQ	Futures	3572.29	3574.63	3572.0	3573.75	391.0
2013-07-26 00:30:00	NQ	Futures	3573.46	3574.04	3572.58	3572.88	100.0
2013-07-26 01:00:00	NQ	Futures	3573.17	3573.46	3571.71	3572.29	276.0
2013-07-26 01:30:00	NQ	Futures	3572.0	3572.58	3569.95	3570.25	274.0
2013-07-26 02:00:00	NQ	Futures	3569.66	3573.17	3568.2	3572.88	538.0
2013-07-26 02:30:00	NQ	Futures	3573.17	3573.17	3569.66	3570.83	211.0
2013-07-26 03:00:00	NQ	Futures	3570.83	3575.51	3566.74	3567.03	1998.0
2013-07-26 03:30:00	NQ	Futures	3566.74	3567.32	3562.06	3563.23	2035.0
2013-07-26 04:00:00	NQ	Futures	3562.94	3566.74	3561.19	3564.4	1479.0
2013-07-26 04:30:00	NQ	Futures	3564.4	3567.62	3564.11	3566.15	1388.0
2013-07-26 05:00:00	NQ	Futures	3566.45	3567.32	3562.94	3562.94	691.0
2013-07-26 05:30:00	NQ	Futures	3562.65	3563.23	3555.05	3555.93	2294.0
2013-07-26 06:00:00	NQ	Futures	3555.63	3557.09	3553.88	3555.63	1637.0
2013-07-26 06:30:00	NQ	Futures	3555.93	3558.26	3555.05	3558.26	1127.0
2013-07-26 07:00:00	NQ	Futures	3557.97	3560.02	3557.09	3557.68	1365.0

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

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