PREVIEW / futures_1hour / 2013-03-27

all futures 1-hour files

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

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-27 00:00:00	ES	Futures	1605.52	1605.78	1605.01	1605.52	1136.0
2013-03-27 01:00:00	ES	Futures	1605.52	1606.55	1605.27	1605.78	2642.0
2013-03-27 02:00:00	ES	Futures	1605.78	1606.55	1605.27	1606.04	3190.0
2013-03-27 03:00:00	ES	Futures	1606.04	1607.84	1605.52	1606.55	13468.0
2013-03-27 04:00:00	ES	Futures	1606.55	1606.81	1603.98	1605.78	39777.0
2013-03-27 05:00:00	ES	Futures	1605.52	1606.3	1600.37	1600.63	45997.0
2013-03-27 06:00:00	ES	Futures	1600.37	1602.17	1597.54	1598.83	51415.0
2013-03-27 07:00:00	ES	Futures	1598.83	1598.83	1595.73	1596.51	56325.0
2013-03-27 08:00:00	ES	Futures	1596.77	1598.83	1594.96	1596.77	61681.0
2013-03-27 09:00:00	ES	Futures	1597.02	1598.05	1592.64	1595.73	226768.0
2013-03-27 10:00:00	ES	Futures	1595.48	1600.11	1593.67	1598.83	285378.0
2013-03-27 11:00:00	ES	Futures	1598.83	1602.69	1597.8	1601.14	166872.0
2013-03-27 12:00:00	ES	Futures	1601.14	1602.43	1600.11	1601.14	122645.0
2013-03-27 13:00:00	ES	Futures	1600.89	1602.69	1598.83	1602.43	106225.0
2013-03-27 14:00:00	ES	Futures	1602.43	1604.49	1601.92	1603.72	117082.0
2013-03-27 15:00:00	ES	Futures	1603.72	1605.52	1602.43	1604.49	182992.0
2013-03-27 16:00:00	ES	Futures	1604.49	1605.01	1602.69	1604.24	63392.0
2013-03-27 17:00:00	ES	Futures	1604.24	1604.75	1603.98	1603.98	2496.0
2013-03-27 18:00:00	ES	Futures	1603.98	1604.75	1602.69	1603.46	4524.0
2013-03-27 19:00:00	ES	Futures	1603.46	1603.72	1602.43	1602.69	2058.0
2013-03-27 20:00:00	ES	Futures	1602.69	1602.95	1602.17	1602.43	3246.0
2013-03-27 21:00:00	ES	Futures	1602.43	1602.43	1598.31	1599.08	13134.0
2013-03-27 22:00:00	ES	Futures	1599.08	1599.86	1598.31	1598.31	4733.0
2013-03-27 23:00:00	ES	Futures	1598.31	1598.31	1597.02	1597.8	10797.0
2013-03-27 00:00:00	NQ	Futures	3270.18	3271.06	3269.89	3269.89	96.0
2013-03-27 01:00:00	NQ	Futures	3269.89	3272.22	3269.89	3270.76	164.0
2013-03-27 02:00:00	NQ	Futures	3270.76	3271.64	3270.18	3271.35	128.0
2013-03-27 03:00:00	NQ	Futures	3271.35	3273.68	3269.6	3271.35	841.0
2013-03-27 04:00:00	NQ	Futures	3271.64	3272.81	3267.26	3270.76	2523.0
2013-03-27 05:00:00	NQ	Futures	3270.76	3271.64	3259.68	3259.97	2683.0
2013-03-27 06:00:00	NQ	Futures	3260.26	3263.18	3255.01	3257.64	4240.0
2013-03-27 07:00:00	NQ	Futures	3257.93	3257.93	3249.18	3250.93	3840.0
2013-03-27 08:00:00	NQ	Futures	3251.22	3255.31	3248.01	3250.93	7054.0
2013-03-27 09:00:00	NQ	Futures	3250.93	3254.14	3239.26	3249.18	30954.0
2013-03-27 10:00:00	NQ	Futures	3248.89	3262.31	3241.6	3258.51	40764.0
2013-03-27 11:00:00	NQ	Futures	3258.51	3266.1	3255.89	3262.6	19497.0
2013-03-27 12:00:00	NQ	Futures	3262.89	3264.35	3258.22	3260.85	14730.0
2013-03-27 13:00:00	NQ	Futures	3260.85	3265.51	3257.64	3265.51	10784.0
2013-03-27 14:00:00	NQ	Futures	3265.51	3271.35	3264.35	3269.01	14097.0
2013-03-27 15:00:00	NQ	Futures	3269.01	3273.68	3266.97	3271.93	25911.0
2013-03-27 16:00:00	NQ	Futures	3271.93	3273.1	3267.56	3269.31	5881.0
2013-03-27 17:00:00	NQ	Futures	3269.31	3269.89	3269.01	3269.01	134.0
2013-03-27 18:00:00	NQ	Futures	3268.14	3269.31	3266.68	3267.85	354.0
2013-03-27 19:00:00	NQ	Futures	3267.85	3267.85	3266.1	3266.39	205.0
2013-03-27 20:00:00	NQ	Futures	3266.1	3266.68	3265.51	3266.1	267.0
2013-03-27 21:00:00	NQ	Futures	3266.1	3266.1	3259.97	3260.85	830.0
2013-03-27 22:00:00	NQ	Futures	3260.56	3262.31	3259.68	3259.97	331.0
2013-03-27 23:00:00	NQ	Futures	3259.68	3259.68	3256.76	3258.81	941.0
2013-03-27 00:00:00	YM	Futures	14638.5	14641.5	14636.5	14638.5	145.0
2013-03-27 01:00:00	YM	Futures	14638.5	14647.6	14637.5	14640.5	414.0

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

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