PREVIEW / futures_30min / 2013-05-20

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-05-20.parquet
  size:    73 KB
  rows:    2,748

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-05-20 00:00:00	ES	Futures	1713.71	1714.48	1713.45	1714.22	1533.0
2013-05-20 00:30:00	ES	Futures	1713.97	1714.22	1713.71	1713.97	481.0
2013-05-20 01:00:00	ES	Futures	1713.97	1714.22	1713.45	1713.71	889.0
2013-05-20 01:30:00	ES	Futures	1713.97	1714.22	1712.94	1712.94	1228.0
2013-05-20 02:00:00	ES	Futures	1713.19	1714.22	1712.94	1713.71	3061.0
2013-05-20 02:30:00	ES	Futures	1713.71	1713.71	1712.16	1712.68	3409.0
2013-05-20 03:00:00	ES	Futures	1712.42	1713.71	1712.16	1712.42	7871.0
2013-05-20 03:30:00	ES	Futures	1712.42	1712.68	1711.91	1711.91	6582.0
2013-05-20 04:00:00	ES	Futures	1712.16	1713.19	1711.91	1712.94	4832.0
2013-05-20 04:30:00	ES	Futures	1712.94	1713.45	1712.42	1712.94	2734.0
2013-05-20 05:00:00	ES	Futures	1713.19	1713.45	1711.91	1712.16	4465.0
2013-05-20 05:30:00	ES	Futures	1712.16	1713.71	1712.16	1713.19	5949.0
2013-05-20 06:00:00	ES	Futures	1713.19	1713.97	1712.68	1712.94	4695.0
2013-05-20 06:30:00	ES	Futures	1712.94	1713.45	1712.42	1713.19	7578.0
2013-05-20 07:00:00	ES	Futures	1713.19	1713.71	1712.42	1712.68	7477.0
2013-05-20 07:30:00	ES	Futures	1712.68	1712.94	1711.91	1712.68	8465.0
2013-05-20 08:00:00	ES	Futures	1712.68	1713.45	1710.88	1710.88	15361.0
2013-05-20 08:30:00	ES	Futures	1710.88	1711.65	1710.1	1710.62	37087.0
2013-05-20 09:00:00	ES	Futures	1710.88	1713.45	1710.36	1713.19	29332.0
2013-05-20 09:30:00	ES	Futures	1713.19	1716.54	1712.68	1715.25	240233.0
2013-05-20 10:00:00	ES	Futures	1715.0	1717.31	1714.74	1715.77	154393.0
2013-05-20 10:30:00	ES	Futures	1716.03	1717.31	1715.51	1716.54	134616.0
2013-05-20 11:00:00	ES	Futures	1716.54	1718.86	1716.28	1718.86	91072.0
2013-05-20 11:30:00	ES	Futures	1718.86	1720.92	1718.35	1720.41	137207.0
2013-05-20 12:00:00	ES	Futures	1720.41	1721.44	1719.12	1719.89	78698.0
2013-05-20 12:30:00	ES	Futures	1719.63	1719.89	1717.31	1717.83	83823.0
2013-05-20 13:00:00	ES	Futures	1718.09	1718.6	1714.22	1715.0	98537.0
2013-05-20 13:30:00	ES	Futures	1715.0	1716.03	1712.42	1714.74	94545.0
2013-05-20 14:00:00	ES	Futures	1714.74	1716.03	1711.39	1715.77	90433.0
2013-05-20 14:30:00	ES	Futures	1715.77	1716.54	1713.97	1714.74	73933.0
2013-05-20 15:00:00	ES	Futures	1714.74	1716.28	1713.97	1715.77	65819.0
2013-05-20 15:30:00	ES	Futures	1715.77	1716.28	1712.94	1714.74	133310.0
2013-05-20 16:00:00	ES	Futures	1714.74	1715.51	1714.22	1715.0	58035.0
2013-05-20 16:30:00	ES	Futures	1715.0	1715.25	1714.48	1714.48	4803.0
2013-05-20 17:00:00	ES	Futures	1714.74	1714.74	1714.48	1714.48	1196.0
2013-05-20 18:00:00	ES	Futures	1713.97	1714.74	1713.71	1714.22	2398.0
2013-05-20 18:30:00	ES	Futures	1713.97	1714.48	1713.71	1713.71	838.0
2013-05-20 19:00:00	ES	Futures	1713.97	1714.48	1713.45	1713.97	1905.0
2013-05-20 19:30:00	ES	Futures	1713.97	1714.48	1713.97	1714.48	1284.0
2013-05-20 20:00:00	ES	Futures	1714.48	1714.48	1713.45	1713.45	1736.0
2013-05-20 20:30:00	ES	Futures	1713.45	1713.71	1712.94	1713.45	2282.0
2013-05-20 21:00:00	ES	Futures	1713.45	1713.97	1713.19	1713.45	1666.0
2013-05-20 21:30:00	ES	Futures	1713.19	1713.97	1713.19	1713.97	1363.0
2013-05-20 22:00:00	ES	Futures	1713.71	1714.48	1713.71	1714.48	1159.0
2013-05-20 22:30:00	ES	Futures	1714.48	1714.48	1713.45	1713.71	978.0
2013-05-20 23:00:00	ES	Futures	1713.71	1713.97	1713.45	1713.71	1095.0
2013-05-20 23:30:00	ES	Futures	1713.97	1714.22	1713.19	1713.97	1410.0
2013-05-20 00:00:00	NQ	Futures	3525.39	3527.14	3525.39	3525.97	199.0
2013-05-20 00:30:00	NQ	Futures	3525.97	3527.14	3525.68	3526.27	165.0
2013-05-20 01:00:00	NQ	Futures	3526.27	3526.56	3525.39	3525.39	360.0

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

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