PREVIEW / futures_1hour / 2013-04-29

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-29.parquet
  size:    49 KB
  rows:    1,508

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-29 00:00:00	ES	Futures	1623.81	1624.07	1623.3	1623.55	747.0
2013-04-29 01:00:00	ES	Futures	1623.55	1624.84	1623.04	1624.58	1972.0
2013-04-29 02:00:00	ES	Futures	1624.58	1626.65	1624.33	1625.87	7750.0
2013-04-29 03:00:00	ES	Futures	1625.61	1629.99	1625.61	1628.71	27106.0
2013-04-29 04:00:00	ES	Futures	1628.71	1630.25	1628.19	1629.48	18170.0
2013-04-29 05:00:00	ES	Futures	1629.74	1629.99	1627.93	1628.45	9270.0
2013-04-29 06:00:00	ES	Futures	1628.19	1629.22	1627.68	1628.45	15206.0
2013-04-29 07:00:00	ES	Futures	1628.45	1630.51	1628.19	1629.99	19276.0
2013-04-29 08:00:00	ES	Futures	1629.99	1631.28	1628.96	1629.22	32649.0
2013-04-29 09:00:00	ES	Futures	1629.22	1631.8	1627.42	1630.51	164792.0
2013-04-29 10:00:00	ES	Futures	1630.51	1635.92	1629.74	1634.89	231289.0
2013-04-29 11:00:00	ES	Futures	1635.15	1635.4	1633.6	1635.15	100793.0
2013-04-29 12:00:00	ES	Futures	1635.4	1639.27	1634.89	1637.21	163828.0
2013-04-29 13:00:00	ES	Futures	1637.46	1640.04	1636.95	1639.52	85833.0
2013-04-29 14:00:00	ES	Futures	1639.27	1640.55	1638.75	1639.52	77545.0
2013-04-29 15:00:00	ES	Futures	1639.52	1639.78	1635.4	1636.95	185419.0
2013-04-29 16:00:00	ES	Futures	1636.69	1637.72	1635.4	1637.46	64611.0
2013-04-29 17:00:00	ES	Futures	1637.46	1637.46	1636.95	1637.21	1681.0
2013-04-29 18:00:00	ES	Futures	1636.69	1636.95	1635.66	1635.92	4013.0
2013-04-29 19:00:00	ES	Futures	1635.66	1635.92	1635.15	1635.66	2399.0
2013-04-29 20:00:00	ES	Futures	1635.66	1635.66	1634.63	1635.15	3289.0
2013-04-29 21:00:00	ES	Futures	1635.15	1635.92	1635.15	1635.66	2229.0
2013-04-29 22:00:00	ES	Futures	1635.66	1635.92	1634.63	1635.66	2550.0
2013-04-29 23:00:00	ES	Futures	1635.66	1635.92	1634.63	1635.4	2208.0
2013-04-29 00:00:00	NQ	Futures	3304.89	3305.47	3304.01	3304.6	110.0
2013-04-29 01:00:00	NQ	Futures	3304.6	3306.93	3304.01	3306.93	163.0
2013-04-29 02:00:00	NQ	Futures	3306.64	3310.72	3306.35	3309.27	476.0
2013-04-29 03:00:00	NQ	Futures	3308.97	3314.52	3308.97	3312.18	2536.0
2013-04-29 04:00:00	NQ	Futures	3312.47	3315.39	3311.02	3314.81	1333.0
2013-04-29 05:00:00	NQ	Futures	3314.81	3314.81	3311.31	3311.89	1248.0
2013-04-29 06:00:00	NQ	Futures	3311.89	3315.39	3311.02	3314.52	2097.0
2013-04-29 07:00:00	NQ	Futures	3314.22	3317.14	3313.06	3315.68	2567.0
2013-04-29 08:00:00	NQ	Futures	3315.39	3317.72	3313.93	3313.93	3793.0
2013-04-29 09:00:00	NQ	Futures	3313.93	3329.97	3313.93	3326.77	33185.0
2013-04-29 10:00:00	NQ	Futures	3326.18	3343.97	3325.02	3339.02	40400.0
2013-04-29 11:00:00	NQ	Futures	3339.31	3341.35	3336.1	3341.06	18228.0
2013-04-29 12:00:00	NQ	Futures	3341.06	3350.39	3339.6	3344.85	19764.0
2013-04-29 13:00:00	NQ	Futures	3344.85	3348.93	3343.1	3346.02	9512.0
2013-04-29 14:00:00	NQ	Futures	3346.02	3348.64	3344.85	3346.6	8873.0
2013-04-29 15:00:00	NQ	Futures	3346.31	3346.89	3336.39	3337.27	22398.0
2013-04-29 16:00:00	NQ	Futures	3336.97	3338.43	3334.06	3338.14	6059.0
2013-04-29 17:00:00	NQ	Futures	3337.56	3337.56	3336.39	3336.68	111.0
2013-04-29 18:00:00	NQ	Futures	3336.39	3336.68	3334.06	3334.06	605.0
2013-04-29 19:00:00	NQ	Futures	3334.06	3335.22	3333.47	3334.35	322.0
2013-04-29 20:00:00	NQ	Futures	3334.35	3335.81	3333.47	3334.93	455.0
2013-04-29 21:00:00	NQ	Futures	3335.52	3336.68	3335.22	3336.68	341.0
2013-04-29 22:00:00	NQ	Futures	3336.68	3336.97	3334.06	3336.39	379.0
2013-04-29 23:00:00	NQ	Futures	3336.39	3336.39	3334.93	3336.1	196.0
2013-04-29 00:00:00	YM	Futures	14808.3	14810.3	14805.3	14806.3	101.0
2013-04-29 01:00:00	YM	Futures	14807.3	14814.4	14802.3	14814.4	366.0

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

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