PREVIEW / futures_1hour / 2013-04-09

all futures 1-hour files

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

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-09 00:00:00	ES	Futures	1608.61	1609.13	1607.84	1607.84	2597.0
2013-04-09 01:00:00	ES	Futures	1607.84	1608.87	1607.33	1607.84	4419.0
2013-04-09 02:00:00	ES	Futures	1607.58	1607.84	1606.3	1606.81	11105.0
2013-04-09 03:00:00	ES	Futures	1607.07	1608.36	1606.55	1607.58	28006.0
2013-04-09 04:00:00	ES	Futures	1607.33	1610.42	1607.33	1608.1	28986.0
2013-04-09 05:00:00	ES	Futures	1608.1	1609.39	1606.81	1607.84	21549.0
2013-04-09 06:00:00	ES	Futures	1608.1	1608.87	1607.07	1607.84	12400.0
2013-04-09 07:00:00	ES	Futures	1607.84	1609.9	1607.84	1608.87	16663.0
2013-04-09 08:00:00	ES	Futures	1608.61	1610.67	1608.36	1609.64	35003.0
2013-04-09 09:00:00	ES	Futures	1609.64	1610.42	1602.69	1603.46	225645.0
2013-04-09 10:00:00	ES	Futures	1603.46	1608.61	1603.2	1605.52	262264.0
2013-04-09 11:00:00	ES	Futures	1605.52	1608.1	1603.2	1608.1	151733.0
2013-04-09 12:00:00	ES	Futures	1608.1	1610.93	1606.81	1609.39	102438.0
2013-04-09 13:00:00	ES	Futures	1609.64	1615.31	1609.39	1613.51	204853.0
2013-04-09 14:00:00	ES	Futures	1613.51	1616.6	1612.99	1615.83	173015.0
2013-04-09 15:00:00	ES	Futures	1615.83	1616.6	1610.16	1610.67	244636.0
2013-04-09 16:00:00	ES	Futures	1610.67	1611.96	1610.16	1611.19	72372.0
2013-04-09 17:00:00	ES	Futures	1610.93	1611.45	1610.93	1610.93	1644.0
2013-04-09 18:00:00	ES	Futures	1611.19	1611.19	1609.64	1610.16	4177.0
2013-04-09 19:00:00	ES	Futures	1610.16	1610.67	1609.39	1609.39	1684.0
2013-04-09 20:00:00	ES	Futures	1609.39	1609.9	1608.87	1608.87	5354.0
2013-04-09 21:00:00	ES	Futures	1609.13	1609.9	1608.36	1609.39	8053.0
2013-04-09 22:00:00	ES	Futures	1609.39	1610.42	1609.39	1609.9	4019.0
2013-04-09 23:00:00	ES	Futures	1609.9	1610.16	1609.39	1609.64	1735.0
2013-04-09 00:00:00	NQ	Futures	3250.64	3251.81	3250.06	3250.06	169.0
2013-04-09 01:00:00	NQ	Futures	3250.06	3251.51	3248.6	3248.89	373.0
2013-04-09 02:00:00	NQ	Futures	3248.6	3249.18	3246.85	3248.31	664.0
2013-04-09 03:00:00	NQ	Futures	3248.31	3251.51	3248.01	3250.06	1908.0
2013-04-09 04:00:00	NQ	Futures	3250.35	3257.93	3250.06	3252.97	4485.0
2013-04-09 05:00:00	NQ	Futures	3252.68	3255.01	3249.76	3252.1	1712.0
2013-04-09 06:00:00	NQ	Futures	3252.1	3253.85	3251.22	3252.1	1161.0
2013-04-09 07:00:00	NQ	Futures	3252.39	3255.89	3252.39	3253.26	1474.0
2013-04-09 08:00:00	NQ	Futures	3253.56	3257.93	3251.81	3256.76	3431.0
2013-04-09 09:00:00	NQ	Futures	3257.06	3258.51	3237.81	3239.85	33264.0
2013-04-09 10:00:00	NQ	Futures	3239.56	3253.56	3238.68	3246.56	31635.0
2013-04-09 11:00:00	NQ	Futures	3246.56	3249.76	3235.18	3249.18	27512.0
2013-04-09 12:00:00	NQ	Futures	3249.18	3256.47	3246.56	3254.72	14750.0
2013-04-09 13:00:00	NQ	Futures	3255.01	3273.97	3254.72	3269.6	43446.0
2013-04-09 14:00:00	NQ	Futures	3269.89	3278.06	3268.43	3273.39	28203.0
2013-04-09 15:00:00	NQ	Futures	3273.68	3275.72	3262.89	3264.35	34853.0
2013-04-09 16:00:00	NQ	Futures	3264.06	3266.68	3262.89	3265.81	6262.0
2013-04-09 17:00:00	NQ	Futures	3266.1	3267.56	3266.1	3267.26	269.0
2013-04-09 18:00:00	NQ	Futures	3265.51	3265.81	3263.18	3263.76	532.0
2013-04-09 19:00:00	NQ	Futures	3263.76	3264.06	3263.18	3263.18	137.0
2013-04-09 20:00:00	NQ	Futures	3262.89	3263.18	3261.14	3261.43	458.0
2013-04-09 21:00:00	NQ	Futures	3261.43	3263.47	3260.56	3263.18	397.0
2013-04-09 22:00:00	NQ	Futures	3262.6	3264.35	3262.01	3264.06	224.0
2013-04-09 23:00:00	NQ	Futures	3264.06	3264.06	3263.47	3263.76	61.0
2013-04-09 00:00:00	YM	Futures	14735.5	14736.5	14728.5	14728.5	297.0
2013-04-09 01:00:00	YM	Futures	14728.5	14734.5	14722.4	14723.4	563.0

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

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