PREVIEW / futures_30min / 2013-06-11

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-06-11.parquet
  size:    77 KB
  rows:    2,723

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-06-11 00:00:00	ES	Futures	1688.98	1690.27	1688.98	1689.75	1804.0
2013-06-11 00:30:00	ES	Futures	1689.75	1690.01	1688.47	1689.24	2065.0
2013-06-11 01:00:00	ES	Futures	1689.24	1689.75	1688.47	1689.5	1396.0
2013-06-11 01:30:00	ES	Futures	1689.24	1690.27	1688.72	1688.72	2501.0
2013-06-11 02:00:00	ES	Futures	1688.72	1691.04	1688.72	1689.75	4670.0
2013-06-11 02:30:00	ES	Futures	1689.75	1690.27	1689.5	1689.75	2991.0
2013-06-11 03:00:00	ES	Futures	1689.24	1689.24	1685.12	1686.66	24923.0
2013-06-11 03:30:00	ES	Futures	1686.4	1688.21	1685.63	1686.92	11406.0
2013-06-11 04:00:00	ES	Futures	1686.92	1687.69	1685.37	1685.89	7227.0
2013-06-11 04:30:00	ES	Futures	1685.89	1686.4	1685.12	1685.89	8160.0
2013-06-11 05:00:00	ES	Futures	1685.89	1686.4	1682.54	1683.31	19552.0
2013-06-11 05:30:00	ES	Futures	1683.06	1683.57	1676.87	1678.68	39037.0
2013-06-11 06:00:00	ES	Futures	1678.42	1679.45	1676.87	1679.19	20396.0
2013-06-11 06:30:00	ES	Futures	1678.93	1679.45	1676.36	1677.39	20427.0
2013-06-11 07:00:00	ES	Futures	1677.13	1677.9	1674.81	1676.1	29098.0
2013-06-11 07:30:00	ES	Futures	1676.1	1679.19	1675.33	1676.36	37281.0
2013-06-11 08:00:00	ES	Futures	1676.36	1677.65	1674.81	1675.33	29204.0
2013-06-11 08:30:00	ES	Futures	1675.33	1678.16	1674.3	1677.39	30444.0
2013-06-11 09:00:00	ES	Futures	1677.39	1677.9	1674.81	1676.36	39003.0
2013-06-11 09:30:00	ES	Futures	1676.36	1677.65	1670.69	1676.1	383728.0
2013-06-11 10:00:00	ES	Futures	1676.36	1679.19	1673.27	1678.16	243288.0
2013-06-11 10:30:00	ES	Futures	1678.16	1683.31	1677.9	1681.51	161208.0
2013-06-11 11:00:00	ES	Futures	1681.51	1687.43	1679.97	1686.92	189957.0
2013-06-11 11:30:00	ES	Futures	1687.18	1689.5	1685.89	1686.4	151196.0
2013-06-11 12:00:00	ES	Futures	1686.4	1688.21	1684.86	1685.63	79634.0
2013-06-11 12:30:00	ES	Futures	1685.89	1686.92	1684.34	1685.12	64730.0
2013-06-11 13:00:00	ES	Futures	1685.12	1686.4	1680.48	1680.74	89854.0
2013-06-11 13:30:00	ES	Futures	1681.0	1681.0	1675.84	1675.84	154540.0
2013-06-11 14:00:00	ES	Futures	1676.1	1680.74	1674.81	1680.74	103793.0
2013-06-11 14:30:00	ES	Futures	1680.74	1682.28	1677.39	1682.28	93791.0
2013-06-11 15:00:00	ES	Futures	1682.28	1683.31	1678.93	1678.93	92455.0
2013-06-11 15:30:00	ES	Futures	1679.19	1679.45	1673.78	1674.81	183229.0
2013-06-11 16:00:00	ES	Futures	1674.81	1677.39	1674.81	1676.87	75397.0
2013-06-11 16:30:00	ES	Futures	1677.13	1677.65	1676.87	1677.39	8021.0
2013-06-11 17:00:00	ES	Futures	1677.39	1677.9	1676.87	1677.13	2047.0
2013-06-11 18:00:00	ES	Futures	1676.87	1677.65	1676.36	1676.36	3102.0
2013-06-11 18:30:00	ES	Futures	1676.62	1676.62	1675.59	1676.36	1675.0
2013-06-11 19:00:00	ES	Futures	1676.36	1677.13	1676.1	1676.62	830.0
2013-06-11 19:30:00	ES	Futures	1676.62	1677.65	1676.36	1677.65	843.0
2013-06-11 20:00:00	ES	Futures	1677.65	1679.19	1677.13	1678.68	3095.0
2013-06-11 20:30:00	ES	Futures	1678.68	1678.93	1677.65	1677.65	1814.0
2013-06-11 21:00:00	ES	Futures	1677.9	1679.19	1676.62	1678.93	3381.0
2013-06-11 21:30:00	ES	Futures	1678.93	1679.45	1677.65	1678.16	2703.0
2013-06-11 22:00:00	ES	Futures	1678.42	1679.19	1677.9	1678.42	1095.0
2013-06-11 22:30:00	ES	Futures	1678.42	1679.19	1677.9	1678.42	854.0
2013-06-11 23:00:00	ES	Futures	1678.16	1678.68	1678.16	1678.42	353.0
2013-06-11 23:30:00	ES	Futures	1678.68	1679.19	1677.9	1678.93	1351.0
2013-06-11 00:00:00	NQ	Futures	3480.77	3483.39	3480.47	3483.1	281.0
2013-06-11 00:30:00	NQ	Futures	3482.81	3483.1	3481.06	3482.81	309.0
2013-06-11 01:00:00	NQ	Futures	3482.81	3483.1	3481.35	3481.64	246.0

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

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