PREVIEW / futures_30min / 2013-06-19

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-06-19.parquet
  size:    83 KB
  rows:    2,883

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-19 00:00:00	ES	Futures	1698.05	1699.09	1697.54	1698.83	2962.0
2013-06-19 00:30:00	ES	Futures	1699.09	1699.09	1697.79	1698.05	1488.0
2013-06-19 01:00:00	ES	Futures	1698.05	1700.12	1698.05	1700.12	1754.0
2013-06-19 01:30:00	ES	Futures	1700.12	1701.93	1699.86	1701.93	2722.0
2013-06-19 02:00:00	ES	Futures	1701.93	1704.26	1701.67	1703.22	5514.0
2013-06-19 02:30:00	ES	Futures	1703.22	1704.77	1702.96	1704.0	4213.0
2013-06-19 03:00:00	ES	Futures	1704.0	1704.26	1698.31	1698.57	16725.0
2013-06-19 03:30:00	ES	Futures	1698.31	1700.38	1697.02	1699.86	18412.0
2013-06-19 04:00:00	ES	Futures	1699.6	1702.19	1697.79	1701.41	10482.0
2013-06-19 04:30:00	ES	Futures	1701.41	1704.26	1700.12	1702.71	10998.0
2013-06-19 05:00:00	ES	Futures	1702.71	1704.0	1702.19	1703.74	8187.0
2013-06-19 05:30:00	ES	Futures	1703.74	1705.03	1703.74	1704.26	6841.0
2013-06-19 06:00:00	ES	Futures	1704.51	1704.51	1702.96	1703.48	4234.0
2013-06-19 06:30:00	ES	Futures	1703.48	1703.74	1701.67	1702.19	7209.0
2013-06-19 07:00:00	ES	Futures	1702.19	1702.71	1699.6	1700.38	15712.0
2013-06-19 07:30:00	ES	Futures	1700.38	1700.64	1699.34	1700.38	11281.0
2013-06-19 08:00:00	ES	Futures	1700.64	1702.71	1699.34	1702.19	19603.0
2013-06-19 08:30:00	ES	Futures	1702.19	1702.19	1699.86	1700.64	13050.0
2013-06-19 09:00:00	ES	Futures	1700.9	1701.15	1699.86	1700.38	14118.0
2013-06-19 09:30:00	ES	Futures	1700.38	1702.71	1696.5	1698.31	135640.0
2013-06-19 10:00:00	ES	Futures	1698.31	1702.19	1697.02	1701.41	85234.0
2013-06-19 10:30:00	ES	Futures	1701.41	1702.45	1698.83	1699.86	66973.0
2013-06-19 11:00:00	ES	Futures	1700.12	1701.67	1698.83	1700.12	57388.0
2013-06-19 11:30:00	ES	Futures	1699.86	1701.67	1698.57	1698.83	56381.0
2013-06-19 12:00:00	ES	Futures	1698.83	1699.6	1697.54	1699.34	60844.0
2013-06-19 12:30:00	ES	Futures	1699.34	1700.64	1698.05	1699.09	41608.0
2013-06-19 13:00:00	ES	Futures	1699.09	1700.64	1698.57	1699.34	37490.0
2013-06-19 13:30:00	ES	Futures	1699.34	1702.19	1698.83	1701.93	31182.0
2013-06-19 14:00:00	ES	Futures	1701.93	1703.48	1691.33	1697.02	286530.0
2013-06-19 14:30:00	ES	Futures	1697.02	1701.15	1681.77	1683.58	331919.0
2013-06-19 15:00:00	ES	Futures	1683.32	1691.07	1681.77	1690.04	220758.0
2013-06-19 15:30:00	ES	Futures	1690.04	1690.81	1677.11	1678.15	260832.0
2013-06-19 16:00:00	ES	Futures	1678.15	1682.28	1677.37	1677.89	103144.0
2013-06-19 16:30:00	ES	Futures	1678.41	1678.67	1675.56	1677.11	16034.0
2013-06-19 17:00:00	ES	Futures	1677.11	1677.37	1675.3	1675.56	3343.0
2013-06-19 18:00:00	ES	Futures	1675.82	1677.89	1675.82	1677.63	5559.0
2013-06-19 18:30:00	ES	Futures	1677.37	1678.15	1676.86	1677.63	1623.0
2013-06-19 19:00:00	ES	Futures	1677.63	1677.63	1676.08	1676.08	1385.0
2013-06-19 19:30:00	ES	Futures	1676.34	1676.86	1675.82	1676.34	1742.0
2013-06-19 20:00:00	ES	Futures	1676.6	1677.37	1671.43	1672.2	12556.0
2013-06-19 20:30:00	ES	Futures	1672.2	1675.82	1671.69	1674.79	6723.0
2013-06-19 21:00:00	ES	Futures	1674.79	1675.3	1672.2	1673.24	6041.0
2013-06-19 21:30:00	ES	Futures	1673.24	1673.24	1667.55	1668.84	15668.0
2013-06-19 22:00:00	ES	Futures	1669.1	1670.39	1668.07	1670.13	6016.0
2013-06-19 22:30:00	ES	Futures	1670.13	1672.46	1669.1	1671.43	6418.0
2013-06-19 23:00:00	ES	Futures	1671.43	1672.2	1670.13	1670.65	2827.0
2013-06-19 23:30:00	ES	Futures	1670.65	1671.17	1669.36	1670.13	2653.0
2013-06-19 00:00:00	NQ	Futures	3492.51	3494.26	3491.63	3494.26	173.0
2013-06-19 00:30:00	NQ	Futures	3493.97	3493.97	3491.93	3493.1	194.0
2013-06-19 01:00:00	NQ	Futures	3493.1	3496.02	3492.8	3495.43	124.0

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

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