PREVIEW / futures_1hour / 2012-09-17

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-17.parquet
  size:    46 KB
  rows:    1,432

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
2012-09-17 00:00:00	ES	Futures	1487.05	1487.31	1486.29	1486.54	1807.0
2012-09-17 01:00:00	ES	Futures	1486.8	1487.82	1486.54	1487.57	1252.0
2012-09-17 02:00:00	ES	Futures	1487.57	1487.82	1485.78	1485.78	4631.0
2012-09-17 03:00:00	ES	Futures	1485.78	1488.33	1485.78	1488.08	21935.0
2012-09-17 04:00:00	ES	Futures	1487.82	1488.84	1487.31	1488.59	14205.0
2012-09-17 05:00:00	ES	Futures	1488.59	1488.84	1486.8	1488.08	11507.0
2012-09-17 06:00:00	ES	Futures	1488.08	1488.84	1487.31	1488.84	7461.0
2012-09-17 07:00:00	ES	Futures	1488.59	1488.84	1486.03	1486.54	18093.0
2012-09-17 08:00:00	ES	Futures	1486.54	1489.61	1486.03	1488.84	37789.0
2012-09-17 09:00:00	ES	Futures	1488.84	1490.89	1486.54	1487.57	163186.0
2012-09-17 10:00:00	ES	Futures	1487.57	1490.12	1486.8	1488.59	161744.0
2012-09-17 11:00:00	ES	Futures	1488.59	1489.61	1487.31	1488.08	144388.0
2012-09-17 12:00:00	ES	Futures	1488.08	1488.84	1487.31	1487.57	64366.0
2012-09-17 13:00:00	ES	Futures	1487.57	1488.33	1485.78	1486.8	71908.0
2012-09-17 14:00:00	ES	Futures	1486.54	1487.05	1483.73	1484.76	114597.0
2012-09-17 15:00:00	ES	Futures	1484.76	1486.54	1482.2	1486.29	227242.0
2012-09-17 16:00:00	ES	Futures	1486.54	1486.8	1485.27	1486.03	65550.0
2012-09-17 17:00:00	ES	Futures	1486.03	1486.54	1485.27	1485.52	1469.0
2012-09-17 18:00:00	ES	Futures	1485.78	1486.54	1485.27	1486.54	1550.0
2012-09-17 19:00:00	ES	Futures	1486.54	1486.8	1485.78	1486.29	840.0
2012-09-17 20:00:00	ES	Futures	1486.29	1486.8	1484.5	1484.5	3418.0
2012-09-17 21:00:00	ES	Futures	1484.5	1486.54	1484.24	1486.54	4188.0
2012-09-17 22:00:00	ES	Futures	1486.29	1487.57	1486.29	1486.8	3574.0
2012-09-17 23:00:00	ES	Futures	1486.54	1487.82	1486.29	1487.05	2028.0
2012-09-17 00:00:00	NQ	Futures	3304.73	3305.6	3303.56	3303.85	237.0
2012-09-17 01:00:00	NQ	Futures	3304.14	3306.47	3303.85	3305.89	149.0
2012-09-17 02:00:00	NQ	Futures	3305.89	3306.47	3301.53	3301.82	580.0
2012-09-17 03:00:00	NQ	Futures	3302.11	3308.5	3301.53	3308.21	2337.0
2012-09-17 04:00:00	NQ	Futures	3307.92	3309.37	3306.76	3309.08	930.0
2012-09-17 05:00:00	NQ	Futures	3309.08	3309.96	3305.89	3309.08	623.0
2012-09-17 06:00:00	NQ	Futures	3308.79	3309.96	3307.63	3309.67	572.0
2012-09-17 07:00:00	NQ	Futures	3309.37	3309.96	3305.6	3306.47	1433.0
2012-09-17 08:00:00	NQ	Futures	3306.18	3313.73	3305.89	3312.57	3729.0
2012-09-17 09:00:00	NQ	Futures	3312.57	3315.48	3301.53	3302.69	25082.0
2012-09-17 10:00:00	NQ	Futures	3302.69	3312.57	3302.4	3308.79	23506.0
2012-09-17 11:00:00	NQ	Futures	3308.79	3310.83	3304.73	3307.92	19010.0
2012-09-17 12:00:00	NQ	Futures	3307.92	3310.54	3307.05	3307.63	8968.0
2012-09-17 13:00:00	NQ	Futures	3307.92	3308.79	3305.6	3306.76	9783.0
2012-09-17 14:00:00	NQ	Futures	3306.76	3309.37	3301.82	3306.18	15954.0
2012-09-17 15:00:00	NQ	Futures	3306.18	3312.57	3300.95	3312.57	26934.0
2012-09-17 16:00:00	NQ	Futures	3312.57	3313.44	3308.21	3309.67	7971.0
2012-09-17 17:00:00	NQ	Futures	3309.96	3310.54	3308.79	3308.79	151.0
2012-09-17 18:00:00	NQ	Futures	3309.08	3310.54	3308.21	3310.54	124.0
2012-09-17 19:00:00	NQ	Futures	3310.54	3310.83	3309.96	3310.83	139.0
2012-09-17 20:00:00	NQ	Futures	3310.83	3311.12	3307.34	3307.34	326.0
2012-09-17 21:00:00	NQ	Futures	3307.05	3311.12	3305.02	3311.12	745.0
2012-09-17 22:00:00	NQ	Futures	3311.41	3313.44	3311.12	3311.99	623.0
2012-09-17 23:00:00	NQ	Futures	3311.99	3314.31	3310.54	3312.28	288.0
2012-09-17 00:00:00	YM	Futures	13491.9	13496.9	13488.9	13491.9	240.0
2012-09-17 01:00:00	YM	Futures	13492.9	13500.9	13492.9	13499.9	145.0

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

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