PREVIEW / futures_1hour / 2013-08-21

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-21.parquet
  size:    51 KB
  rows:    1,543

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-21 00:00:00	ES	Futures	1703.22	1704.0	1702.96	1704.0	2391.0
2013-08-21 01:00:00	ES	Futures	1703.74	1705.55	1703.74	1705.03	5596.0
2013-08-21 02:00:00	ES	Futures	1705.03	1706.07	1704.77	1705.29	4970.0
2013-08-21 03:00:00	ES	Futures	1705.29	1706.07	1702.71	1703.22	22365.0
2013-08-21 04:00:00	ES	Futures	1702.96	1704.0	1702.19	1702.71	16578.0
2013-08-21 05:00:00	ES	Futures	1702.45	1702.71	1699.6	1701.67	22344.0
2013-08-21 06:00:00	ES	Futures	1701.93	1702.45	1700.38	1700.9	11772.0
2013-08-21 07:00:00	ES	Futures	1701.15	1704.26	1700.64	1703.48	21971.0
2013-08-21 08:00:00	ES	Futures	1703.48	1704.77	1701.93	1702.45	21779.0
2013-08-21 09:00:00	ES	Futures	1702.71	1704.77	1699.34	1702.19	211708.0
2013-08-21 10:00:00	ES	Futures	1702.71	1705.03	1699.86	1701.93	256344.0
2013-08-21 11:00:00	ES	Futures	1702.19	1702.45	1695.98	1697.79	191494.0
2013-08-21 12:00:00	ES	Futures	1698.05	1700.9	1697.28	1700.64	107526.0
2013-08-21 13:00:00	ES	Futures	1700.64	1702.45	1699.09	1702.19	79063.0
2013-08-21 14:00:00	ES	Futures	1701.93	1710.98	1691.85	1707.62	600419.0
2013-08-21 15:00:00	ES	Futures	1707.88	1708.39	1694.95	1696.24	379556.0
2013-08-21 16:00:00	ES	Futures	1695.98	1696.24	1690.56	1691.07	123572.0
2013-08-21 17:00:00	ES	Futures	1690.81	1691.07	1689.52	1690.3	3151.0
2013-08-21 18:00:00	ES	Futures	1690.56	1691.33	1688.75	1689.01	8249.0
2013-08-21 19:00:00	ES	Futures	1689.26	1690.04	1687.45	1688.23	8356.0
2013-08-21 20:00:00	ES	Futures	1688.23	1688.75	1686.94	1688.49	14010.0
2013-08-21 21:00:00	ES	Futures	1688.49	1693.4	1688.23	1691.07	19784.0
2013-08-21 22:00:00	ES	Futures	1690.81	1691.85	1688.75	1689.78	9063.0
2013-08-21 23:00:00	ES	Futures	1689.52	1690.3	1688.49	1689.52	3786.0
2013-08-21 00:00:00	NQ	Futures	3596.84	3598.3	3596.84	3598.01	192.0
2013-08-21 01:00:00	NQ	Futures	3598.3	3601.51	3598.01	3601.22	352.0
2013-08-21 02:00:00	NQ	Futures	3600.64	3602.68	3600.64	3600.93	386.0
2013-08-21 03:00:00	NQ	Futures	3601.22	3602.1	3593.04	3593.92	3282.0
2013-08-21 04:00:00	NQ	Futures	3594.21	3596.84	3592.75	3593.33	2213.0
2013-08-21 05:00:00	NQ	Futures	3593.04	3593.62	3585.73	3589.24	4826.0
2013-08-21 06:00:00	NQ	Futures	3589.24	3590.41	3586.9	3588.07	1853.0
2013-08-21 07:00:00	NQ	Futures	3588.36	3596.25	3587.78	3594.79	3319.0
2013-08-21 08:00:00	NQ	Futures	3594.79	3597.72	3591.58	3592.75	3294.0
2013-08-21 09:00:00	NQ	Futures	3592.75	3609.7	3589.83	3606.19	31824.0
2013-08-21 10:00:00	NQ	Futures	3606.19	3612.33	3602.1	3607.36	27797.0
2013-08-21 11:00:00	NQ	Futures	3607.65	3608.82	3589.24	3593.33	27087.0
2013-08-21 12:00:00	NQ	Futures	3593.33	3597.42	3591.87	3594.5	12834.0
2013-08-21 13:00:00	NQ	Futures	3594.5	3601.22	3591.87	3598.3	9619.0
2013-08-21 14:00:00	NQ	Futures	3598.59	3622.26	3576.67	3615.83	86025.0
2013-08-21 15:00:00	NQ	Futures	3615.54	3617.3	3587.78	3590.41	65930.0
2013-08-21 16:00:00	NQ	Futures	3590.41	3590.7	3578.14	3578.14	10538.0
2013-08-21 17:00:00	NQ	Futures	3578.14	3578.72	3576.09	3577.55	473.0
2013-08-21 18:00:00	NQ	Futures	3579.3	3580.18	3575.21	3576.09	1059.0
2013-08-21 19:00:00	NQ	Futures	3576.38	3578.14	3573.75	3574.04	699.0
2013-08-21 20:00:00	NQ	Futures	3574.34	3575.51	3571.71	3575.21	987.0
2013-08-21 21:00:00	NQ	Futures	3575.21	3584.27	3575.21	3581.06	1924.0
2013-08-21 22:00:00	NQ	Futures	3581.06	3582.52	3575.51	3577.26	802.0
2013-08-21 23:00:00	NQ	Futures	3577.55	3578.43	3575.21	3576.97	327.0
2013-08-21 00:00:00	YM	Futures	15196.6	15204.7	15195.6	15202.7	270.0
2013-08-21 01:00:00	YM	Futures	15202.7	15211.9	15201.7	15210.8	945.0

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

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