PREVIEW / futures_30min / 2013-08-09

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-08-09.parquet
  size:    65 KB
  rows:    2,313

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-09 00:00:00	ES	Futures	1750.27	1750.53	1749.49	1749.75	1295.0
2013-08-09 00:30:00	ES	Futures	1750.01	1750.53	1749.75	1750.01	600.0
2013-08-09 01:00:00	ES	Futures	1750.01	1751.04	1749.75	1750.79	1009.0
2013-08-09 01:30:00	ES	Futures	1750.79	1751.82	1750.53	1751.04	3398.0
2013-08-09 02:00:00	ES	Futures	1751.3	1752.34	1751.3	1751.82	2413.0
2013-08-09 02:30:00	ES	Futures	1751.82	1752.34	1751.56	1751.56	1822.0
2013-08-09 03:00:00	ES	Futures	1751.82	1752.08	1747.94	1748.46	9875.0
2013-08-09 03:30:00	ES	Futures	1748.46	1749.49	1747.94	1749.23	6469.0
2013-08-09 04:00:00	ES	Futures	1749.23	1749.49	1746.65	1746.65	8758.0
2013-08-09 04:30:00	ES	Futures	1746.65	1747.17	1745.87	1746.65	7399.0
2013-08-09 05:00:00	ES	Futures	1746.91	1747.94	1746.39	1746.91	6306.0
2013-08-09 05:30:00	ES	Futures	1746.91	1747.17	1745.62	1745.62	4675.0
2013-08-09 06:00:00	ES	Futures	1745.62	1745.87	1743.55	1744.84	14480.0
2013-08-09 06:30:00	ES	Futures	1744.84	1745.62	1743.81	1745.36	6241.0
2013-08-09 07:00:00	ES	Futures	1745.1	1746.13	1744.84	1745.62	6853.0
2013-08-09 07:30:00	ES	Futures	1745.87	1747.42	1745.62	1747.17	8090.0
2013-08-09 08:00:00	ES	Futures	1747.42	1747.42	1746.39	1747.17	12603.0
2013-08-09 08:30:00	ES	Futures	1747.17	1747.42	1744.84	1746.13	16669.0
2013-08-09 09:00:00	ES	Futures	1746.39	1748.98	1745.87	1748.72	25039.0
2013-08-09 09:30:00	ES	Futures	1748.46	1753.89	1747.68	1752.59	191229.0
2013-08-09 10:00:00	ES	Futures	1752.34	1753.11	1746.39	1748.2	181063.0
2013-08-09 10:30:00	ES	Futures	1747.94	1750.27	1745.62	1746.39	117141.0
2013-08-09 11:00:00	ES	Futures	1746.13	1746.39	1739.67	1741.48	187341.0
2013-08-09 11:30:00	ES	Futures	1741.48	1744.84	1740.7	1744.06	122513.0
2013-08-09 12:00:00	ES	Futures	1743.81	1746.13	1742.51	1745.62	83888.0
2013-08-09 12:30:00	ES	Futures	1745.62	1748.46	1745.36	1746.65	68839.0
2013-08-09 13:00:00	ES	Futures	1746.65	1749.23	1746.13	1749.23	55579.0
2013-08-09 13:30:00	ES	Futures	1749.23	1749.75	1747.68	1748.2	54962.0
2013-08-09 14:00:00	ES	Futures	1747.94	1748.98	1745.87	1747.94	66807.0
2013-08-09 14:30:00	ES	Futures	1748.2	1748.72	1745.1	1747.17	86486.0
2013-08-09 15:00:00	ES	Futures	1747.17	1748.2	1745.87	1746.91	53485.0
2013-08-09 15:30:00	ES	Futures	1746.91	1747.17	1744.06	1745.87	137192.0
2013-08-09 16:00:00	ES	Futures	1745.87	1746.13	1743.03	1743.29	78530.0
2013-08-09 16:30:00	ES	Futures	1743.03	1743.29	1742.77	1742.77	5647.0
2013-08-09 17:00:00	ES	Futures	1742.77	1743.03	1742.26	1742.26	1926.0
2013-08-09 00:00:00	NQ	Futures	3654.99	3656.16	3653.53	3654.12	312.0
2013-08-09 00:30:00	NQ	Futures	3654.41	3655.29	3654.12	3654.41	88.0
2013-08-09 01:00:00	NQ	Futures	3654.41	3656.75	3654.41	3656.16	165.0
2013-08-09 01:30:00	NQ	Futures	3656.16	3658.21	3655.87	3657.04	559.0
2013-08-09 02:00:00	NQ	Futures	3657.33	3659.38	3657.33	3658.79	252.0
2013-08-09 02:30:00	NQ	Futures	3659.38	3659.67	3658.21	3658.21	152.0
2013-08-09 03:00:00	NQ	Futures	3658.5	3658.5	3649.73	3650.61	2238.0
2013-08-09 03:30:00	NQ	Futures	3650.61	3652.07	3649.73	3652.07	1257.0
2013-08-09 04:00:00	NQ	Futures	3652.07	3652.07	3647.4	3647.69	1842.0
2013-08-09 04:30:00	NQ	Futures	3647.4	3648.27	3644.77	3647.69	1292.0
2013-08-09 05:00:00	NQ	Futures	3647.98	3652.07	3647.98	3650.32	1499.0
2013-08-09 05:30:00	NQ	Futures	3650.32	3650.9	3648.27	3648.86	475.0
2013-08-09 06:00:00	NQ	Futures	3648.86	3648.86	3645.06	3647.4	1081.0
2013-08-09 06:30:00	NQ	Futures	3647.4	3649.15	3645.64	3648.86	733.0
2013-08-09 07:00:00	NQ	Futures	3649.15	3650.32	3648.27	3650.03	944.0

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

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