PREVIEW / futures_1hour / 2013-04-15

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-15.parquet
  size:    53 KB
  rows:    1,553

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-15 00:00:00	ES	Futures	1623.55	1625.1	1621.24	1623.81	7899.0
2013-04-15 01:00:00	ES	Futures	1624.07	1625.36	1623.55	1624.07	4611.0
2013-04-15 02:00:00	ES	Futures	1624.07	1625.61	1622.01	1624.84	10144.0
2013-04-15 03:00:00	ES	Futures	1624.84	1626.9	1623.81	1624.07	27122.0
2013-04-15 04:00:00	ES	Futures	1624.33	1624.33	1619.43	1622.01	48725.0
2013-04-15 05:00:00	ES	Futures	1622.27	1624.33	1619.69	1620.98	27090.0
2013-04-15 06:00:00	ES	Futures	1620.72	1622.78	1619.43	1620.72	27619.0
2013-04-15 07:00:00	ES	Futures	1620.98	1623.04	1619.95	1623.04	21776.0
2013-04-15 08:00:00	ES	Futures	1623.04	1625.61	1622.52	1623.81	54861.0
2013-04-15 09:00:00	ES	Futures	1623.55	1625.1	1619.43	1623.3	241195.0
2013-04-15 10:00:00	ES	Futures	1623.3	1623.81	1617.89	1622.78	387170.0
2013-04-15 11:00:00	ES	Futures	1622.78	1622.78	1614.02	1615.31	277604.0
2013-04-15 12:00:00	ES	Futures	1615.05	1616.08	1606.04	1609.13	309824.0
2013-04-15 13:00:00	ES	Futures	1608.87	1610.67	1607.58	1607.84	157478.0
2013-04-15 14:00:00	ES	Futures	1608.1	1610.67	1602.17	1602.95	341138.0
2013-04-15 15:00:00	ES	Futures	1602.95	1605.78	1593.42	1593.67	645635.0
2013-04-15 16:00:00	ES	Futures	1593.67	1597.02	1585.43	1588.78	185346.0
2013-04-15 17:00:00	ES	Futures	1589.04	1590.07	1587.75	1589.55	6808.0
2013-04-15 18:00:00	ES	Futures	1589.3	1593.42	1589.04	1593.16	20246.0
2013-04-15 19:00:00	ES	Futures	1593.16	1595.48	1593.16	1594.96	11212.0
2013-04-15 20:00:00	ES	Futures	1594.7	1596.77	1592.9	1594.7	15146.0
2013-04-15 21:00:00	ES	Futures	1594.7	1597.8	1594.7	1595.99	13589.0
2013-04-15 22:00:00	ES	Futures	1595.99	1596.77	1595.22	1596.25	5989.0
2013-04-15 23:00:00	ES	Futures	1596.51	1599.6	1595.48	1598.57	10233.0
2013-04-15 00:00:00	NQ	Futures	3308.97	3312.77	3305.18	3312.18	1086.0
2013-04-15 01:00:00	NQ	Futures	3312.18	3314.52	3310.72	3311.31	284.0
2013-04-15 02:00:00	NQ	Futures	3311.31	3315.1	3306.35	3313.64	645.0
2013-04-15 03:00:00	NQ	Futures	3313.35	3319.18	3310.72	3313.64	2683.0
2013-04-15 04:00:00	NQ	Futures	3313.64	3313.64	3302.85	3307.81	3466.0
2013-04-15 05:00:00	NQ	Futures	3308.1	3313.06	3303.14	3305.18	2007.0
2013-04-15 06:00:00	NQ	Futures	3305.18	3308.68	3302.85	3304.31	2353.0
2013-04-15 07:00:00	NQ	Futures	3304.31	3308.1	3302.85	3307.81	2123.0
2013-04-15 08:00:00	NQ	Futures	3307.81	3313.06	3306.93	3310.43	4263.0
2013-04-15 09:00:00	NQ	Futures	3310.43	3318.02	3304.01	3311.31	34587.0
2013-04-15 10:00:00	NQ	Futures	3311.6	3315.97	3298.76	3312.47	41589.0
2013-04-15 11:00:00	NQ	Futures	3312.77	3313.64	3292.35	3294.39	34876.0
2013-04-15 12:00:00	NQ	Futures	3294.39	3297.6	3275.72	3282.43	37177.0
2013-04-15 13:00:00	NQ	Futures	3282.43	3287.1	3279.81	3281.26	14820.0
2013-04-15 14:00:00	NQ	Futures	3281.26	3287.1	3267.26	3269.01	40165.0
2013-04-15 15:00:00	NQ	Futures	3269.31	3272.22	3254.72	3257.64	79606.0
2013-04-15 16:00:00	NQ	Futures	3257.93	3264.06	3233.14	3248.89	18919.0
2013-04-15 17:00:00	NQ	Futures	3248.89	3251.51	3246.26	3250.64	325.0
2013-04-15 18:00:00	NQ	Futures	3250.35	3258.51	3249.47	3257.06	1379.0
2013-04-15 19:00:00	NQ	Futures	3257.35	3261.72	3257.35	3260.26	980.0
2013-04-15 20:00:00	NQ	Futures	3260.26	3264.35	3256.76	3261.14	1977.0
2013-04-15 21:00:00	NQ	Futures	3260.85	3267.85	3260.26	3264.64	2269.0
2013-04-15 22:00:00	NQ	Futures	3264.64	3266.39	3262.6	3265.51	529.0
2013-04-15 23:00:00	NQ	Futures	3265.51	3273.39	3264.06	3270.47	1288.0
2013-04-15 00:00:00	YM	Futures	14901.3	14913.5	14881.1	14908.4	1561.0
2013-04-15 01:00:00	YM	Futures	14909.4	14920.5	14903.4	14908.4	866.0

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

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