PREVIEW / futures_30min / 2013-07-19

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-07-19.parquet
  size:    63 KB
  rows:    2,279

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-19 00:00:00	ES	Futures	1733.72	1733.98	1733.21	1733.47	845.0
2013-07-19 00:30:00	ES	Futures	1733.47	1733.72	1733.21	1733.72	723.0
2013-07-19 01:00:00	ES	Futures	1733.72	1734.24	1732.95	1733.21	1299.0
2013-07-19 01:30:00	ES	Futures	1733.21	1734.24	1732.43	1733.98	2125.0
2013-07-19 02:00:00	ES	Futures	1733.98	1735.02	1733.72	1734.24	4012.0
2013-07-19 02:30:00	ES	Futures	1733.98	1735.28	1733.98	1735.28	1815.0
2013-07-19 03:00:00	ES	Futures	1735.02	1736.57	1734.24	1735.53	13376.0
2013-07-19 03:30:00	ES	Futures	1735.79	1736.05	1734.5	1735.28	6489.0
2013-07-19 04:00:00	ES	Futures	1735.02	1736.05	1734.76	1734.76	4682.0
2013-07-19 04:30:00	ES	Futures	1734.76	1735.28	1734.24	1734.76	4082.0
2013-07-19 05:00:00	ES	Futures	1734.76	1735.28	1733.98	1735.28	5762.0
2013-07-19 05:30:00	ES	Futures	1735.02	1736.57	1734.5	1736.31	7331.0
2013-07-19 06:00:00	ES	Futures	1736.05	1736.57	1735.79	1736.31	3453.0
2013-07-19 06:30:00	ES	Futures	1736.05	1736.83	1735.53	1736.05	7183.0
2013-07-19 07:00:00	ES	Futures	1736.05	1739.41	1735.79	1738.12	22444.0
2013-07-19 07:30:00	ES	Futures	1738.12	1739.15	1737.6	1737.86	9149.0
2013-07-19 08:00:00	ES	Futures	1738.12	1738.38	1736.57	1737.09	16154.0
2013-07-19 08:30:00	ES	Futures	1737.09	1737.6	1735.53	1736.05	21938.0
2013-07-19 09:00:00	ES	Futures	1736.31	1737.86	1733.98	1737.86	48948.0
2013-07-19 09:30:00	ES	Futures	1737.86	1739.41	1735.53	1737.34	188529.0
2013-07-19 10:00:00	ES	Futures	1737.34	1739.67	1736.31	1737.86	84490.0
2013-07-19 10:30:00	ES	Futures	1738.12	1740.96	1737.6	1740.19	78570.0
2013-07-19 11:00:00	ES	Futures	1739.93	1742.0	1738.89	1741.74	77929.0
2013-07-19 11:30:00	ES	Futures	1741.48	1741.74	1738.64	1739.67	61055.0
2013-07-19 12:00:00	ES	Futures	1739.93	1740.96	1739.15	1739.93	39152.0
2013-07-19 12:30:00	ES	Futures	1739.67	1740.19	1738.89	1740.19	21287.0
2013-07-19 13:00:00	ES	Futures	1740.19	1741.22	1739.41	1739.67	31293.0
2013-07-19 13:30:00	ES	Futures	1739.67	1741.48	1739.15	1741.22	25447.0
2013-07-19 14:00:00	ES	Futures	1740.96	1743.55	1740.7	1743.03	51797.0
2013-07-19 14:30:00	ES	Futures	1743.03	1743.03	1741.48	1742.0	31400.0
2013-07-19 15:00:00	ES	Futures	1742.26	1743.03	1741.74	1742.26	41562.0
2013-07-19 15:30:00	ES	Futures	1742.26	1744.84	1742.26	1744.84	103019.0
2013-07-19 16:00:00	ES	Futures	1744.84	1747.94	1744.58	1747.42	76964.0
2013-07-19 16:30:00	ES	Futures	1747.17	1747.68	1746.91	1747.17	6732.0
2013-07-19 17:00:00	ES	Futures	1747.17	1747.68	1747.17	1747.17	2740.0
2013-07-19 00:00:00	NQ	Futures	3560.89	3561.77	3560.31	3560.89	181.0
2013-07-19 00:30:00	NQ	Futures	3560.89	3561.48	3559.43	3560.02	200.0
2013-07-19 01:00:00	NQ	Futures	3560.02	3560.89	3557.68	3557.68	347.0
2013-07-19 01:30:00	NQ	Futures	3557.68	3558.26	3556.51	3558.26	581.0
2013-07-19 02:00:00	NQ	Futures	3558.26	3559.73	3557.97	3558.26	722.0
2013-07-19 02:30:00	NQ	Futures	3558.85	3560.89	3558.56	3559.14	721.0
2013-07-19 03:00:00	NQ	Futures	3559.14	3560.02	3556.22	3556.8	3881.0
2013-07-19 03:30:00	NQ	Futures	3556.8	3557.09	3555.05	3555.63	1795.0
2013-07-19 04:00:00	NQ	Futures	3555.63	3559.43	3555.63	3557.39	1429.0
2013-07-19 04:30:00	NQ	Futures	3557.09	3557.97	3554.17	3554.76	1266.0
2013-07-19 05:00:00	NQ	Futures	3554.46	3554.46	3552.42	3554.17	1718.0
2013-07-19 05:30:00	NQ	Futures	3554.46	3555.93	3552.13	3555.05	2021.0
2013-07-19 06:00:00	NQ	Futures	3555.05	3555.63	3553.59	3554.46	852.0
2013-07-19 06:30:00	NQ	Futures	3554.46	3556.22	3553.59	3555.34	1123.0
2013-07-19 07:00:00	NQ	Futures	3555.34	3562.06	3555.05	3560.6	3126.0

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

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