PREVIEW / futures_30min / 2013-06-18

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-06-18.parquet
  size:    75 KB
  rows:    2,799

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-18 00:00:00	ES	Futures	1689.01	1689.78	1688.75	1689.52	924.0
2013-06-18 00:30:00	ES	Futures	1689.26	1689.52	1688.75	1689.52	509.0
2013-06-18 01:00:00	ES	Futures	1689.26	1689.52	1689.01	1689.26	1058.0
2013-06-18 01:30:00	ES	Futures	1689.52	1691.59	1689.01	1691.59	2107.0
2013-06-18 02:00:00	ES	Futures	1691.33	1691.59	1690.56	1691.33	2473.0
2013-06-18 02:30:00	ES	Futures	1691.59	1691.59	1691.07	1691.07	1553.0
2013-06-18 03:00:00	ES	Futures	1691.07	1691.59	1688.75	1691.59	10217.0
2013-06-18 03:30:00	ES	Futures	1691.59	1693.92	1690.3	1693.4	12997.0
2013-06-18 04:00:00	ES	Futures	1693.4	1694.43	1691.85	1693.14	6329.0
2013-06-18 04:30:00	ES	Futures	1693.4	1693.66	1691.07	1691.85	4154.0
2013-06-18 05:00:00	ES	Futures	1691.85	1693.92	1691.85	1692.88	5752.0
2013-06-18 05:30:00	ES	Futures	1693.14	1695.21	1692.37	1694.43	7349.0
2013-06-18 06:00:00	ES	Futures	1694.17	1694.43	1692.11	1693.14	6198.0
2013-06-18 06:30:00	ES	Futures	1693.4	1693.4	1691.85	1693.4	5773.0
2013-06-18 07:00:00	ES	Futures	1693.14	1693.4	1691.07	1691.33	8319.0
2013-06-18 07:30:00	ES	Futures	1691.33	1691.59	1689.78	1690.81	8137.0
2013-06-18 08:00:00	ES	Futures	1691.07	1693.4	1690.04	1692.62	12282.0
2013-06-18 08:30:00	ES	Futures	1692.62	1693.14	1689.01	1689.78	23909.0
2013-06-18 09:00:00	ES	Futures	1689.78	1690.56	1688.23	1689.26	16657.0
2013-06-18 09:30:00	ES	Futures	1689.52	1693.92	1689.01	1691.59	132288.0
2013-06-18 10:00:00	ES	Futures	1691.59	1695.47	1690.3	1694.69	98561.0
2013-06-18 10:30:00	ES	Futures	1694.69	1698.31	1694.43	1697.79	114354.0
2013-06-18 11:00:00	ES	Futures	1697.79	1699.86	1695.98	1699.6	77388.0
2013-06-18 11:30:00	ES	Futures	1699.6	1701.67	1698.05	1698.31	104874.0
2013-06-18 12:00:00	ES	Futures	1698.31	1699.09	1697.28	1698.31	46531.0
2013-06-18 12:30:00	ES	Futures	1698.05	1702.45	1698.05	1702.19	54908.0
2013-06-18 13:00:00	ES	Futures	1702.19	1702.45	1699.09	1700.12	49424.0
2013-06-18 13:30:00	ES	Futures	1700.12	1702.45	1698.57	1701.41	46386.0
2013-06-18 14:00:00	ES	Futures	1701.67	1704.0	1700.12	1702.71	65197.0
2013-06-18 14:30:00	ES	Futures	1702.45	1704.77	1702.19	1704.0	52724.0
2013-06-18 15:00:00	ES	Futures	1704.0	1704.0	1700.9	1704.0	60250.0
2013-06-18 15:30:00	ES	Futures	1704.0	1704.0	1699.34	1701.93	107162.0
2013-06-18 16:00:00	ES	Futures	1701.93	1702.19	1700.38	1701.67	55060.0
2013-06-18 16:30:00	ES	Futures	1701.93	1703.22	1701.93	1702.45	5598.0
2013-06-18 17:00:00	ES	Futures	1702.45	1703.22	1702.45	1702.71	2044.0
2013-06-18 18:00:00	ES	Futures	1702.45	1703.22	1701.67	1702.45	2253.0
2013-06-18 18:30:00	ES	Futures	1702.19	1702.71	1702.19	1702.45	532.0
2013-06-18 19:00:00	ES	Futures	1702.19	1702.71	1701.93	1702.45	518.0
2013-06-18 19:30:00	ES	Futures	1702.45	1702.71	1701.41	1701.93	855.0
2013-06-18 20:00:00	ES	Futures	1701.93	1701.93	1701.41	1701.41	1427.0
2013-06-18 20:30:00	ES	Futures	1701.67	1702.19	1701.41	1701.67	720.0
2013-06-18 21:00:00	ES	Futures	1701.67	1701.93	1700.64	1701.41	1949.0
2013-06-18 21:30:00	ES	Futures	1701.41	1702.19	1700.9	1701.67	1253.0
2013-06-18 22:00:00	ES	Futures	1701.67	1701.93	1700.12	1700.9	1844.0
2013-06-18 22:30:00	ES	Futures	1700.64	1700.9	1698.05	1698.05	5509.0
2013-06-18 23:00:00	ES	Futures	1698.05	1698.83	1698.05	1698.57	3330.0
2013-06-18 23:30:00	ES	Futures	1698.57	1698.83	1698.05	1698.05	1565.0
2013-06-18 00:00:00	NQ	Futures	3467.96	3469.72	3467.38	3469.42	131.0
2013-06-18 00:30:00	NQ	Futures	3469.13	3470.01	3467.38	3469.72	72.0
2013-06-18 01:00:00	NQ	Futures	3469.13	3469.72	3468.84	3469.72	38.0

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

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