PREVIEW / futures_30min / 2013-08-22

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-08-22.parquet
  size:    76 KB
  rows:    2,790

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-08-22 00:00:00	ES	Futures	1689.52	1690.04	1689.01	1689.26	911.0
2013-08-22 00:30:00	ES	Futures	1689.52	1690.81	1689.52	1690.56	1506.0
2013-08-22 01:00:00	ES	Futures	1690.81	1690.81	1689.01	1689.01	1778.0
2013-08-22 01:30:00	ES	Futures	1689.26	1690.04	1688.75	1690.04	1945.0
2013-08-22 02:00:00	ES	Futures	1690.04	1692.11	1689.78	1691.85	5942.0
2013-08-22 02:30:00	ES	Futures	1691.85	1693.66	1691.85	1692.88	6394.0
2013-08-22 03:00:00	ES	Futures	1692.88	1696.24	1692.88	1695.98	22714.0
2013-08-22 03:30:00	ES	Futures	1695.98	1699.6	1695.73	1699.09	24316.0
2013-08-22 04:00:00	ES	Futures	1699.09	1700.64	1698.83	1699.34	15583.0
2013-08-22 04:30:00	ES	Futures	1699.34	1700.12	1698.83	1700.12	8998.0
2013-08-22 05:00:00	ES	Futures	1700.12	1700.38	1699.09	1699.86	6442.0
2013-08-22 05:30:00	ES	Futures	1699.86	1701.15	1698.05	1698.57	11238.0
2013-08-22 06:00:00	ES	Futures	1698.57	1699.86	1698.05	1699.09	7588.0
2013-08-22 06:30:00	ES	Futures	1699.09	1699.09	1697.79	1698.57	6782.0
2013-08-22 07:00:00	ES	Futures	1698.31	1699.86	1698.05	1699.34	10969.0
2013-08-22 07:30:00	ES	Futures	1699.6	1699.6	1696.5	1696.76	15319.0
2013-08-22 08:00:00	ES	Futures	1696.76	1699.09	1696.5	1697.79	14423.0
2013-08-22 08:30:00	ES	Futures	1698.05	1701.93	1697.54	1700.38	32676.0
2013-08-22 09:00:00	ES	Futures	1700.38	1700.9	1698.83	1699.34	23317.0
2013-08-22 09:30:00	ES	Futures	1699.6	1705.55	1699.09	1704.51	202336.0
2013-08-22 10:00:00	ES	Futures	1704.51	1707.88	1703.22	1707.88	158193.0
2013-08-22 10:30:00	ES	Futures	1707.88	1710.46	1707.1	1708.13	136660.0
2013-08-22 11:00:00	ES	Futures	1708.13	1709.17	1704.77	1705.29	108982.0
2013-08-22 11:30:00	ES	Futures	1705.29	1707.62	1705.03	1707.36	75676.0
2013-08-22 12:00:00	ES	Futures	1707.36	1708.91	1706.32	1706.58	48706.0
2013-08-22 12:30:00	ES	Futures	1706.58	1708.65	1703.48	1704.51	66448.0
2013-08-22 13:00:00	ES	Futures	1704.51	1707.88	1704.0	1706.58	55075.0
2013-08-22 13:30:00	ES	Futures	1706.84	1709.43	1706.07	1708.91	35288.0
2013-08-22 14:00:00	ES	Futures	1708.65	1709.94	1707.88	1709.43	39319.0
2013-08-22 14:30:00	ES	Futures	1709.43	1710.98	1708.65	1708.65	41410.0
2013-08-22 15:00:00	ES	Futures	1708.65	1712.27	1707.88	1711.75	72952.0
2013-08-22 15:30:00	ES	Futures	1711.75	1714.08	1710.2	1710.72	135175.0
2013-08-22 16:00:00	ES	Futures	1710.46	1713.05	1710.46	1711.24	85299.0
2013-08-22 16:30:00	ES	Futures	1711.24	1712.01	1710.98	1712.01	5709.0
2013-08-22 17:00:00	ES	Futures	1711.75	1712.27	1711.75	1711.75	1584.0
2013-08-22 18:00:00	ES	Futures	1711.75	1712.01	1710.72	1711.75	2022.0
2013-08-22 18:30:00	ES	Futures	1712.01	1712.79	1711.75	1712.53	1755.0
2013-08-22 19:00:00	ES	Futures	1712.53	1713.56	1712.27	1713.3	1790.0
2013-08-22 19:30:00	ES	Futures	1713.3	1713.3	1712.27	1712.79	1057.0
2013-08-22 20:00:00	ES	Futures	1712.79	1713.05	1711.24	1711.75	2358.0
2013-08-22 20:30:00	ES	Futures	1711.49	1712.53	1711.24	1712.27	1290.0
2013-08-22 21:00:00	ES	Futures	1712.27	1713.56	1712.27	1713.56	3258.0
2013-08-22 21:30:00	ES	Futures	1713.56	1714.34	1713.3	1713.82	3811.0
2013-08-22 22:00:00	ES	Futures	1714.08	1714.08	1712.79	1713.05	1701.0
2013-08-22 22:30:00	ES	Futures	1713.05	1714.34	1713.05	1713.56	2226.0
2013-08-22 23:00:00	ES	Futures	1713.56	1714.08	1713.56	1713.56	1185.0
2013-08-22 23:30:00	ES	Futures	1713.82	1714.08	1713.05	1713.3	1180.0
2013-08-22 00:00:00	NQ	Futures	3577.26	3579.01	3576.97	3577.84	246.0
2013-08-22 00:30:00	NQ	Futures	3577.84	3580.18	3577.55	3579.89	94.0
2013-08-22 01:00:00	NQ	Futures	3580.47	3580.47	3577.26	3577.26	163.0

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

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