PREVIEW / futures_30min / 2013-08-01

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-08-01.parquet
  size:    80 KB
  rows:    2,871

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-01 00:00:00	ES	Futures	1745.87	1746.39	1745.1	1745.36	1994.0
2013-08-01 00:30:00	ES	Futures	1745.62	1746.39	1745.1	1746.13	1003.0
2013-08-01 01:00:00	ES	Futures	1746.13	1746.39	1745.87	1746.13	1128.0
2013-08-01 01:30:00	ES	Futures	1746.13	1746.91	1745.62	1746.91	1910.0
2013-08-01 02:00:00	ES	Futures	1746.65	1747.68	1746.39	1747.42	4897.0
2013-08-01 02:30:00	ES	Futures	1747.42	1747.68	1746.65	1746.91	3113.0
2013-08-01 03:00:00	ES	Futures	1746.91	1748.46	1745.87	1747.42	13346.0
2013-08-01 03:30:00	ES	Futures	1747.42	1747.94	1746.39	1747.42	6306.0
2013-08-01 04:00:00	ES	Futures	1747.68	1747.68	1745.1	1746.39	6347.0
2013-08-01 04:30:00	ES	Futures	1746.65	1747.94	1746.39	1747.68	5639.0
2013-08-01 05:00:00	ES	Futures	1747.94	1750.53	1747.68	1750.27	13952.0
2013-08-01 05:30:00	ES	Futures	1750.27	1751.56	1749.75	1751.04	11406.0
2013-08-01 06:00:00	ES	Futures	1750.79	1751.04	1750.27	1750.53	5697.0
2013-08-01 06:30:00	ES	Futures	1750.53	1750.53	1748.98	1749.49	12168.0
2013-08-01 07:00:00	ES	Futures	1749.49	1750.01	1748.72	1749.49	10659.0
2013-08-01 07:30:00	ES	Futures	1749.49	1750.27	1748.98	1749.23	9510.0
2013-08-01 08:00:00	ES	Futures	1749.49	1751.56	1749.23	1751.04	15045.0
2013-08-01 08:30:00	ES	Futures	1751.3	1752.08	1749.23	1750.27	33000.0
2013-08-01 09:00:00	ES	Futures	1750.27	1753.37	1749.49	1752.85	42625.0
2013-08-01 09:30:00	ES	Futures	1753.11	1756.21	1751.82	1753.89	220983.0
2013-08-01 10:00:00	ES	Futures	1753.89	1758.54	1753.89	1758.02	186834.0
2013-08-01 10:30:00	ES	Futures	1758.02	1758.28	1754.4	1755.18	102711.0
2013-08-01 11:00:00	ES	Futures	1755.44	1756.21	1754.15	1755.7	83284.0
2013-08-01 11:30:00	ES	Futures	1755.7	1757.25	1755.44	1756.47	51729.0
2013-08-01 12:00:00	ES	Futures	1756.47	1758.28	1754.92	1757.51	52929.0
2013-08-01 12:30:00	ES	Futures	1757.51	1758.54	1755.96	1756.73	38418.0
2013-08-01 13:00:00	ES	Futures	1756.73	1757.51	1755.96	1756.21	32298.0
2013-08-01 13:30:00	ES	Futures	1756.21	1758.28	1755.7	1757.76	33052.0
2013-08-01 14:00:00	ES	Futures	1757.76	1760.35	1757.51	1759.83	80186.0
2013-08-01 14:30:00	ES	Futures	1760.09	1760.35	1758.54	1759.32	47622.0
2013-08-01 15:00:00	ES	Futures	1759.32	1759.83	1756.47	1758.02	62134.0
2013-08-01 15:30:00	ES	Futures	1758.02	1761.64	1758.02	1759.57	173858.0
2013-08-01 16:00:00	ES	Futures	1759.83	1760.09	1757.25	1758.54	99013.0
2013-08-01 16:30:00	ES	Futures	1758.54	1760.61	1758.54	1760.35	13445.0
2013-08-01 17:00:00	ES	Futures	1760.09	1760.35	1759.83	1760.35	2155.0
2013-08-01 18:00:00	ES	Futures	1760.09	1760.35	1757.76	1758.02	4959.0
2013-08-01 18:30:00	ES	Futures	1757.76	1758.8	1757.76	1758.8	1168.0
2013-08-01 19:00:00	ES	Futures	1758.8	1758.8	1758.28	1758.8	509.0
2013-08-01 19:30:00	ES	Futures	1758.8	1759.57	1758.28	1759.32	1159.0
2013-08-01 20:00:00	ES	Futures	1759.32	1759.57	1758.02	1759.32	1938.0
2013-08-01 20:30:00	ES	Futures	1759.32	1759.83	1759.06	1759.32	1344.0
2013-08-01 21:00:00	ES	Futures	1759.57	1759.83	1759.32	1759.83	1190.0
2013-08-01 21:30:00	ES	Futures	1759.83	1760.35	1759.06	1760.09	2817.0
2013-08-01 22:00:00	ES	Futures	1760.09	1760.35	1759.57	1759.83	441.0
2013-08-01 22:30:00	ES	Futures	1759.83	1759.83	1759.06	1759.57	965.0
2013-08-01 23:00:00	ES	Futures	1759.57	1759.57	1759.06	1759.32	1295.0
2013-08-01 23:30:00	ES	Futures	1759.06	1759.57	1758.54	1758.8	1671.0
2013-08-01 00:00:00	NQ	Futures	3618.46	3619.34	3617.3	3617.88	352.0
2013-08-01 00:30:00	NQ	Futures	3617.88	3619.93	3617.3	3619.34	143.0
2013-08-01 01:00:00	NQ	Futures	3619.34	3620.22	3619.05	3619.34	300.0

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

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