PREVIEW / futures_30min / 2013-07-18

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-07-18.parquet
  size:    77 KB
  rows:    2,838

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-18 00:00:00	ES	Futures	1730.11	1730.36	1729.59	1730.11	617.0
2013-07-18 00:30:00	ES	Futures	1730.36	1730.62	1729.59	1730.36	679.0
2013-07-18 01:00:00	ES	Futures	1730.62	1730.62	1729.59	1730.62	582.0
2013-07-18 01:30:00	ES	Futures	1730.62	1730.88	1730.11	1730.11	2132.0
2013-07-18 02:00:00	ES	Futures	1730.36	1730.36	1729.07	1730.36	2502.0
2013-07-18 02:30:00	ES	Futures	1730.36	1730.88	1729.59	1729.85	1793.0
2013-07-18 03:00:00	ES	Futures	1729.85	1732.17	1729.07	1731.4	11443.0
2013-07-18 03:30:00	ES	Futures	1731.4	1732.17	1729.59	1731.92	6653.0
2013-07-18 04:00:00	ES	Futures	1731.92	1733.72	1731.66	1732.95	10967.0
2013-07-18 04:30:00	ES	Futures	1733.21	1733.72	1732.43	1733.47	4327.0
2013-07-18 05:00:00	ES	Futures	1733.47	1733.98	1732.69	1732.95	3661.0
2013-07-18 05:30:00	ES	Futures	1733.21	1734.76	1732.95	1734.24	4557.0
2013-07-18 06:00:00	ES	Futures	1733.98	1734.76	1733.21	1733.98	4763.0
2013-07-18 06:30:00	ES	Futures	1733.98	1734.24	1733.21	1733.98	4169.0
2013-07-18 07:00:00	ES	Futures	1733.72	1734.76	1733.47	1734.24	5088.0
2013-07-18 07:30:00	ES	Futures	1733.98	1735.02	1733.72	1733.98	8101.0
2013-07-18 08:00:00	ES	Futures	1733.98	1734.76	1733.21	1734.24	8133.0
2013-07-18 08:30:00	ES	Futures	1734.5	1736.83	1733.98	1736.31	26443.0
2013-07-18 09:00:00	ES	Futures	1736.31	1737.09	1735.02	1735.79	22682.0
2013-07-18 09:30:00	ES	Futures	1735.79	1739.41	1734.5	1738.38	128111.0
2013-07-18 10:00:00	ES	Futures	1738.12	1744.32	1737.86	1744.06	157130.0
2013-07-18 10:30:00	ES	Futures	1744.06	1745.87	1742.77	1744.84	114860.0
2013-07-18 11:00:00	ES	Futures	1744.84	1745.62	1743.55	1744.06	88365.0
2013-07-18 11:30:00	ES	Futures	1744.06	1745.36	1742.51	1743.29	75928.0
2013-07-18 12:00:00	ES	Futures	1743.03	1745.36	1742.26	1743.03	78594.0
2013-07-18 12:30:00	ES	Futures	1742.77	1743.29	1740.45	1741.48	54694.0
2013-07-18 13:00:00	ES	Futures	1741.48	1742.26	1739.15	1739.93	52567.0
2013-07-18 13:30:00	ES	Futures	1739.93	1742.26	1739.41	1741.74	59243.0
2013-07-18 14:00:00	ES	Futures	1741.74	1743.03	1741.22	1742.51	40432.0
2013-07-18 14:30:00	ES	Futures	1742.77	1744.32	1742.51	1743.29	41655.0
2013-07-18 15:00:00	ES	Futures	1743.29	1743.29	1740.19	1741.74	53864.0
2013-07-18 15:30:00	ES	Futures	1742.0	1742.26	1739.67	1742.0	108041.0
2013-07-18 16:00:00	ES	Futures	1742.0	1742.26	1735.53	1737.86	119787.0
2013-07-18 16:30:00	ES	Futures	1737.34	1737.6	1736.57	1737.09	8370.0
2013-07-18 17:00:00	ES	Futures	1737.34	1738.12	1737.09	1737.09	4139.0
2013-07-18 18:00:00	ES	Futures	1737.09	1737.6	1736.57	1737.34	4474.0
2013-07-18 18:30:00	ES	Futures	1737.09	1737.34	1736.31	1736.57	1424.0
2013-07-18 19:00:00	ES	Futures	1736.57	1737.09	1736.57	1737.09	531.0
2013-07-18 19:30:00	ES	Futures	1736.83	1737.6	1736.57	1737.09	1321.0
2013-07-18 20:00:00	ES	Futures	1737.09	1737.6	1736.31	1736.31	1480.0
2013-07-18 20:30:00	ES	Futures	1736.31	1737.09	1736.05	1736.05	2115.0
2013-07-18 21:00:00	ES	Futures	1736.31	1736.57	1733.21	1733.72	9321.0
2013-07-18 21:30:00	ES	Futures	1733.98	1734.5	1732.17	1733.72	11631.0
2013-07-18 22:00:00	ES	Futures	1733.72	1735.02	1733.47	1733.98	3848.0
2013-07-18 22:30:00	ES	Futures	1733.98	1734.76	1733.47	1733.72	1504.0
2013-07-18 23:00:00	ES	Futures	1733.98	1734.24	1733.47	1733.98	1226.0
2013-07-18 23:30:00	ES	Futures	1733.98	1734.24	1733.21	1733.72	1675.0
2013-07-18 00:00:00	NQ	Futures	3590.12	3590.7	3589.53	3590.12	180.0
2013-07-18 00:30:00	NQ	Futures	3590.12	3591.29	3589.83	3591.29	132.0
2013-07-18 01:00:00	NQ	Futures	3590.99	3591.29	3589.24	3590.7	175.0

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

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