PREVIEW / futures_1hour / 2013-04-16

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-16.parquet
  size:    52 KB
  rows:    1,582

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-04-16 00:00:00	ES	Futures	1598.57	1599.08	1597.02	1598.83	8590.0
2013-04-16 01:00:00	ES	Futures	1598.83	1599.34	1597.8	1599.08	6706.0
2013-04-16 02:00:00	ES	Futures	1599.08	1601.4	1598.57	1599.08	23088.0
2013-04-16 03:00:00	ES	Futures	1599.08	1602.17	1597.54	1598.31	46689.0
2013-04-16 04:00:00	ES	Futures	1598.57	1598.57	1594.45	1594.96	35105.0
2013-04-16 05:00:00	ES	Futures	1594.7	1600.89	1594.7	1599.6	36322.0
2013-04-16 06:00:00	ES	Futures	1599.34	1600.11	1596.77	1597.8	23821.0
2013-04-16 07:00:00	ES	Futures	1597.8	1603.72	1597.54	1602.43	43492.0
2013-04-16 08:00:00	ES	Futures	1602.43	1607.07	1602.17	1605.78	115678.0
2013-04-16 09:00:00	ES	Futures	1605.78	1608.61	1602.43	1606.55	292311.0
2013-04-16 10:00:00	ES	Futures	1606.55	1608.61	1601.66	1604.49	334023.0
2013-04-16 11:00:00	ES	Futures	1604.49	1612.99	1603.46	1611.45	297797.0
2013-04-16 12:00:00	ES	Futures	1611.71	1615.57	1610.42	1615.05	167064.0
2013-04-16 13:00:00	ES	Futures	1614.8	1616.08	1612.99	1613.25	108111.0
2013-04-16 14:00:00	ES	Futures	1613.25	1614.54	1609.9	1610.16	160715.0
2013-04-16 15:00:00	ES	Futures	1610.16	1618.4	1609.9	1617.37	362890.0
2013-04-16 16:00:00	ES	Futures	1617.37	1617.63	1615.57	1616.6	97430.0
2013-04-16 17:00:00	ES	Futures	1616.6	1617.63	1616.6	1617.37	3180.0
2013-04-16 18:00:00	ES	Futures	1616.86	1617.11	1612.22	1613.25	15398.0
2013-04-16 19:00:00	ES	Futures	1613.25	1615.31	1612.99	1613.77	4402.0
2013-04-16 20:00:00	ES	Futures	1613.77	1615.05	1612.99	1613.51	6350.0
2013-04-16 21:00:00	ES	Futures	1613.77	1614.28	1612.74	1613.51	3263.0
2013-04-16 22:00:00	ES	Futures	1613.51	1614.54	1612.99	1613.25	2909.0
2013-04-16 23:00:00	ES	Futures	1612.99	1613.51	1610.93	1611.45	6249.0
2013-04-16 00:00:00	NQ	Futures	3270.18	3271.93	3266.68	3269.31	1189.0
2013-04-16 01:00:00	NQ	Futures	3269.01	3271.35	3266.97	3269.01	679.0
2013-04-16 02:00:00	NQ	Futures	3269.31	3273.1	3267.26	3267.85	1980.0
2013-04-16 03:00:00	NQ	Futures	3268.14	3273.39	3264.64	3266.97	3881.0
2013-04-16 04:00:00	NQ	Futures	3266.68	3267.26	3258.81	3259.68	2697.0
2013-04-16 05:00:00	NQ	Futures	3259.68	3271.35	3259.1	3268.14	2587.0
2013-04-16 06:00:00	NQ	Futures	3268.14	3269.01	3262.31	3265.22	1544.0
2013-04-16 07:00:00	NQ	Futures	3265.22	3275.14	3265.22	3273.97	3204.0
2013-04-16 08:00:00	NQ	Futures	3273.68	3280.68	3273.39	3278.64	9832.0
2013-04-16 09:00:00	NQ	Futures	3278.64	3284.18	3271.93	3276.6	32764.0
2013-04-16 10:00:00	NQ	Futures	3276.6	3283.01	3270.18	3277.18	36341.0
2013-04-16 11:00:00	NQ	Futures	3277.18	3300.51	3275.14	3297.31	36804.0
2013-04-16 12:00:00	NQ	Futures	3297.31	3302.85	3293.51	3301.68	16939.0
2013-04-16 13:00:00	NQ	Futures	3301.68	3302.85	3297.89	3299.06	12324.0
2013-04-16 14:00:00	NQ	Futures	3299.35	3301.1	3292.06	3292.35	16400.0
2013-04-16 15:00:00	NQ	Futures	3292.35	3305.77	3291.76	3302.56	37956.0
2013-04-16 16:00:00	NQ	Futures	3302.85	3306.64	3298.18	3300.51	11014.0
2013-04-16 17:00:00	NQ	Futures	3300.51	3301.1	3300.22	3300.81	95.0
2013-04-16 18:00:00	NQ	Futures	3302.26	3302.26	3292.35	3294.39	962.0
2013-04-16 19:00:00	NQ	Futures	3294.1	3297.6	3293.81	3294.68	341.0
2013-04-16 20:00:00	NQ	Futures	3294.97	3296.72	3293.22	3294.68	506.0
2013-04-16 21:00:00	NQ	Futures	3294.39	3295.26	3292.93	3293.51	565.0
2013-04-16 22:00:00	NQ	Futures	3293.51	3295.56	3292.93	3293.51	341.0
2013-04-16 23:00:00	NQ	Futures	3293.22	3293.81	3289.72	3290.31	522.0
2013-04-16 00:00:00	YM	Futures	14745.6	14750.7	14730.5	14743.6	1191.0
2013-04-16 01:00:00	YM	Futures	14743.6	14753.7	14735.5	14748.7	1123.0

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

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