PREVIEW / futures_30min / 2013-08-07

all futures 30-min files

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

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-07 00:00:00	ES	Futures	1747.94	1748.46	1747.68	1747.94	1000.0
2013-08-07 00:30:00	ES	Futures	1747.94	1748.2	1747.17	1747.42	1703.0
2013-08-07 01:00:00	ES	Futures	1747.42	1747.68	1745.62	1745.87	4835.0
2013-08-07 01:30:00	ES	Futures	1745.87	1746.39	1744.58	1744.84	6179.0
2013-08-07 02:00:00	ES	Futures	1744.58	1746.39	1744.58	1745.87	6131.0
2013-08-07 02:30:00	ES	Futures	1745.87	1746.13	1745.36	1745.62	2203.0
2013-08-07 03:00:00	ES	Futures	1745.36	1745.87	1743.81	1744.32	14598.0
2013-08-07 03:30:00	ES	Futures	1744.58	1744.58	1742.77	1743.55	10582.0
2013-08-07 04:00:00	ES	Futures	1743.29	1743.81	1742.51	1743.81	8544.0
2013-08-07 04:30:00	ES	Futures	1743.81	1746.39	1743.29	1745.62	10450.0
2013-08-07 05:00:00	ES	Futures	1745.87	1746.13	1744.32	1744.32	5336.0
2013-08-07 05:30:00	ES	Futures	1744.58	1746.91	1742.77	1743.55	18873.0
2013-08-07 06:00:00	ES	Futures	1743.55	1745.1	1742.51	1744.06	13565.0
2013-08-07 06:30:00	ES	Futures	1743.81	1746.39	1743.81	1744.84	9358.0
2013-08-07 07:00:00	ES	Futures	1744.84	1746.39	1744.58	1745.1	10046.0
2013-08-07 07:30:00	ES	Futures	1745.36	1746.91	1744.84	1746.39	10411.0
2013-08-07 08:00:00	ES	Futures	1746.65	1747.42	1746.13	1747.42	9947.0
2013-08-07 08:30:00	ES	Futures	1747.42	1747.42	1746.13	1746.91	9668.0
2013-08-07 09:00:00	ES	Futures	1747.17	1747.17	1744.06	1744.32	28065.0
2013-08-07 09:30:00	ES	Futures	1744.58	1746.91	1740.96	1741.22	232829.0
2013-08-07 10:00:00	ES	Futures	1741.22	1741.48	1738.12	1738.89	165017.0
2013-08-07 10:30:00	ES	Futures	1738.89	1741.22	1737.6	1740.96	109322.0
2013-08-07 11:00:00	ES	Futures	1740.96	1742.0	1739.93	1739.93	60224.0
2013-08-07 11:30:00	ES	Futures	1740.19	1740.96	1738.64	1740.7	74881.0
2013-08-07 12:00:00	ES	Futures	1740.7	1742.0	1739.93	1740.96	43848.0
2013-08-07 12:30:00	ES	Futures	1740.96	1744.32	1740.7	1744.06	61642.0
2013-08-07 13:00:00	ES	Futures	1744.32	1745.62	1743.81	1744.84	52542.0
2013-08-07 13:30:00	ES	Futures	1745.1	1745.62	1743.29	1744.84	50850.0
2013-08-07 14:00:00	ES	Futures	1744.84	1745.36	1742.51	1743.55	49504.0
2013-08-07 14:30:00	ES	Futures	1743.55	1744.84	1742.77	1744.58	45692.0
2013-08-07 15:00:00	ES	Futures	1744.58	1746.91	1744.06	1746.13	77316.0
2013-08-07 15:30:00	ES	Futures	1745.87	1746.65	1743.81	1744.84	99799.0
2013-08-07 16:00:00	ES	Futures	1744.84	1745.87	1744.32	1745.36	43781.0
2013-08-07 16:30:00	ES	Futures	1745.62	1746.39	1745.36	1746.39	7193.0
2013-08-07 17:00:00	ES	Futures	1746.65	1746.65	1746.13	1746.13	1275.0
2013-08-07 18:00:00	ES	Futures	1746.13	1746.13	1745.36	1745.62	2831.0
2013-08-07 18:30:00	ES	Futures	1745.62	1746.13	1745.36	1745.87	684.0
2013-08-07 19:00:00	ES	Futures	1745.87	1746.13	1745.1	1745.36	1205.0
2013-08-07 19:30:00	ES	Futures	1745.36	1747.17	1745.36	1746.91	1615.0
2013-08-07 20:00:00	ES	Futures	1747.17	1749.75	1746.91	1749.49	8903.0
2013-08-07 20:30:00	ES	Futures	1749.75	1750.01	1748.98	1749.49	3132.0
2013-08-07 21:00:00	ES	Futures	1749.49	1750.79	1749.23	1750.01	3851.0
2013-08-07 21:30:00	ES	Futures	1750.01	1750.27	1748.98	1748.98	2032.0
2013-08-07 22:00:00	ES	Futures	1749.23	1750.27	1748.98	1749.75	1236.0
2013-08-07 22:30:00	ES	Futures	1749.49	1749.49	1748.72	1749.23	1105.0
2013-08-07 23:00:00	ES	Futures	1748.98	1751.56	1748.72	1751.56	7963.0
2013-08-07 23:30:00	ES	Futures	1751.56	1752.08	1751.04	1751.04	3882.0
2013-08-07 00:00:00	NQ	Futures	3641.26	3642.14	3640.97	3641.84	136.0
2013-08-07 00:30:00	NQ	Futures	3641.55	3641.55	3639.8	3639.8	192.0
2013-08-07 01:00:00	NQ	Futures	3640.38	3640.97	3636.88	3637.17	727.0

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

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