PREVIEW / futures_1hour / 2013-03-13

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-13.parquet
  size:    48 KB
  rows:    1,516

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-13 00:00:00	ES	Futures	1593.17	1594.2	1592.92	1592.92	318.0
2013-03-13 01:00:00	ES	Futures	1592.92	1594.46	1592.4	1594.46	505.0
2013-03-13 02:00:00	ES	Futures	1594.2	1595.23	1593.94	1594.71	893.0
2013-03-13 03:00:00	ES	Futures	1594.71	1594.71	1593.17	1594.46	1373.0
2013-03-13 04:00:00	ES	Futures	1594.46	1594.71	1592.15	1592.4	4183.0
2013-03-13 05:00:00	ES	Futures	1592.4	1592.92	1591.12	1591.38	3138.0
2013-03-13 06:00:00	ES	Futures	1591.38	1592.15	1590.09	1590.61	3807.0
2013-03-13 07:00:00	ES	Futures	1590.35	1590.61	1589.33	1589.58	5307.0
2013-03-13 08:00:00	ES	Futures	1589.58	1595.23	1589.33	1594.71	13102.0
2013-03-13 09:00:00	ES	Futures	1594.46	1594.97	1588.81	1591.63	26385.0
2013-03-13 10:00:00	ES	Futures	1591.89	1593.94	1589.33	1593.43	17087.0
2013-03-13 11:00:00	ES	Futures	1593.69	1594.46	1591.89	1592.4	13557.0
2013-03-13 12:00:00	ES	Futures	1592.4	1597.02	1592.15	1595.74	15588.0
2013-03-13 13:00:00	ES	Futures	1595.74	1597.79	1594.71	1597.02	10159.0
2013-03-13 14:00:00	ES	Futures	1597.02	1597.28	1594.97	1595.48	11600.0
2013-03-13 15:00:00	ES	Futures	1595.48	1596.77	1593.94	1595.48	18799.0
2013-03-13 16:00:00	ES	Futures	1595.48	1598.05	1594.71	1597.79	12039.0
2013-03-13 17:00:00	ES	Futures	1597.79	1598.05	1597.28	1598.05	490.0
2013-03-13 18:00:00	ES	Futures	1597.54	1597.79	1596.25	1597.28	932.0
2013-03-13 19:00:00	ES	Futures	1597.02	1597.02	1596.25	1596.77	378.0
2013-03-13 20:00:00	ES	Futures	1596.77	1598.05	1596.51	1597.54	932.0
2013-03-13 21:00:00	ES	Futures	1597.54	1597.54	1596.0	1596.25	1197.0
2013-03-13 22:00:00	ES	Futures	1596.25	1596.77	1596.0	1596.77	400.0
2013-03-13 23:00:00	ES	Futures	1596.51	1597.28	1596.51	1597.02	513.0
2013-03-13 00:00:00	NQ	Futures	3266.38	3266.38	3263.47	3263.47	27.0
2013-03-13 01:00:00	NQ	Futures	3264.05	3266.09	3264.05	3266.09	23.0
2013-03-13 02:00:00	NQ	Futures	3265.8	3267.25	3265.5	3265.5	21.0
2013-03-13 03:00:00	NQ	Futures	3266.09	3266.38	3263.76	3264.63	66.0
2013-03-13 04:00:00	NQ	Futures	3265.21	3265.5	3259.97	3259.97	208.0
2013-03-13 05:00:00	NQ	Futures	3259.68	3260.56	3257.06	3257.94	206.0
2013-03-13 06:00:00	NQ	Futures	3257.94	3259.1	3256.19	3256.48	625.0
2013-03-13 07:00:00	NQ	Futures	3256.77	3257.35	3254.73	3255.61	397.0
2013-03-13 08:00:00	NQ	Futures	3255.32	3269.58	3255.32	3265.21	983.0
2013-03-13 09:00:00	NQ	Futures	3264.63	3265.5	3247.46	3252.7	2617.0
2013-03-13 10:00:00	NQ	Futures	3252.7	3261.43	3245.71	3259.1	2986.0
2013-03-13 11:00:00	NQ	Futures	3259.68	3261.72	3252.7	3252.7	1747.0
2013-03-13 12:00:00	NQ	Futures	3252.99	3264.63	3252.7	3263.18	2376.0
2013-03-13 13:00:00	NQ	Futures	3263.18	3269.87	3260.56	3268.12	1747.0
2013-03-13 14:00:00	NQ	Futures	3267.54	3268.41	3259.97	3261.43	1971.0
2013-03-13 15:00:00	NQ	Futures	3261.72	3262.88	3256.48	3257.35	4579.0
2013-03-13 16:00:00	NQ	Futures	3257.35	3261.43	3256.77	3261.43	440.0
2013-03-13 17:00:00	NQ	Futures	3261.14	3262.3	3260.56	3262.3	11.0
2013-03-13 18:00:00	NQ	Futures	3260.26	3260.26	3258.81	3259.97	3.0
2013-03-13 19:00:00	NQ	Futures	3259.39	3259.97	3258.81	3259.39	14.0
2013-03-13 20:00:00	NQ	Futures	3259.39	3261.14	3259.39	3259.97	13.0
2013-03-13 21:00:00	NQ	Futures	3259.97	3259.97	3257.35	3258.52	26.0
2013-03-13 22:00:00	NQ	Futures	3257.65	3258.23	3257.06	3258.23	64.0
2013-03-13 23:00:00	NQ	Futures	3259.68	3260.56	3259.68	3260.26	10.0
2013-03-13 00:00:00	YM	Futures	14540.4	14546.5	14535.4	14536.4	253.0
2013-03-13 01:00:00	YM	Futures	14536.4	14546.5	14534.4	14545.5	261.0

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

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