PREVIEW / futures_30min / 2013-07-23

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-07-23.parquet
  size:    75 KB
  rows:    2,845

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-23 00:00:00	ES	Futures	1752.34	1753.11	1751.82	1751.82	4135.0
2013-07-23 00:30:00	ES	Futures	1751.82	1752.59	1751.82	1752.34	1079.0
2013-07-23 01:00:00	ES	Futures	1752.34	1752.85	1752.08	1752.59	1289.0
2013-07-23 01:30:00	ES	Futures	1752.85	1752.85	1751.56	1752.08	2636.0
2013-07-23 02:00:00	ES	Futures	1752.08	1752.59	1751.56	1752.59	2532.0
2013-07-23 02:30:00	ES	Futures	1752.34	1752.85	1752.08	1752.08	2349.0
2013-07-23 03:00:00	ES	Futures	1752.34	1752.85	1751.3	1752.08	8641.0
2013-07-23 03:30:00	ES	Futures	1752.08	1752.59	1749.23	1749.75	9687.0
2013-07-23 04:00:00	ES	Futures	1750.01	1750.53	1749.75	1750.01	5346.0
2013-07-23 04:30:00	ES	Futures	1750.01	1751.3	1749.49	1751.04	6776.0
2013-07-23 05:00:00	ES	Futures	1750.79	1751.3	1749.75	1751.3	6837.0
2013-07-23 05:30:00	ES	Futures	1751.3	1751.56	1750.53	1751.3	4685.0
2013-07-23 06:00:00	ES	Futures	1751.04	1751.56	1750.27	1750.53	4269.0
2013-07-23 06:30:00	ES	Futures	1750.53	1752.08	1750.27	1751.56	6797.0
2013-07-23 07:00:00	ES	Futures	1751.56	1751.82	1749.49	1749.75	7032.0
2013-07-23 07:30:00	ES	Futures	1749.49	1751.3	1749.23	1751.04	9191.0
2013-07-23 08:00:00	ES	Futures	1751.04	1751.3	1749.75	1750.01	5334.0
2013-07-23 08:30:00	ES	Futures	1750.01	1751.04	1749.75	1750.27	9982.0
2013-07-23 09:00:00	ES	Futures	1750.27	1752.08	1749.23	1751.04	19808.0
2013-07-23 09:30:00	ES	Futures	1751.04	1751.56	1748.46	1749.49	114678.0
2013-07-23 10:00:00	ES	Futures	1749.49	1749.75	1745.87	1746.39	108066.0
2013-07-23 10:30:00	ES	Futures	1746.39	1746.65	1744.06	1744.58	81450.0
2013-07-23 11:00:00	ES	Futures	1744.32	1746.39	1743.29	1745.87	78210.0
2013-07-23 11:30:00	ES	Futures	1745.87	1747.17	1744.84	1745.87	50791.0
2013-07-23 12:00:00	ES	Futures	1746.13	1746.91	1744.58	1746.39	30273.0
2013-07-23 12:30:00	ES	Futures	1746.13	1746.39	1744.84	1745.62	23857.0
2013-07-23 13:00:00	ES	Futures	1745.62	1748.2	1745.36	1747.68	34917.0
2013-07-23 13:30:00	ES	Futures	1747.68	1748.46	1746.39	1746.91	29530.0
2013-07-23 14:00:00	ES	Futures	1746.65	1747.68	1746.39	1747.17	24127.0
2013-07-23 14:30:00	ES	Futures	1747.17	1749.23	1746.65	1748.72	37741.0
2013-07-23 15:00:00	ES	Futures	1748.72	1748.72	1746.91	1747.42	26537.0
2013-07-23 15:30:00	ES	Futures	1747.68	1747.94	1743.81	1745.36	118392.0
2013-07-23 16:00:00	ES	Futures	1745.62	1746.65	1744.32	1745.36	54225.0
2013-07-23 16:30:00	ES	Futures	1745.62	1748.72	1745.1	1747.68	17418.0
2013-07-23 17:00:00	ES	Futures	1747.68	1747.94	1746.39	1747.17	2597.0
2013-07-23 18:00:00	ES	Futures	1746.91	1747.17	1744.84	1745.62	3569.0
2013-07-23 18:30:00	ES	Futures	1745.87	1746.65	1745.62	1746.39	687.0
2013-07-23 19:00:00	ES	Futures	1746.39	1746.91	1746.13	1746.91	424.0
2013-07-23 19:30:00	ES	Futures	1746.91	1747.17	1746.65	1746.65	578.0
2013-07-23 20:00:00	ES	Futures	1746.65	1746.91	1746.13	1746.39	1199.0
2013-07-23 20:30:00	ES	Futures	1746.39	1746.91	1744.58	1744.84	3474.0
2013-07-23 21:00:00	ES	Futures	1744.58	1745.87	1744.58	1745.87	1541.0
2013-07-23 21:30:00	ES	Futures	1745.62	1746.13	1744.32	1745.1	4772.0
2013-07-23 22:00:00	ES	Futures	1744.84	1745.36	1744.32	1744.58	1963.0
2013-07-23 22:30:00	ES	Futures	1744.84	1745.36	1744.58	1744.84	469.0
2013-07-23 23:00:00	ES	Futures	1744.84	1745.62	1744.32	1745.36	983.0
2013-07-23 23:30:00	ES	Futures	1745.62	1746.13	1745.36	1746.13	1100.0
2013-07-23 00:00:00	NQ	Futures	3574.92	3576.97	3574.92	3574.92	372.0
2013-07-23 00:30:00	NQ	Futures	3574.92	3576.38	3574.63	3575.21	110.0
2013-07-23 01:00:00	NQ	Futures	3575.51	3576.67	3574.92	3576.38	124.0

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

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