PREVIEW / futures_1hour / 2013-03-19

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-19.parquet
  size:    51 KB
  rows:    1,545

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-19 00:00:00	ES	Futures	1595.48	1596.51	1594.96	1595.48	4225.0
2013-03-19 01:00:00	ES	Futures	1595.73	1596.25	1593.93	1594.45	5584.0
2013-03-19 02:00:00	ES	Futures	1594.19	1594.7	1592.9	1594.19	6781.0
2013-03-19 03:00:00	ES	Futures	1593.93	1595.73	1593.93	1594.7	6724.0
2013-03-19 04:00:00	ES	Futures	1594.45	1594.96	1592.9	1593.93	24454.0
2013-03-19 05:00:00	ES	Futures	1593.93	1595.22	1592.13	1592.9	26884.0
2013-03-19 06:00:00	ES	Futures	1592.9	1593.93	1592.13	1593.67	23629.0
2013-03-19 07:00:00	ES	Futures	1593.67	1595.99	1593.42	1595.99	21102.0
2013-03-19 08:00:00	ES	Futures	1595.99	1598.31	1595.73	1597.02	54493.0
2013-03-19 09:00:00	ES	Futures	1597.02	1598.05	1594.7	1597.28	174487.0
2013-03-19 10:00:00	ES	Futures	1597.28	1598.05	1590.33	1592.64	337465.0
2013-03-19 11:00:00	ES	Futures	1592.64	1594.45	1582.08	1583.63	357209.0
2013-03-19 12:00:00	ES	Futures	1583.63	1586.72	1580.8	1583.89	364578.0
2013-03-19 13:00:00	ES	Futures	1583.63	1584.92	1578.22	1582.08	287451.0
2013-03-19 14:00:00	ES	Futures	1581.83	1587.49	1580.8	1584.4	282373.0
2013-03-19 15:00:00	ES	Futures	1584.4	1591.36	1582.34	1589.04	445461.0
2013-03-19 16:00:00	ES	Futures	1589.04	1590.07	1586.46	1586.72	85922.0
2013-03-19 17:00:00	ES	Futures	1586.72	1587.23	1585.95	1586.2	4109.0
2013-03-19 18:00:00	ES	Futures	1585.95	1586.46	1583.63	1584.4	13742.0
2013-03-19 19:00:00	ES	Futures	1584.4	1585.43	1584.14	1585.43	4900.0
2013-03-19 20:00:00	ES	Futures	1585.43	1586.46	1583.11	1584.4	10626.0
2013-03-19 21:00:00	ES	Futures	1584.4	1586.2	1583.37	1585.95	3886.0
2013-03-19 22:00:00	ES	Futures	1585.95	1586.72	1584.92	1586.2	4159.0
2013-03-19 23:00:00	ES	Futures	1586.2	1587.49	1585.95	1586.98	3553.0
2013-03-19 00:00:00	NQ	Futures	3257.93	3258.81	3256.76	3257.64	132.0
2013-03-19 01:00:00	NQ	Futures	3257.35	3257.93	3253.26	3253.56	497.0
2013-03-19 02:00:00	NQ	Futures	3252.97	3253.56	3251.22	3251.81	401.0
2013-03-19 03:00:00	NQ	Futures	3251.51	3254.14	3250.06	3251.51	706.0
2013-03-19 04:00:00	NQ	Futures	3251.51	3252.97	3248.01	3251.22	2278.0
2013-03-19 05:00:00	NQ	Futures	3251.81	3253.56	3246.85	3248.89	1981.0
2013-03-19 06:00:00	NQ	Futures	3248.89	3251.51	3247.43	3250.64	1975.0
2013-03-19 07:00:00	NQ	Futures	3250.64	3256.18	3250.06	3255.6	1839.0
2013-03-19 08:00:00	NQ	Futures	3255.89	3263.47	3255.89	3261.72	8380.0
2013-03-19 09:00:00	NQ	Futures	3261.72	3264.64	3255.89	3263.76	25259.0
2013-03-19 10:00:00	NQ	Futures	3263.76	3266.68	3243.64	3248.6	41089.0
2013-03-19 11:00:00	NQ	Futures	3248.6	3255.89	3227.89	3230.81	36098.0
2013-03-19 12:00:00	NQ	Futures	3230.81	3236.35	3224.39	3229.93	34923.0
2013-03-19 13:00:00	NQ	Futures	3229.64	3232.85	3214.47	3224.1	38443.0
2013-03-19 14:00:00	NQ	Futures	3224.1	3236.35	3222.06	3230.22	29181.0
2013-03-19 15:00:00	NQ	Futures	3229.93	3245.68	3226.14	3244.22	49505.0
2013-03-19 16:00:00	NQ	Futures	3244.22	3248.31	3239.56	3240.14	6180.0
2013-03-19 17:00:00	NQ	Futures	3240.14	3240.72	3238.68	3238.97	134.0
2013-03-19 18:00:00	NQ	Futures	3239.56	3239.56	3235.18	3236.06	448.0
2013-03-19 19:00:00	NQ	Futures	3235.76	3237.81	3235.76	3237.22	157.0
2013-03-19 20:00:00	NQ	Futures	3237.51	3239.56	3233.72	3236.35	581.0
2013-03-19 21:00:00	NQ	Futures	3236.35	3239.85	3234.6	3239.26	276.0
2013-03-19 22:00:00	NQ	Futures	3239.26	3240.43	3238.1	3240.14	368.0
2013-03-19 23:00:00	NQ	Futures	3240.43	3242.47	3240.14	3241.6	221.0
2013-03-19 00:00:00	YM	Futures	14568.7	14575.8	14564.7	14569.7	449.0
2013-03-19 01:00:00	YM	Futures	14569.7	14572.8	14558.6	14559.6	445.0

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

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