PREVIEW / futures_1hour / 2013-03-26

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-26.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-26 00:00:00	ES	Futures	1596.51	1597.28	1596.25	1596.77	2560.0
2013-03-26 01:00:00	ES	Futures	1596.51	1597.02	1595.99	1597.02	2798.0
2013-03-26 02:00:00	ES	Futures	1596.77	1597.02	1595.22	1595.73	5016.0
2013-03-26 03:00:00	ES	Futures	1595.73	1598.05	1595.48	1597.02	12526.0
2013-03-26 04:00:00	ES	Futures	1597.02	1598.05	1595.22	1597.02	36671.0
2013-03-26 05:00:00	ES	Futures	1596.77	1597.8	1596.25	1597.54	16463.0
2013-03-26 06:00:00	ES	Futures	1597.54	1598.31	1597.02	1597.8	12523.0
2013-03-26 07:00:00	ES	Futures	1597.54	1598.57	1594.7	1594.96	36909.0
2013-03-26 08:00:00	ES	Futures	1595.22	1598.05	1594.7	1597.28	56915.0
2013-03-26 09:00:00	ES	Futures	1597.02	1602.43	1596.25	1601.66	234420.0
2013-03-26 10:00:00	ES	Futures	1601.4	1603.46	1597.28	1600.37	414209.0
2013-03-26 11:00:00	ES	Futures	1600.63	1602.43	1598.83	1600.37	158419.0
2013-03-26 12:00:00	ES	Futures	1600.11	1601.66	1598.31	1599.6	119364.0
2013-03-26 13:00:00	ES	Futures	1599.86	1602.69	1599.34	1602.17	79580.0
2013-03-26 14:00:00	ES	Futures	1602.17	1603.72	1601.4	1602.43	68838.0
2013-03-26 15:00:00	ES	Futures	1602.43	1605.78	1602.17	1605.01	207142.0
2013-03-26 16:00:00	ES	Futures	1604.75	1606.04	1603.98	1605.01	91660.0
2013-03-26 17:00:00	ES	Futures	1605.01	1605.78	1605.01	1605.52	2942.0
2013-03-26 18:00:00	ES	Futures	1605.52	1606.3	1604.49	1606.04	4577.0
2013-03-26 19:00:00	ES	Futures	1606.3	1606.3	1604.75	1605.01	2348.0
2013-03-26 20:00:00	ES	Futures	1605.01	1605.27	1604.24	1604.75	3629.0
2013-03-26 21:00:00	ES	Futures	1604.49	1605.78	1604.49	1605.52	3094.0
2013-03-26 22:00:00	ES	Futures	1605.27	1605.78	1603.98	1604.49	3199.0
2013-03-26 23:00:00	ES	Futures	1604.49	1605.78	1604.49	1605.52	2230.0
2013-03-26 00:00:00	NQ	Futures	3253.26	3254.72	3252.68	3253.56	199.0
2013-03-26 01:00:00	NQ	Futures	3253.26	3254.72	3252.39	3254.43	254.0
2013-03-26 02:00:00	NQ	Futures	3254.43	3255.31	3252.1	3253.56	295.0
2013-03-26 03:00:00	NQ	Futures	3253.56	3259.97	3253.56	3258.51	2064.0
2013-03-26 04:00:00	NQ	Futures	3258.51	3261.72	3254.43	3259.39	3604.0
2013-03-26 05:00:00	NQ	Futures	3259.1	3259.68	3257.06	3259.68	1636.0
2013-03-26 06:00:00	NQ	Futures	3259.39	3260.56	3258.22	3259.1	1225.0
2013-03-26 07:00:00	NQ	Futures	3259.1	3260.56	3252.39	3252.68	2706.0
2013-03-26 08:00:00	NQ	Futures	3252.97	3257.64	3252.39	3255.89	4895.0
2013-03-26 09:00:00	NQ	Futures	3256.18	3267.56	3254.43	3263.47	27240.0
2013-03-26 10:00:00	NQ	Futures	3263.18	3266.97	3254.72	3259.68	42616.0
2013-03-26 11:00:00	NQ	Futures	3259.68	3265.22	3257.06	3259.39	19758.0
2013-03-26 12:00:00	NQ	Futures	3259.39	3262.01	3254.72	3257.35	13718.0
2013-03-26 13:00:00	NQ	Futures	3257.64	3265.51	3256.76	3262.89	12269.0
2013-03-26 14:00:00	NQ	Futures	3263.18	3266.39	3259.39	3261.72	10181.0
2013-03-26 15:00:00	NQ	Futures	3261.72	3268.14	3261.43	3266.39	17971.0
2013-03-26 16:00:00	NQ	Futures	3266.39	3269.31	3265.51	3269.01	5626.0
2013-03-26 17:00:00	NQ	Futures	3269.01	3271.06	3268.72	3270.18	459.0
2013-03-26 18:00:00	NQ	Futures	3269.31	3271.35	3267.85	3271.06	240.0
2013-03-26 19:00:00	NQ	Futures	3271.06	3271.35	3268.72	3269.31	177.0
2013-03-26 20:00:00	NQ	Futures	3269.31	3269.89	3268.14	3268.43	252.0
2013-03-26 21:00:00	NQ	Futures	3268.43	3270.76	3267.85	3270.47	155.0
2013-03-26 22:00:00	NQ	Futures	3270.47	3270.47	3267.56	3268.43	336.0
2013-03-26 23:00:00	NQ	Futures	3269.01	3270.47	3268.43	3269.89	229.0
2013-03-26 00:00:00	YM	Futures	14561.7	14567.7	14559.6	14563.7	237.0
2013-03-26 01:00:00	YM	Futures	14562.7	14566.7	14557.6	14564.7	277.0

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

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