PREVIEW / futures_30min / 2013-05-31

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-05-31.parquet
  size:    69 KB
  rows:    2,336

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-05-31 00:00:00	ES	Futures	1704.44	1704.69	1704.18	1704.44	1083.0
2013-05-31 00:30:00	ES	Futures	1704.18	1705.98	1703.66	1704.69	3023.0
2013-05-31 01:00:00	ES	Futures	1704.44	1705.21	1704.18	1704.18	2620.0
2013-05-31 01:30:00	ES	Futures	1704.18	1704.69	1703.66	1703.92	3266.0
2013-05-31 02:00:00	ES	Futures	1703.92	1704.69	1702.63	1703.15	8274.0
2013-05-31 02:30:00	ES	Futures	1703.15	1704.18	1703.15	1703.41	2835.0
2013-05-31 03:00:00	ES	Futures	1703.15	1703.15	1696.97	1697.22	23959.0
2013-05-31 03:30:00	ES	Futures	1697.22	1697.48	1693.62	1694.39	24472.0
2013-05-31 04:00:00	ES	Futures	1694.65	1696.45	1693.1	1693.62	14799.0
2013-05-31 04:30:00	ES	Futures	1693.87	1695.16	1692.59	1692.84	12820.0
2013-05-31 05:00:00	ES	Futures	1692.59	1693.1	1691.3	1692.33	13859.0
2013-05-31 05:30:00	ES	Futures	1692.07	1692.33	1690.01	1692.33	17290.0
2013-05-31 06:00:00	ES	Futures	1692.07	1694.39	1690.78	1694.13	14441.0
2013-05-31 06:30:00	ES	Futures	1694.13	1695.68	1693.36	1694.65	12763.0
2013-05-31 07:00:00	ES	Futures	1694.65	1695.94	1694.13	1695.16	12103.0
2013-05-31 07:30:00	ES	Futures	1695.16	1697.22	1694.13	1695.68	19036.0
2013-05-31 08:00:00	ES	Futures	1695.68	1696.45	1693.36	1694.65	15273.0
2013-05-31 08:30:00	ES	Futures	1694.65	1696.97	1694.13	1694.9	21978.0
2013-05-31 09:00:00	ES	Futures	1695.16	1698.51	1694.9	1698.25	30813.0
2013-05-31 09:30:00	ES	Futures	1698.25	1703.92	1695.42	1701.09	261291.0
2013-05-31 10:00:00	ES	Futures	1701.09	1702.89	1696.45	1698.77	174133.0
2013-05-31 10:30:00	ES	Futures	1698.77	1702.89	1698.0	1699.8	131905.0
2013-05-31 11:00:00	ES	Futures	1699.8	1708.3	1699.28	1704.69	201629.0
2013-05-31 11:30:00	ES	Futures	1704.95	1706.24	1703.15	1703.66	106022.0
2013-05-31 12:00:00	ES	Futures	1703.41	1703.66	1699.03	1701.34	109690.0
2013-05-31 12:30:00	ES	Futures	1701.34	1702.37	1700.06	1700.57	58009.0
2013-05-31 13:00:00	ES	Futures	1700.57	1703.41	1700.57	1702.37	58225.0
2013-05-31 13:30:00	ES	Futures	1702.12	1702.37	1698.77	1700.06	74096.0
2013-05-31 14:00:00	ES	Futures	1700.31	1700.57	1696.45	1696.97	84933.0
2013-05-31 14:30:00	ES	Futures	1696.97	1697.22	1690.78	1691.04	170196.0
2013-05-31 15:00:00	ES	Futures	1691.04	1695.68	1690.01	1691.56	146418.0
2013-05-31 15:30:00	ES	Futures	1691.56	1692.07	1677.65	1678.42	415014.0
2013-05-31 16:00:00	ES	Futures	1678.16	1680.22	1675.59	1678.16	251995.0
2013-05-31 16:30:00	ES	Futures	1678.42	1679.19	1676.62	1676.62	17967.0
2013-05-31 17:00:00	ES	Futures	1676.62	1677.39	1676.36	1676.87	4529.0
2013-05-31 00:00:00	NQ	Futures	3513.43	3514.02	3512.85	3512.85	134.0
2013-05-31 00:30:00	NQ	Futures	3512.56	3516.35	3512.56	3513.72	236.0
2013-05-31 01:00:00	NQ	Futures	3513.43	3515.47	3512.56	3512.85	244.0
2013-05-31 01:30:00	NQ	Futures	3512.85	3514.31	3512.27	3513.14	282.0
2013-05-31 02:00:00	NQ	Futures	3513.14	3514.6	3510.52	3511.68	538.0
2013-05-31 02:30:00	NQ	Futures	3511.97	3513.72	3511.68	3511.97	255.0
2013-05-31 03:00:00	NQ	Futures	3511.68	3511.97	3496.81	3497.68	4501.0
2013-05-31 03:30:00	NQ	Futures	3497.39	3497.39	3489.22	3490.97	3507.0
2013-05-31 04:00:00	NQ	Futures	3490.97	3494.47	3488.35	3490.1	1592.0
2013-05-31 04:30:00	NQ	Futures	3490.39	3492.43	3487.77	3488.64	1150.0
2013-05-31 05:00:00	NQ	Futures	3488.35	3488.93	3485.72	3487.18	1411.0
2013-05-31 05:30:00	NQ	Futures	3487.18	3487.77	3483.39	3487.18	1338.0
2013-05-31 06:00:00	NQ	Futures	3486.89	3490.1	3484.56	3489.52	1524.0
2013-05-31 06:30:00	NQ	Futures	3489.52	3493.89	3488.93	3491.85	1717.0
2013-05-31 07:00:00	NQ	Futures	3491.85	3495.06	3491.27	3493.6	1253.0

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

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