PREVIEW / futures_1hour / 2012-12-26

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-26.parquet
  size:    32 KB
  rows:    918

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-12-26 06:00:00	ES	Futures	1461.54	1463.08	1457.69	1459.49	8769.0
2012-12-26 07:00:00	ES	Futures	1459.49	1461.03	1459.23	1460.52	2847.0
2012-12-26 08:00:00	ES	Futures	1460.52	1461.29	1458.98	1459.75	8008.0
2012-12-26 09:00:00	ES	Futures	1459.49	1462.31	1459.23	1460.0	58313.0
2012-12-26 10:00:00	ES	Futures	1460.26	1461.29	1454.87	1454.87	70631.0
2012-12-26 11:00:00	ES	Futures	1455.13	1455.38	1447.94	1451.28	119663.0
2012-12-26 12:00:00	ES	Futures	1451.28	1453.08	1449.48	1452.31	67356.0
2012-12-26 13:00:00	ES	Futures	1452.31	1452.82	1450.77	1451.54	45293.0
2012-12-26 14:00:00	ES	Futures	1451.54	1456.92	1451.54	1455.9	71490.0
2012-12-26 15:00:00	ES	Futures	1455.9	1456.15	1451.79	1452.31	86234.0
2012-12-26 16:00:00	ES	Futures	1452.31	1452.31	1449.74	1450.77	37800.0
2012-12-26 17:00:00	ES	Futures	1450.77	1450.77	1450.25	1450.25	820.0
2012-12-26 18:00:00	ES	Futures	1450.51	1451.28	1449.74	1451.02	2617.0
2012-12-26 19:00:00	ES	Futures	1450.77	1451.54	1450.25	1451.28	3185.0
2012-12-26 20:00:00	ES	Futures	1451.28	1452.82	1450.77	1451.02	3828.0
2012-12-26 21:00:00	ES	Futures	1451.02	1451.54	1449.74	1450.25	2425.0
2012-12-26 22:00:00	ES	Futures	1450.51	1450.77	1450.0	1450.25	2109.0
2012-12-26 23:00:00	ES	Futures	1450.25	1451.02	1448.2	1451.02	5524.0
2012-12-26 06:00:00	NQ	Futures	3089.41	3093.48	3086.21	3087.66	689.0
2012-12-26 07:00:00	NQ	Futures	3087.08	3090.57	3085.91	3089.99	414.0
2012-12-26 08:00:00	NQ	Futures	3090.28	3092.61	3088.53	3089.7	1369.0
2012-12-26 09:00:00	NQ	Futures	3089.7	3095.52	3086.79	3090.86	7777.0
2012-12-26 10:00:00	NQ	Futures	3091.44	3093.77	3071.07	3071.07	11281.0
2012-12-26 11:00:00	NQ	Futures	3071.36	3072.82	3052.73	3065.83	20549.0
2012-12-26 12:00:00	NQ	Futures	3065.83	3066.99	3057.1	3063.5	8762.0
2012-12-26 13:00:00	NQ	Futures	3063.21	3067.87	3060.3	3064.67	6516.0
2012-12-26 14:00:00	NQ	Futures	3064.67	3074.56	3064.67	3072.82	10842.0
2012-12-26 15:00:00	NQ	Futures	3072.53	3073.11	3062.05	3064.38	12067.0
2012-12-26 16:00:00	NQ	Futures	3064.08	3064.96	3060.59	3063.5	2517.0
2012-12-26 17:00:00	NQ	Futures	3063.21	3063.5	3062.34	3063.21	58.0
2012-12-26 18:00:00	NQ	Futures	3064.08	3065.83	3060.88	3064.08	478.0
2012-12-26 19:00:00	NQ	Futures	3063.79	3064.96	3062.05	3064.96	303.0
2012-12-26 20:00:00	NQ	Futures	3064.96	3066.99	3064.38	3065.25	443.0
2012-12-26 21:00:00	NQ	Futures	3064.96	3065.54	3062.63	3063.5	353.0
2012-12-26 22:00:00	NQ	Futures	3063.5	3064.08	3061.76	3062.05	193.0
2012-12-26 23:00:00	NQ	Futures	3061.76	3063.5	3059.14	3063.21	448.0
2012-12-26 06:00:00	YM	Futures	13172.9	13184.0	13152.8	13163.8	563.0
2012-12-26 07:00:00	YM	Futures	13164.8	13171.9	13156.8	13171.9	255.0
2012-12-26 08:00:00	YM	Futures	13170.9	13170.9	13159.8	13162.8	329.0
2012-12-26 09:00:00	YM	Futures	13162.8	13190.0	13160.8	13174.9	3760.0
2012-12-26 10:00:00	YM	Futures	13175.9	13181.9	13143.7	13144.7	4625.0
2012-12-26 11:00:00	YM	Futures	13143.7	13148.7	13089.4	13113.5	8940.0
2012-12-26 12:00:00	YM	Futures	13114.5	13126.6	13095.4	13119.6	4740.0
2012-12-26 13:00:00	YM	Futures	13120.6	13123.6	13106.5	13114.5	2063.0
2012-12-26 14:00:00	YM	Futures	13114.5	13164.8	13114.5	13152.8	5042.0
2012-12-26 15:00:00	YM	Futures	13152.8	13155.8	13122.6	13128.6	5939.0
2012-12-26 16:00:00	YM	Futures	13128.6	13133.7	13115.5	13122.6	1566.0
2012-12-26 17:00:00	YM	Futures	13123.6	13124.6	13119.6	13119.6	38.0
2012-12-26 18:00:00	YM	Futures	13128.6	13128.6	13119.6	13124.6	272.0
2012-12-26 19:00:00	YM	Futures	13123.6	13127.6	13119.6	13125.6	454.0

> showing 50 of 918 rows — these rows as CSV

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