PREVIEW / futures_1hour / 2013-04-03

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-03.parquet
  size:    50 KB
  rows:    1,556

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-03 00:00:00	ES	Futures	1611.45	1612.22	1611.19	1611.96	1851.0
2013-04-03 01:00:00	ES	Futures	1611.96	1612.99	1611.71	1612.74	4139.0
2013-04-03 02:00:00	ES	Futures	1612.99	1614.02	1612.48	1613.77	7222.0
2013-04-03 03:00:00	ES	Futures	1613.77	1614.02	1611.96	1613.25	19940.0
2013-04-03 04:00:00	ES	Futures	1613.25	1615.05	1612.99	1614.54	13851.0
2013-04-03 05:00:00	ES	Futures	1614.54	1615.31	1614.02	1615.05	10763.0
2013-04-03 06:00:00	ES	Futures	1615.05	1615.05	1613.77	1614.02	9702.0
2013-04-03 07:00:00	ES	Futures	1614.02	1614.54	1612.22	1614.28	30386.0
2013-04-03 08:00:00	ES	Futures	1614.28	1614.54	1611.71	1612.74	56896.0
2013-04-03 09:00:00	ES	Futures	1612.74	1613.77	1607.58	1608.1	264415.0
2013-04-03 10:00:00	ES	Futures	1608.1	1609.13	1602.69	1603.2	418701.0
2013-04-03 11:00:00	ES	Futures	1602.95	1603.72	1600.37	1603.46	277770.0
2013-04-03 12:00:00	ES	Futures	1603.46	1603.46	1598.31	1599.6	156704.0
2013-04-03 13:00:00	ES	Futures	1599.34	1600.63	1593.93	1593.93	220929.0
2013-04-03 14:00:00	ES	Futures	1593.93	1599.08	1593.16	1598.05	257935.0
2013-04-03 15:00:00	ES	Futures	1598.05	1598.31	1590.84	1595.48	385220.0
2013-04-03 16:00:00	ES	Futures	1595.48	1596.25	1594.19	1595.99	100272.0
2013-04-03 17:00:00	ES	Futures	1595.99	1596.51	1595.73	1595.99	3045.0
2013-04-03 18:00:00	ES	Futures	1595.48	1596.25	1592.9	1594.96	10675.0
2013-04-03 19:00:00	ES	Futures	1594.7	1596.51	1594.7	1595.99	2897.0
2013-04-03 20:00:00	ES	Futures	1595.99	1596.25	1594.45	1595.73	7192.0
2013-04-03 21:00:00	ES	Futures	1595.48	1596.77	1594.96	1595.73	4364.0
2013-04-03 22:00:00	ES	Futures	1595.73	1595.99	1594.19	1594.19	3625.0
2013-04-03 23:00:00	ES	Futures	1594.45	1595.22	1594.19	1594.96	2663.0
2013-04-03 00:00:00	NQ	Futures	3282.72	3283.6	3282.14	3283.6	199.0
2013-04-03 01:00:00	NQ	Futures	3283.31	3285.06	3283.31	3285.06	256.0
2013-04-03 02:00:00	NQ	Futures	3284.76	3286.22	3284.18	3285.93	749.0
2013-04-03 03:00:00	NQ	Futures	3285.64	3285.93	3282.72	3284.76	1703.0
2013-04-03 04:00:00	NQ	Futures	3284.47	3287.1	3284.47	3286.51	1672.0
2013-04-03 05:00:00	NQ	Futures	3286.22	3287.68	3285.64	3286.51	1043.0
2013-04-03 06:00:00	NQ	Futures	3286.22	3286.81	3284.76	3285.06	1193.0
2013-04-03 07:00:00	NQ	Futures	3284.76	3286.51	3281.56	3286.22	4347.0
2013-04-03 08:00:00	NQ	Futures	3286.22	3286.81	3282.14	3283.89	5027.0
2013-04-03 09:00:00	NQ	Futures	3284.18	3289.14	3281.56	3283.89	26398.0
2013-04-03 10:00:00	NQ	Futures	3283.6	3285.35	3275.43	3276.6	38183.0
2013-04-03 11:00:00	NQ	Futures	3276.6	3277.47	3270.47	3275.14	26816.0
2013-04-03 12:00:00	NQ	Futures	3275.14	3275.14	3261.14	3262.89	26155.0
2013-04-03 13:00:00	NQ	Futures	3262.89	3264.35	3245.97	3246.56	38764.0
2013-04-03 14:00:00	NQ	Futures	3246.85	3257.64	3246.26	3256.47	32429.0
2013-04-03 15:00:00	NQ	Futures	3256.47	3257.93	3243.64	3252.97	42858.0
2013-04-03 16:00:00	NQ	Futures	3253.26	3254.14	3250.93	3252.39	6734.0
2013-04-03 17:00:00	NQ	Futures	3252.68	3253.26	3252.68	3252.97	90.0
2013-04-03 18:00:00	NQ	Futures	3252.68	3252.97	3248.6	3250.64	680.0
2013-04-03 19:00:00	NQ	Futures	3250.64	3252.97	3250.64	3252.97	362.0
2013-04-03 20:00:00	NQ	Futures	3252.68	3252.68	3249.76	3251.51	864.0
2013-04-03 21:00:00	NQ	Futures	3251.22	3253.85	3250.93	3252.39	310.0
2013-04-03 22:00:00	NQ	Futures	3252.39	3252.97	3249.76	3249.76	358.0
2013-04-03 23:00:00	NQ	Futures	3249.76	3251.22	3249.76	3250.35	240.0
2013-04-03 00:00:00	YM	Futures	14740.6	14743.6	14737.6	14743.6	161.0
2013-04-03 01:00:00	YM	Futures	14742.6	14756.8	14742.6	14756.8	1007.0

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

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