PREVIEW / futures_1hour / 2013-04-05

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-05.parquet
  size:    44 KB
  rows:    1,267

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-05 00:00:00	ES	Futures	1598.31	1598.57	1597.54	1597.8	5283.0
2013-04-05 01:00:00	ES	Futures	1597.54	1598.57	1597.28	1598.05	5408.0
2013-04-05 02:00:00	ES	Futures	1598.31	1599.6	1597.8	1599.08	10005.0
2013-04-05 03:00:00	ES	Futures	1599.08	1599.6	1597.54	1598.83	19513.0
2013-04-05 04:00:00	ES	Futures	1598.83	1599.86	1598.05	1598.31	17677.0
2013-04-05 05:00:00	ES	Futures	1598.31	1599.08	1595.22	1595.73	27842.0
2013-04-05 06:00:00	ES	Futures	1595.99	1597.28	1592.64	1592.9	56260.0
2013-04-05 07:00:00	ES	Futures	1592.9	1593.93	1590.07	1592.64	59213.0
2013-04-05 08:00:00	ES	Futures	1592.39	1592.9	1579.76	1581.31	279859.0
2013-04-05 09:00:00	ES	Futures	1581.31	1585.43	1579.76	1581.57	361186.0
2013-04-05 10:00:00	ES	Futures	1581.83	1587.49	1580.02	1585.95	378672.0
2013-04-05 11:00:00	ES	Futures	1586.2	1589.3	1585.69	1585.95	244885.0
2013-04-05 12:00:00	ES	Futures	1585.69	1588.27	1584.92	1586.2	143829.0
2013-04-05 13:00:00	ES	Futures	1586.2	1590.58	1585.69	1588.27	128795.0
2013-04-05 14:00:00	ES	Futures	1588.27	1591.1	1587.23	1590.58	131446.0
2013-04-05 15:00:00	ES	Futures	1590.58	1596.25	1588.52	1594.45	273066.0
2013-04-05 16:00:00	ES	Futures	1594.7	1594.96	1592.13	1594.19	95237.0
2013-04-05 17:00:00	ES	Futures	1593.93	1594.45	1593.93	1593.93	1501.0
2013-04-05 00:00:00	NQ	Futures	3243.35	3243.64	3241.31	3241.6	527.0
2013-04-05 01:00:00	NQ	Futures	3241.6	3242.76	3239.85	3242.76	544.0
2013-04-05 02:00:00	NQ	Futures	3242.18	3245.39	3241.6	3243.93	645.0
2013-04-05 03:00:00	NQ	Futures	3243.93	3245.97	3240.43	3243.35	1696.0
2013-04-05 04:00:00	NQ	Futures	3243.64	3245.97	3240.14	3241.31	1819.0
2013-04-05 05:00:00	NQ	Futures	3241.31	3242.18	3234.01	3235.18	3083.0
2013-04-05 06:00:00	NQ	Futures	3235.18	3237.22	3228.18	3229.93	5868.0
2013-04-05 07:00:00	NQ	Futures	3229.93	3231.97	3224.68	3227.6	4949.0
2013-04-05 08:00:00	NQ	Futures	3227.6	3229.35	3202.22	3206.01	21286.0
2013-04-05 09:00:00	NQ	Futures	3206.01	3210.97	3193.76	3199.89	52805.0
2013-04-05 10:00:00	NQ	Futures	3199.89	3213.6	3195.81	3211.56	41233.0
2013-04-05 11:00:00	NQ	Futures	3211.26	3217.68	3209.81	3210.39	28246.0
2013-04-05 12:00:00	NQ	Futures	3210.1	3213.89	3207.76	3208.64	19303.0
2013-04-05 13:00:00	NQ	Futures	3208.93	3215.64	3206.89	3210.68	15532.0
2013-04-05 14:00:00	NQ	Futures	3210.68	3217.68	3208.64	3215.93	18543.0
2013-04-05 15:00:00	NQ	Futures	3215.93	3230.22	3211.56	3225.85	38717.0
2013-04-05 16:00:00	NQ	Futures	3225.85	3226.72	3223.22	3225.85	7621.0
2013-04-05 17:00:00	NQ	Futures	3225.85	3226.43	3224.68	3226.14	226.0
2013-04-05 00:00:00	YM	Futures	14665.8	14666.8	14659.7	14659.7	585.0
2013-04-05 01:00:00	YM	Futures	14659.7	14665.8	14650.6	14662.7	1041.0
2013-04-05 02:00:00	YM	Futures	14662.7	14675.9	14660.7	14671.8	1154.0
2013-04-05 03:00:00	YM	Futures	14671.8	14676.9	14659.7	14669.8	1904.0
2013-04-05 04:00:00	YM	Futures	14670.8	14678.9	14667.8	14669.8	1428.0
2013-04-05 05:00:00	YM	Futures	14668.8	14671.8	14639.5	14645.6	2698.0
2013-04-05 06:00:00	YM	Futures	14644.6	14651.6	14613.2	14614.2	5604.0
2013-04-05 07:00:00	YM	Futures	14614.2	14619.3	14587.9	14609.2	6928.0
2013-04-05 08:00:00	YM	Futures	14609.2	14614.2	14524.2	14537.4	19860.0
2013-04-05 09:00:00	YM	Futures	14537.4	14563.7	14518.2	14525.3	33432.0
2013-04-05 10:00:00	YM	Futures	14525.3	14572.8	14518.2	14561.7	29128.0
2013-04-05 11:00:00	YM	Futures	14561.7	14595.0	14560.6	14571.8	18243.0
2013-04-05 12:00:00	YM	Futures	14570.8	14597.0	14564.7	14578.8	10403.0
2013-04-05 13:00:00	YM	Futures	14579.8	14612.2	14576.8	14599.1	11464.0

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

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