PREVIEW / futures_1hour / 2013-01-18

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-18.parquet
  size:    42 KB
  rows:    1,259

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-01-18 00:00:00	ES	Futures	1513.89	1515.43	1513.63	1515.17	5052.0
2013-01-18 01:00:00	ES	Futures	1515.17	1515.94	1514.66	1515.94	3806.0
2013-01-18 02:00:00	ES	Futures	1515.68	1516.97	1515.43	1516.71	11800.0
2013-01-18 03:00:00	ES	Futures	1516.71	1516.97	1514.91	1515.43	24688.0
2013-01-18 04:00:00	ES	Futures	1515.17	1515.94	1514.4	1515.17	18602.0
2013-01-18 05:00:00	ES	Futures	1514.91	1516.2	1514.14	1515.43	17904.0
2013-01-18 06:00:00	ES	Futures	1515.43	1516.2	1514.14	1514.66	19884.0
2013-01-18 07:00:00	ES	Futures	1514.4	1515.94	1513.12	1514.66	30484.0
2013-01-18 08:00:00	ES	Futures	1514.66	1516.45	1513.89	1515.17	41568.0
2013-01-18 09:00:00	ES	Futures	1515.17	1516.2	1511.83	1513.89	217752.0
2013-01-18 10:00:00	ES	Futures	1513.63	1514.66	1511.58	1511.83	155471.0
2013-01-18 11:00:00	ES	Futures	1512.09	1513.12	1509.27	1510.3	265247.0
2013-01-18 12:00:00	ES	Futures	1510.55	1513.63	1510.3	1513.12	94945.0
2013-01-18 13:00:00	ES	Futures	1513.37	1515.94	1513.12	1514.91	100040.0
2013-01-18 14:00:00	ES	Futures	1514.91	1516.45	1514.4	1515.17	63539.0
2013-01-18 15:00:00	ES	Futures	1515.43	1520.05	1514.66	1518.51	244091.0
2013-01-18 16:00:00	ES	Futures	1518.51	1519.28	1516.71	1518.25	97918.0
2013-01-18 17:00:00	ES	Futures	1518.25	1519.02	1517.99	1518.76	1535.0
2013-01-18 00:00:00	NQ	Futures	3184.88	3188.08	3184.3	3187.79	414.0
2013-01-18 01:00:00	NQ	Futures	3188.08	3188.66	3186.92	3188.66	214.0
2013-01-18 02:00:00	NQ	Futures	3188.66	3192.15	3188.37	3191.57	1294.0
2013-01-18 03:00:00	NQ	Futures	3191.28	3191.28	3186.04	3186.62	3349.0
2013-01-18 04:00:00	NQ	Futures	3186.33	3187.5	3182.84	3184.3	1947.0
2013-01-18 05:00:00	NQ	Futures	3184.59	3187.79	3184.0	3185.46	1412.0
2013-01-18 06:00:00	NQ	Futures	3185.46	3187.5	3180.51	3181.39	2445.0
2013-01-18 07:00:00	NQ	Futures	3181.39	3183.71	3177.89	3181.97	5795.0
2013-01-18 08:00:00	NQ	Futures	3182.26	3184.0	3180.22	3181.97	4406.0
2013-01-18 09:00:00	NQ	Futures	3181.97	3187.5	3174.98	3184.59	36511.0
2013-01-18 10:00:00	NQ	Futures	3184.59	3185.75	3175.27	3176.44	22308.0
2013-01-18 11:00:00	NQ	Futures	3176.44	3177.31	3169.74	3170.91	28119.0
2013-01-18 12:00:00	NQ	Futures	3170.91	3178.18	3170.32	3177.02	11039.0
2013-01-18 13:00:00	NQ	Futures	3176.73	3181.68	3176.73	3180.22	11280.0
2013-01-18 14:00:00	NQ	Futures	3180.22	3181.09	3178.18	3179.06	7842.0
2013-01-18 15:00:00	NQ	Futures	3179.35	3187.79	3177.02	3185.75	23218.0
2013-01-18 16:00:00	NQ	Futures	3186.04	3186.33	3182.55	3183.71	6786.0
2013-01-18 17:00:00	NQ	Futures	3183.71	3185.46	3183.13	3185.46	69.0
2013-01-18 00:00:00	YM	Futures	13615.5	13629.6	13612.5	13627.6	602.0
2013-01-18 01:00:00	YM	Futures	13626.6	13629.6	13623.6	13628.6	252.0
2013-01-18 02:00:00	YM	Futures	13629.6	13639.7	13626.6	13638.7	904.0
2013-01-18 03:00:00	YM	Futures	13637.7	13639.7	13624.6	13627.6	1857.0
2013-01-18 04:00:00	YM	Futures	13627.6	13630.6	13619.6	13625.6	1169.0
2013-01-18 05:00:00	YM	Futures	13624.6	13634.7	13620.6	13629.6	1278.0
2013-01-18 06:00:00	YM	Futures	13629.6	13637.7	13620.6	13625.6	2116.0
2013-01-18 07:00:00	YM	Futures	13624.6	13634.7	13616.5	13625.6	2455.0
2013-01-18 08:00:00	YM	Futures	13625.6	13634.7	13620.6	13631.6	2916.0
2013-01-18 09:00:00	YM	Futures	13630.6	13637.7	13613.5	13630.6	13713.0
2013-01-18 10:00:00	YM	Futures	13630.6	13634.7	13610.5	13612.5	10416.0
2013-01-18 11:00:00	YM	Futures	13612.5	13623.6	13595.4	13600.5	13986.0
2013-01-18 12:00:00	YM	Futures	13600.5	13619.6	13596.4	13617.6	6925.0
2013-01-18 13:00:00	YM	Futures	13617.6	13630.6	13617.6	13622.6	6799.0

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

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