PREVIEW / futures_1hour / 2013-09-17

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-17.parquet
  size:    48 KB
  rows:    1,500

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-09-17 00:00:00	ES	Futures	1743.04	1743.3	1742.26	1742.52	1296.0
2013-09-17 01:00:00	ES	Futures	1742.78	1743.04	1741.75	1742.78	2702.0
2013-09-17 02:00:00	ES	Futures	1742.52	1743.55	1742.26	1743.04	5166.0
2013-09-17 03:00:00	ES	Futures	1743.3	1745.1	1742.01	1742.26	14270.0
2013-09-17 04:00:00	ES	Futures	1742.01	1744.07	1741.49	1743.55	10413.0
2013-09-17 05:00:00	ES	Futures	1743.3	1744.33	1741.75	1743.04	15875.0
2013-09-17 06:00:00	ES	Futures	1743.3	1743.55	1742.01	1743.3	10194.0
2013-09-17 07:00:00	ES	Futures	1743.3	1745.36	1742.26	1745.1	21160.0
2013-09-17 08:00:00	ES	Futures	1745.1	1746.65	1744.59	1745.62	32894.0
2013-09-17 09:00:00	ES	Futures	1745.62	1750.52	1745.62	1748.97	178968.0
2013-09-17 10:00:00	ES	Futures	1749.23	1751.81	1748.71	1750.26	145936.0
2013-09-17 11:00:00	ES	Futures	1750.0	1751.29	1749.49	1750.26	78870.0
2013-09-17 12:00:00	ES	Futures	1750.26	1752.33	1749.75	1752.07	46073.0
2013-09-17 13:00:00	ES	Futures	1752.07	1752.58	1751.04	1752.33	52282.0
2013-09-17 14:00:00	ES	Futures	1752.07	1752.84	1751.29	1752.07	56307.0
2013-09-17 15:00:00	ES	Futures	1751.81	1752.33	1750.52	1752.33	131108.0
2013-09-17 16:00:00	ES	Futures	1752.07	1753.87	1751.55	1753.1	63286.0
2013-09-17 17:00:00	ES	Futures	1753.36	1753.87	1753.1	1753.36	1740.0
2013-09-17 18:00:00	ES	Futures	1753.36	1753.87	1752.33	1752.84	3886.0
2013-09-17 19:00:00	ES	Futures	1752.84	1753.36	1752.58	1753.1	1782.0
2013-09-17 20:00:00	ES	Futures	1752.84	1754.13	1752.58	1753.36	5078.0
2013-09-17 21:00:00	ES	Futures	1753.1	1754.65	1753.1	1754.65	4587.0
2013-09-17 22:00:00	ES	Futures	1754.39	1755.16	1754.13	1754.13	3039.0
2013-09-17 23:00:00	ES	Futures	1754.39	1754.39	1752.33	1753.36	4728.0
2013-09-17 00:00:00	NQ	Futures	3671.36	3671.65	3669.03	3669.03	331.0
2013-09-17 01:00:00	NQ	Futures	3669.32	3669.91	3667.0	3668.16	449.0
2013-09-17 02:00:00	NQ	Futures	3668.45	3670.2	3667.58	3670.2	460.0
2013-09-17 03:00:00	NQ	Futures	3670.2	3674.26	3667.87	3668.16	2840.0
2013-09-17 04:00:00	NQ	Futures	3668.16	3671.65	3666.71	3670.78	1589.0
2013-09-17 05:00:00	NQ	Futures	3671.07	3673.97	3669.03	3671.07	2059.0
2013-09-17 06:00:00	NQ	Futures	3671.07	3671.36	3668.45	3670.2	1378.0
2013-09-17 07:00:00	NQ	Futures	3670.2	3675.13	3668.16	3673.97	2531.0
2013-09-17 08:00:00	NQ	Futures	3673.97	3678.62	3673.68	3677.75	6426.0
2013-09-17 09:00:00	NQ	Futures	3677.75	3691.69	3677.75	3688.78	37172.0
2013-09-17 10:00:00	NQ	Futures	3688.78	3697.5	3687.62	3696.92	25909.0
2013-09-17 11:00:00	NQ	Futures	3696.92	3701.85	3694.01	3696.62	16624.0
2013-09-17 12:00:00	NQ	Futures	3696.92	3702.72	3696.92	3701.85	10063.0
2013-09-17 13:00:00	NQ	Futures	3701.85	3704.18	3698.08	3703.3	10636.0
2013-09-17 14:00:00	NQ	Futures	3703.3	3704.76	3700.11	3701.56	8688.0
2013-09-17 15:00:00	NQ	Futures	3701.27	3704.18	3697.5	3700.4	18984.0
2013-09-17 16:00:00	NQ	Futures	3700.4	3702.72	3698.66	3701.85	4201.0
2013-09-17 17:00:00	NQ	Futures	3701.27	3702.72	3701.27	3701.27	56.0
2013-09-17 18:00:00	NQ	Futures	3701.85	3702.72	3700.98	3701.56	236.0
2013-09-17 19:00:00	NQ	Futures	3701.27	3703.01	3701.27	3702.43	222.0
2013-09-17 20:00:00	NQ	Futures	3702.43	3705.34	3702.14	3705.05	596.0
2013-09-17 21:00:00	NQ	Futures	3705.05	3708.53	3704.76	3706.79	669.0
2013-09-17 22:00:00	NQ	Futures	3707.08	3708.53	3707.08	3707.66	413.0
2013-09-17 23:00:00	NQ	Futures	3707.37	3707.66	3704.18	3706.5	480.0
2013-09-17 00:00:00	YM	Futures	15751.7	15751.7	15745.6	15749.7	428.0
2013-09-17 01:00:00	YM	Futures	15750.7	15750.7	15742.5	15747.6	405.0

> showing 50 of 1,500 rows — these rows as CSV

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