PREVIEW / futures_30min / 2013-07-03

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-07-03.parquet
  size:    74 KB
  rows:    2,612

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-03 00:00:00	ES	Futures	1659.8	1660.05	1658.5	1658.76	1336.0
2013-07-03 00:30:00	ES	Futures	1659.02	1660.05	1657.99	1660.05	1568.0
2013-07-03 01:00:00	ES	Futures	1659.8	1661.09	1659.28	1659.54	2380.0
2013-07-03 01:30:00	ES	Futures	1659.54	1659.8	1658.24	1658.5	2399.0
2013-07-03 02:00:00	ES	Futures	1658.5	1660.05	1656.69	1656.95	7371.0
2013-07-03 02:30:00	ES	Futures	1656.95	1657.47	1654.88	1656.18	8786.0
2013-07-03 03:00:00	ES	Futures	1655.92	1656.43	1651.52	1652.04	26139.0
2013-07-03 03:30:00	ES	Futures	1652.04	1653.59	1648.42	1648.68	25015.0
2013-07-03 04:00:00	ES	Futures	1648.94	1651.78	1648.16	1651.52	18419.0
2013-07-03 04:30:00	ES	Futures	1651.78	1652.82	1649.46	1651.78	13315.0
2013-07-03 05:00:00	ES	Futures	1651.78	1654.37	1651.26	1652.04	11485.0
2013-07-03 05:30:00	ES	Futures	1652.04	1653.33	1650.49	1653.07	8493.0
2013-07-03 06:00:00	ES	Futures	1653.07	1653.59	1651.52	1652.56	6532.0
2013-07-03 06:30:00	ES	Futures	1652.82	1654.37	1651.26	1651.78	13099.0
2013-07-03 07:00:00	ES	Futures	1651.78	1654.11	1651.52	1653.85	13296.0
2013-07-03 07:30:00	ES	Futures	1653.85	1654.37	1652.3	1653.59	10664.0
2013-07-03 08:00:00	ES	Futures	1653.85	1657.47	1651.26	1656.69	31926.0
2013-07-03 08:30:00	ES	Futures	1656.95	1659.8	1654.88	1656.18	36722.0
2013-07-03 09:00:00	ES	Futures	1656.18	1656.95	1652.82	1654.37	29020.0
2013-07-03 09:30:00	ES	Futures	1654.37	1658.76	1651.52	1655.66	144545.0
2013-07-03 10:00:00	ES	Futures	1655.92	1658.76	1652.56	1658.24	113234.0
2013-07-03 10:30:00	ES	Futures	1658.5	1659.02	1655.92	1656.69	77094.0
2013-07-03 11:00:00	ES	Futures	1656.95	1661.86	1656.69	1660.57	83805.0
2013-07-03 11:30:00	ES	Futures	1660.57	1666.0	1659.8	1665.74	88988.0
2013-07-03 12:00:00	ES	Futures	1665.74	1667.81	1664.97	1666.77	72401.0
2013-07-03 12:30:00	ES	Futures	1667.03	1667.29	1662.9	1663.16	93877.0
2013-07-03 13:00:00	ES	Futures	1663.16	1664.97	1662.64	1664.71	54012.0
2013-07-03 18:00:00	ES	Futures	1663.67	1664.71	1663.16	1663.93	1041.0
2013-07-03 18:30:00	ES	Futures	1664.19	1664.45	1663.67	1664.45	413.0
2013-07-03 19:00:00	ES	Futures	1664.45	1665.22	1664.45	1665.22	652.0
2013-07-03 19:30:00	ES	Futures	1665.22	1665.22	1664.71	1664.97	697.0
2013-07-03 20:00:00	ES	Futures	1664.71	1665.74	1664.45	1665.48	1601.0
2013-07-03 20:30:00	ES	Futures	1665.48	1665.74	1664.19	1664.45	1235.0
2013-07-03 21:00:00	ES	Futures	1664.45	1665.48	1664.19	1664.97	798.0
2013-07-03 21:30:00	ES	Futures	1665.22	1665.22	1663.67	1664.45	1156.0
2013-07-03 22:00:00	ES	Futures	1664.19	1664.71	1663.93	1664.45	857.0
2013-07-03 22:30:00	ES	Futures	1664.45	1665.22	1664.19	1665.22	455.0
2013-07-03 23:00:00	ES	Futures	1665.22	1665.74	1664.71	1665.74	1703.0
2013-07-03 23:30:00	ES	Futures	1665.74	1665.74	1665.22	1665.48	969.0
2013-07-03 00:00:00	NQ	Futures	3411.85	3412.44	3409.52	3409.52	157.0
2013-07-03 00:30:00	NQ	Futures	3410.39	3410.98	3408.05	3410.98	106.0
2013-07-03 01:00:00	NQ	Futures	3411.85	3414.19	3410.39	3411.27	203.0
2013-07-03 01:30:00	NQ	Futures	3410.98	3411.56	3409.81	3409.81	242.0
2013-07-03 02:00:00	NQ	Futures	3410.1	3413.31	3406.01	3407.76	533.0
2013-07-03 02:30:00	NQ	Futures	3407.18	3407.76	3403.67	3403.96	643.0
2013-07-03 03:00:00	NQ	Futures	3403.96	3404.55	3391.4	3392.27	4443.0
2013-07-03 03:30:00	NQ	Futures	3392.27	3398.12	3387.01	3387.89	3618.0
2013-07-03 04:00:00	NQ	Futures	3387.6	3394.32	3386.43	3394.32	1843.0
2013-07-03 04:30:00	NQ	Futures	3393.74	3395.49	3388.77	3393.15	1450.0
2013-07-03 05:00:00	NQ	Futures	3393.44	3400.16	3391.98	3394.9	2162.0

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

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