PREVIEW / futures_1hour / 2012-09-07

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-07.parquet
  size:    40 KB
  rows:    1,170

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-07 00:00:00	ES	Futures	1456.54	1457.04	1455.77	1456.54	3719.0
2012-09-07 01:00:00	ES	Futures	1456.54	1456.79	1455.77	1456.28	4470.0
2012-09-07 02:00:00	ES	Futures	1456.54	1458.57	1456.28	1457.3	12469.0
2012-09-07 03:00:00	ES	Futures	1457.3	1461.37	1456.79	1459.33	53485.0
2012-09-07 04:00:00	ES	Futures	1459.08	1460.6	1458.82	1459.59	26706.0
2012-09-07 05:00:00	ES	Futures	1459.59	1460.86	1458.82	1460.6	17611.0
2012-09-07 06:00:00	ES	Futures	1460.6	1461.62	1460.35	1460.6	21348.0
2012-09-07 07:00:00	ES	Futures	1460.35	1462.13	1459.84	1461.62	41390.0
2012-09-07 08:00:00	ES	Futures	1461.62	1462.38	1455.77	1458.32	202616.0
2012-09-07 09:00:00	ES	Futures	1458.32	1461.37	1456.79	1458.82	271943.0
2012-09-07 10:00:00	ES	Futures	1458.57	1461.11	1457.3	1459.84	205529.0
2012-09-07 11:00:00	ES	Futures	1459.84	1460.6	1458.06	1459.59	137995.0
2012-09-07 12:00:00	ES	Futures	1459.84	1460.86	1458.82	1460.6	64844.0
2012-09-07 13:00:00	ES	Futures	1460.6	1460.86	1459.08	1459.08	71023.0
2012-09-07 14:00:00	ES	Futures	1459.33	1461.37	1459.08	1460.35	63563.0
2012-09-07 15:00:00	ES	Futures	1460.1	1461.62	1459.08	1461.62	132640.0
2012-09-07 16:00:00	ES	Futures	1461.37	1463.4	1461.37	1462.89	80686.0
2012-09-07 00:00:00	NQ	Futures	3278.02	3278.89	3276.86	3278.6	349.0
2012-09-07 01:00:00	NQ	Futures	3278.31	3279.18	3277.15	3277.73	285.0
2012-09-07 02:00:00	NQ	Futures	3278.02	3283.53	3277.73	3280.34	1190.0
2012-09-07 03:00:00	NQ	Futures	3280.34	3288.45	3280.05	3283.82	4651.0
2012-09-07 04:00:00	NQ	Futures	3283.53	3285.85	3282.95	3284.11	2741.0
2012-09-07 05:00:00	NQ	Futures	3283.82	3286.72	3282.66	3285.56	1493.0
2012-09-07 06:00:00	NQ	Futures	3285.85	3288.74	3285.56	3285.56	1999.0
2012-09-07 07:00:00	NQ	Futures	3285.56	3288.17	3284.69	3286.43	3426.0
2012-09-07 08:00:00	NQ	Futures	3286.14	3286.43	3272.8	3276.28	23442.0
2012-09-07 09:00:00	NQ	Futures	3275.99	3279.18	3266.42	3271.64	46072.0
2012-09-07 10:00:00	NQ	Futures	3271.64	3280.92	3269.32	3274.83	31495.0
2012-09-07 11:00:00	NQ	Futures	3274.83	3275.7	3269.9	3272.51	17425.0
2012-09-07 12:00:00	NQ	Futures	3272.51	3275.7	3269.61	3274.25	9321.0
2012-09-07 13:00:00	NQ	Futures	3274.54	3276.57	3269.9	3270.19	11139.0
2012-09-07 14:00:00	NQ	Futures	3270.19	3276.57	3270.19	3273.67	8087.0
2012-09-07 15:00:00	NQ	Futures	3273.67	3275.41	3270.19	3274.25	19167.0
2012-09-07 16:00:00	NQ	Futures	3274.25	3275.99	3273.09	3274.25	6098.0
2012-09-07 00:00:00	YM	Futures	13208.7	13211.6	13204.7	13209.6	261.0
2012-09-07 01:00:00	YM	Futures	13209.6	13213.6	13204.7	13206.7	260.0
2012-09-07 02:00:00	YM	Futures	13209.6	13224.6	13207.7	13213.6	746.0
2012-09-07 03:00:00	YM	Futures	13212.6	13246.4	13211.6	13230.5	4415.0
2012-09-07 04:00:00	YM	Futures	13229.5	13238.5	13226.5	13231.5	1553.0
2012-09-07 05:00:00	YM	Futures	13230.5	13239.5	13227.5	13237.5	858.0
2012-09-07 06:00:00	YM	Futures	13238.5	13244.4	13236.5	13236.5	1254.0
2012-09-07 07:00:00	YM	Futures	13237.5	13247.4	13230.5	13245.4	2317.0
2012-09-07 08:00:00	YM	Futures	13245.4	13249.4	13198.7	13217.6	13000.0
2012-09-07 09:00:00	YM	Futures	13216.6	13237.5	13204.7	13214.6	22333.0
2012-09-07 10:00:00	YM	Futures	13214.6	13228.5	13198.7	13214.6	15239.0
2012-09-07 11:00:00	YM	Futures	13213.6	13213.6	13193.7	13204.7	9794.0
2012-09-07 12:00:00	YM	Futures	13204.7	13208.7	13194.7	13205.7	4110.0
2012-09-07 13:00:00	YM	Futures	13206.7	13208.7	13191.7	13192.7	4213.0
2012-09-07 14:00:00	YM	Futures	13191.7	13208.7	13188.8	13200.7	4306.0
2012-09-07 15:00:00	YM	Futures	13201.7	13224.6	13196.7	13224.6	8716.0

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

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