PREVIEW / futures_1hour / 2012-12-21

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-21.parquet
  size:    41 KB
  rows:    1,231

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-21 00:00:00	ES	Futures	1455.9	1456.15	1454.87	1455.38	17934.0
2012-12-21 01:00:00	ES	Futures	1455.13	1457.95	1454.87	1457.18	22652.0
2012-12-21 02:00:00	ES	Futures	1457.18	1461.03	1456.41	1459.75	31864.0
2012-12-21 03:00:00	ES	Futures	1459.49	1462.31	1458.21	1458.46	51448.0
2012-12-21 04:00:00	ES	Futures	1458.21	1459.49	1456.92	1457.44	34388.0
2012-12-21 05:00:00	ES	Futures	1457.44	1457.44	1454.1	1456.92	53684.0
2012-12-21 06:00:00	ES	Futures	1457.18	1460.26	1456.92	1459.23	59834.0
2012-12-21 07:00:00	ES	Futures	1459.49	1461.29	1458.21	1459.23	51616.0
2012-12-21 08:00:00	ES	Futures	1459.23	1460.26	1455.13	1456.15	138876.0
2012-12-21 09:00:00	ES	Futures	1456.15	1462.06	1453.33	1460.77	600290.0
2012-12-21 10:00:00	ES	Futures	1460.52	1465.9	1458.72	1461.03	613812.0
2012-12-21 11:00:00	ES	Futures	1461.03	1462.06	1453.85	1457.18	458692.0
2012-12-21 12:00:00	ES	Futures	1457.18	1458.46	1454.1	1457.44	282910.0
2012-12-21 13:00:00	ES	Futures	1457.69	1461.29	1455.38	1460.77	285850.0
2012-12-21 14:00:00	ES	Futures	1460.77	1462.57	1458.98	1460.26	201551.0
2012-12-21 15:00:00	ES	Futures	1460.26	1465.14	1458.98	1462.83	552710.0
2012-12-21 16:00:00	ES	Futures	1462.83	1466.16	1462.31	1465.14	249052.0
2012-12-21 17:00:00	ES	Futures	1465.39	1466.16	1464.62	1466.16	3766.0
2012-12-21 00:00:00	NQ	Futures	3082.71	3084.17	3081.55	3083.29	1554.0
2012-12-21 01:00:00	NQ	Futures	3083.0	3090.57	3082.71	3089.99	2784.0
2012-12-21 02:00:00	NQ	Futures	3089.41	3094.65	3084.17	3091.74	3982.0
2012-12-21 03:00:00	NQ	Futures	3091.74	3097.85	3086.5	3087.66	6060.0
2012-12-21 04:00:00	NQ	Futures	3087.66	3090.86	3084.17	3085.62	4270.0
2012-12-21 05:00:00	NQ	Futures	3085.62	3088.53	3082.13	3087.08	4652.0
2012-12-21 06:00:00	NQ	Futures	3086.79	3092.03	3086.79	3091.15	4226.0
2012-12-21 07:00:00	NQ	Futures	3091.15	3094.36	3087.95	3090.86	5032.0
2012-12-21 08:00:00	NQ	Futures	3091.15	3093.19	3077.18	3084.46	20270.0
2012-12-21 09:00:00	NQ	Futures	3084.46	3088.83	3069.32	3087.37	91440.0
2012-12-21 10:00:00	NQ	Futures	3087.37	3101.34	3082.42	3091.44	76688.0
2012-12-21 11:00:00	NQ	Futures	3091.74	3095.23	3076.89	3085.04	51436.0
2012-12-21 12:00:00	NQ	Futures	3084.75	3087.08	3076.6	3085.04	41048.0
2012-12-21 13:00:00	NQ	Futures	3085.04	3092.03	3078.93	3088.24	31698.0
2012-12-21 14:00:00	NQ	Futures	3088.53	3091.74	3084.75	3088.83	18273.0
2012-12-21 15:00:00	NQ	Futures	3088.53	3098.43	3085.62	3096.39	55326.0
2012-12-21 16:00:00	NQ	Futures	3096.39	3103.96	3095.52	3103.09	15926.0
2012-12-21 17:00:00	NQ	Futures	3102.8	3104.25	3102.21	3104.25	144.0
2012-12-21 00:00:00	YM	Futures	13149.8	13155.8	13147.7	13152.8	1060.0
2012-12-21 01:00:00	YM	Futures	13150.8	13183.0	13149.8	13177.9	1942.0
2012-12-21 02:00:00	YM	Futures	13176.9	13190.0	13169.9	13181.9	3078.0
2012-12-21 03:00:00	YM	Futures	13180.9	13201.1	13170.9	13173.9	3832.0
2012-12-21 04:00:00	YM	Futures	13172.9	13179.9	13158.8	13162.8	2686.0
2012-12-21 05:00:00	YM	Futures	13162.8	13171.9	13144.7	13165.8	4586.0
2012-12-21 06:00:00	YM	Futures	13165.8	13185.0	13162.8	13184.0	3904.0
2012-12-21 07:00:00	YM	Futures	13183.0	13192.0	13175.9	13179.9	3758.0
2012-12-21 08:00:00	YM	Futures	13179.9	13183.0	13148.7	13149.8	7766.0
2012-12-21 09:00:00	YM	Futures	13151.8	13219.2	13123.6	13207.1	44820.0
2012-12-21 10:00:00	YM	Futures	13207.1	13244.3	13191.0	13195.0	39416.0
2012-12-21 11:00:00	YM	Futures	13196.0	13205.1	13134.7	13166.9	30822.0
2012-12-21 12:00:00	YM	Futures	13165.8	13175.9	13137.7	13167.9	19380.0
2012-12-21 13:00:00	YM	Futures	13167.9	13199.0	13153.8	13186.0	18780.0

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

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