PREVIEW / futures_1hour / 2013-04-04

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-04.parquet
  size:    52 KB
  rows:    1,572

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-04 00:00:00	ES	Futures	1594.96	1598.83	1594.7	1598.83	16209.0
2013-04-04 01:00:00	ES	Futures	1598.83	1599.6	1597.02	1599.6	12106.0
2013-04-04 02:00:00	ES	Futures	1599.6	1601.4	1599.34	1600.63	18002.0
2013-04-04 03:00:00	ES	Futures	1600.89	1601.66	1597.8	1600.37	37787.0
2013-04-04 04:00:00	ES	Futures	1600.37	1602.69	1598.83	1602.17	29407.0
2013-04-04 05:00:00	ES	Futures	1601.92	1603.72	1601.4	1602.95	21559.0
2013-04-04 06:00:00	ES	Futures	1602.69	1602.95	1600.63	1601.66	27167.0
2013-04-04 07:00:00	ES	Futures	1601.66	1603.2	1600.89	1601.66	39900.0
2013-04-04 08:00:00	ES	Futures	1601.4	1601.66	1594.19	1596.25	168872.0
2013-04-04 09:00:00	ES	Futures	1595.99	1603.2	1595.48	1601.92	298444.0
2013-04-04 10:00:00	ES	Futures	1601.92	1604.75	1595.73	1599.86	441567.0
2013-04-04 11:00:00	ES	Futures	1600.11	1602.43	1597.8	1598.05	182677.0
2013-04-04 12:00:00	ES	Futures	1598.05	1598.31	1595.22	1597.02	151419.0
2013-04-04 13:00:00	ES	Futures	1597.02	1599.86	1593.67	1598.83	164190.0
2013-04-04 14:00:00	ES	Futures	1598.83	1601.66	1597.8	1599.08	116189.0
2013-04-04 15:00:00	ES	Futures	1599.08	1602.43	1598.05	1601.66	157435.0
2013-04-04 16:00:00	ES	Futures	1601.4	1602.95	1600.37	1600.63	72585.0
2013-04-04 17:00:00	ES	Futures	1600.37	1602.17	1600.37	1601.66	3081.0
2013-04-04 18:00:00	ES	Futures	1601.92	1602.43	1601.4	1601.92	3123.0
2013-04-04 19:00:00	ES	Futures	1601.66	1601.92	1600.11	1600.89	2836.0
2013-04-04 20:00:00	ES	Futures	1600.89	1601.66	1598.05	1599.08	9232.0
2013-04-04 21:00:00	ES	Futures	1599.08	1599.86	1598.31	1599.08	3880.0
2013-04-04 22:00:00	ES	Futures	1599.08	1600.11	1598.83	1599.08	3419.0
2013-04-04 23:00:00	ES	Futures	1599.08	1599.6	1598.05	1598.57	4827.0
2013-04-04 00:00:00	NQ	Futures	3250.35	3257.06	3250.06	3256.76	1842.0
2013-04-04 01:00:00	NQ	Futures	3256.76	3258.22	3254.72	3257.93	893.0
2013-04-04 02:00:00	NQ	Futures	3258.51	3262.01	3258.22	3261.14	1158.0
2013-04-04 03:00:00	NQ	Futures	3261.14	3263.18	3255.6	3260.26	4118.0
2013-04-04 04:00:00	NQ	Futures	3260.26	3263.18	3256.47	3262.6	2272.0
2013-04-04 05:00:00	NQ	Futures	3262.6	3268.43	3261.14	3266.97	3022.0
2013-04-04 06:00:00	NQ	Futures	3267.26	3267.26	3262.31	3264.35	2760.0
2013-04-04 07:00:00	NQ	Futures	3264.93	3266.1	3262.89	3262.89	2822.0
2013-04-04 08:00:00	NQ	Futures	3262.89	3262.89	3247.72	3250.93	14114.0
2013-04-04 09:00:00	NQ	Futures	3250.93	3257.35	3245.1	3254.43	34934.0
2013-04-04 10:00:00	NQ	Futures	3254.14	3260.56	3241.01	3244.22	46076.0
2013-04-04 11:00:00	NQ	Futures	3244.51	3251.51	3244.22	3245.68	19971.0
2013-04-04 12:00:00	NQ	Futures	3245.68	3247.43	3234.6	3244.22	31058.0
2013-04-04 13:00:00	NQ	Futures	3244.22	3251.81	3238.39	3250.35	16579.0
2013-04-04 14:00:00	NQ	Futures	3250.06	3254.14	3246.26	3246.85	13306.0
2013-04-04 15:00:00	NQ	Futures	3246.56	3254.14	3244.81	3253.26	20747.0
2013-04-04 16:00:00	NQ	Futures	3252.68	3255.89	3246.56	3247.72	7710.0
2013-04-04 17:00:00	NQ	Futures	3247.72	3249.76	3247.43	3249.18	418.0
2013-04-04 18:00:00	NQ	Futures	3249.18	3249.76	3247.72	3248.01	460.0
2013-04-04 19:00:00	NQ	Futures	3248.01	3248.31	3245.39	3245.97	246.0
2013-04-04 20:00:00	NQ	Futures	3246.56	3247.43	3242.47	3243.93	602.0
2013-04-04 21:00:00	NQ	Futures	3243.93	3245.39	3242.76	3243.93	651.0
2013-04-04 22:00:00	NQ	Futures	3243.93	3245.68	3243.64	3244.51	292.0
2013-04-04 23:00:00	NQ	Futures	3244.51	3245.1	3242.47	3243.35	384.0
2013-04-04 00:00:00	YM	Futures	14643.5	14675.9	14642.5	14673.9	2364.0
2013-04-04 01:00:00	YM	Futures	14675.9	14686.0	14664.8	14685.0	1174.0

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

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