PREVIEW / futures_30min / 2013-07-31

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-07-31.parquet
  size:    78 KB
  rows:    2,841

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-07-31 00:00:00	ES	Futures	1743.55	1743.55	1742.77	1743.29	836.0
2013-07-31 00:30:00	ES	Futures	1743.03	1743.29	1743.03	1743.29	188.0
2013-07-31 01:00:00	ES	Futures	1743.03	1743.29	1742.26	1742.26	964.0
2013-07-31 01:30:00	ES	Futures	1742.26	1743.03	1742.26	1742.26	1023.0
2013-07-31 02:00:00	ES	Futures	1742.26	1742.77	1739.41	1740.45	7180.0
2013-07-31 02:30:00	ES	Futures	1740.45	1740.96	1739.93	1740.96	2749.0
2013-07-31 03:00:00	ES	Futures	1740.96	1741.74	1739.15	1739.93	12870.0
2013-07-31 03:30:00	ES	Futures	1739.93	1742.26	1739.67	1741.74	7532.0
2013-07-31 04:00:00	ES	Futures	1741.74	1744.32	1740.7	1743.81	11269.0
2013-07-31 04:30:00	ES	Futures	1743.55	1745.1	1742.51	1744.58	7388.0
2013-07-31 05:00:00	ES	Futures	1744.58	1744.84	1742.0	1742.77	6986.0
2013-07-31 05:30:00	ES	Futures	1743.03	1743.55	1742.51	1742.77	3483.0
2013-07-31 06:00:00	ES	Futures	1742.51	1744.58	1742.51	1743.81	5142.0
2013-07-31 06:30:00	ES	Futures	1743.81	1744.58	1742.0	1742.51	9513.0
2013-07-31 07:00:00	ES	Futures	1742.51	1743.29	1742.0	1742.51	8431.0
2013-07-31 07:30:00	ES	Futures	1742.77	1742.77	1740.96	1741.22	7069.0
2013-07-31 08:00:00	ES	Futures	1741.48	1742.77	1740.45	1741.48	23161.0
2013-07-31 08:30:00	ES	Futures	1741.48	1744.06	1738.64	1742.26	48336.0
2013-07-31 09:00:00	ES	Futures	1742.26	1743.29	1740.96	1742.51	22426.0
2013-07-31 09:30:00	ES	Futures	1742.51	1745.62	1742.0	1744.06	135391.0
2013-07-31 10:00:00	ES	Futures	1744.06	1747.94	1742.51	1747.42	119146.0
2013-07-31 10:30:00	ES	Futures	1747.68	1750.27	1746.91	1749.49	121459.0
2013-07-31 11:00:00	ES	Futures	1749.49	1750.01	1746.13	1746.39	76687.0
2013-07-31 11:30:00	ES	Futures	1746.39	1747.94	1745.87	1745.87	67347.0
2013-07-31 12:00:00	ES	Futures	1745.87	1746.13	1744.58	1745.1	51915.0
2013-07-31 12:30:00	ES	Futures	1745.1	1745.1	1742.0	1742.26	55173.0
2013-07-31 13:00:00	ES	Futures	1742.26	1743.03	1741.22	1742.0	56878.0
2013-07-31 13:30:00	ES	Futures	1741.74	1743.03	1741.74	1742.77	39051.0
2013-07-31 14:00:00	ES	Futures	1742.51	1747.68	1738.12	1744.32	261218.0
2013-07-31 14:30:00	ES	Futures	1744.58	1751.56	1744.32	1751.56	157849.0
2013-07-31 15:00:00	ES	Futures	1751.56	1751.56	1745.1	1747.42	139695.0
2013-07-31 15:30:00	ES	Futures	1747.42	1747.68	1737.34	1738.89	367081.0
2013-07-31 16:00:00	ES	Futures	1738.89	1743.03	1737.86	1742.26	118020.0
2013-07-31 16:30:00	ES	Futures	1742.51	1743.81	1742.26	1743.03	7636.0
2013-07-31 17:00:00	ES	Futures	1742.77	1743.29	1742.51	1742.51	2324.0
2013-07-31 18:00:00	ES	Futures	1742.77	1743.55	1742.26	1742.77	4085.0
2013-07-31 18:30:00	ES	Futures	1742.77	1743.03	1742.26	1742.51	1211.0
2013-07-31 19:00:00	ES	Futures	1742.51	1743.03	1741.74	1742.77	1671.0
2013-07-31 19:30:00	ES	Futures	1742.77	1743.03	1742.51	1742.77	1138.0
2013-07-31 20:00:00	ES	Futures	1742.77	1743.03	1742.26	1742.51	1880.0
2013-07-31 20:30:00	ES	Futures	1742.51	1745.36	1742.26	1745.1	5802.0
2013-07-31 21:00:00	ES	Futures	1744.84	1746.13	1744.84	1745.62	5356.0
2013-07-31 21:30:00	ES	Futures	1745.36	1746.13	1744.84	1745.87	3978.0
2013-07-31 22:00:00	ES	Futures	1745.87	1746.13	1744.84	1745.1	3539.0
2013-07-31 22:30:00	ES	Futures	1745.1	1745.36	1744.84	1745.36	1177.0
2013-07-31 23:00:00	ES	Futures	1745.36	1745.36	1744.06	1744.84	2040.0
2013-07-31 23:30:00	ES	Futures	1744.84	1746.65	1744.32	1745.87	3801.0
2013-07-31 00:00:00	NQ	Futures	3607.94	3607.94	3606.48	3607.36	144.0
2013-07-31 00:30:00	NQ	Futures	3607.07	3607.94	3606.78	3607.65	41.0
2013-07-31 01:00:00	NQ	Futures	3607.94	3607.94	3605.61	3605.61	165.0

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

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