PREVIEW / futures_1hour / 2013-03-11

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-11.parquet
  size:    45 KB
  rows:    1,440

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-03-11 00:00:00	ES	Futures	1590.86	1590.86	1590.35	1590.61	671.0
2013-03-11 01:00:00	ES	Futures	1590.61	1590.86	1588.04	1588.3	1770.0
2013-03-11 02:00:00	ES	Futures	1588.3	1589.07	1588.3	1588.81	1483.0
2013-03-11 03:00:00	ES	Futures	1588.81	1590.35	1587.79	1588.3	4981.0
2013-03-11 04:00:00	ES	Futures	1588.3	1589.58	1587.27	1588.3	8041.0
2013-03-11 05:00:00	ES	Futures	1588.3	1589.58	1587.53	1588.04	3079.0
2013-03-11 06:00:00	ES	Futures	1588.04	1588.3	1587.27	1588.04	2158.0
2013-03-11 07:00:00	ES	Futures	1588.04	1588.04	1586.25	1588.04	4353.0
2013-03-11 08:00:00	ES	Futures	1588.04	1589.58	1587.79	1588.81	6091.0
2013-03-11 09:00:00	ES	Futures	1588.81	1590.86	1587.79	1590.09	25059.0
2013-03-11 10:00:00	ES	Futures	1589.84	1590.86	1588.3	1590.09	25738.0
2013-03-11 11:00:00	ES	Futures	1590.35	1592.66	1589.58	1592.4	22988.0
2013-03-11 12:00:00	ES	Futures	1592.4	1594.46	1592.15	1594.46	22190.0
2013-03-11 13:00:00	ES	Futures	1594.46	1596.0	1594.2	1594.97	18941.0
2013-03-11 14:00:00	ES	Futures	1594.97	1597.02	1594.2	1596.25	22442.0
2013-03-11 15:00:00	ES	Futures	1596.25	1597.02	1593.94	1596.51	33033.0
2013-03-11 16:00:00	ES	Futures	1596.77	1597.54	1596.0	1597.28	16517.0
2013-03-11 17:00:00	ES	Futures	1597.28	1598.31	1597.02	1597.54	1224.0
2013-03-11 18:00:00	ES	Futures	1597.79	1598.05	1596.25	1596.51	1066.0
2013-03-11 19:00:00	ES	Futures	1596.25	1597.02	1596.25	1597.02	663.0
2013-03-11 20:00:00	ES	Futures	1597.02	1597.02	1596.25	1596.51	813.0
2013-03-11 21:00:00	ES	Futures	1596.51	1597.28	1596.0	1596.51	1573.0
2013-03-11 22:00:00	ES	Futures	1596.25	1597.02	1596.25	1596.51	558.0
2013-03-11 23:00:00	ES	Futures	1596.25	1596.51	1595.74	1595.74	986.0
2013-03-11 00:00:00	NQ	Futures	3263.18	3264.05	3262.59	3262.59	119.0
2013-03-11 01:00:00	NQ	Futures	3262.3	3262.3	3255.9	3255.9	688.0
2013-03-11 02:00:00	NQ	Futures	3256.48	3257.94	3256.19	3257.65	73.0
2013-03-11 03:00:00	NQ	Futures	3258.23	3258.23	3254.15	3254.44	627.0
2013-03-11 04:00:00	NQ	Futures	3255.61	3258.81	3253.86	3255.32	387.0
2013-03-11 05:00:00	NQ	Futures	3255.32	3257.94	3255.03	3255.9	219.0
2013-03-11 06:00:00	NQ	Futures	3256.19	3256.48	3255.03	3255.9	135.0
2013-03-11 07:00:00	NQ	Futures	3256.19	3256.19	3252.99	3255.03	507.0
2013-03-11 08:00:00	NQ	Futures	3254.44	3257.65	3254.44	3257.06	686.0
2013-03-11 09:00:00	NQ	Futures	3256.77	3261.14	3254.44	3256.19	3564.0
2013-03-11 10:00:00	NQ	Futures	3256.19	3258.81	3249.79	3252.41	2985.0
2013-03-11 11:00:00	NQ	Futures	3252.11	3259.68	3251.24	3259.1	2911.0
2013-03-11 12:00:00	NQ	Futures	3259.39	3264.63	3259.1	3262.59	3223.0
2013-03-11 13:00:00	NQ	Futures	3262.59	3267.25	3261.72	3263.18	2138.0
2013-03-11 14:00:00	NQ	Futures	3263.18	3273.95	3259.97	3270.74	4100.0
2013-03-11 15:00:00	NQ	Futures	3270.16	3274.24	3267.54	3273.36	3858.0
2013-03-11 16:00:00	NQ	Futures	3273.65	3273.95	3271.33	3272.49	1217.0
2013-03-11 17:00:00	NQ	Futures	3272.2	3273.95	3271.91	3273.95	33.0
2013-03-11 18:00:00	NQ	Futures	3271.33	3273.07	3269.87	3269.87	47.0
2013-03-11 19:00:00	NQ	Futures	3269.87	3272.2	3269.87	3271.62	23.0
2013-03-11 20:00:00	NQ	Futures	3271.03	3271.33	3270.16	3270.45	48.0
2013-03-11 21:00:00	NQ	Futures	3270.45	3271.91	3270.45	3270.45	77.0
2013-03-11 22:00:00	NQ	Futures	3271.03	3271.62	3270.45	3270.45	33.0
2013-03-11 23:00:00	NQ	Futures	3270.74	3270.74	3266.96	3267.54	326.0
2013-03-11 00:00:00	YM	Futures	14481.8	14483.8	14478.8	14479.8	157.0
2013-03-11 01:00:00	YM	Futures	14479.8	14479.8	14462.6	14462.6	367.0

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

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