PREVIEW / futures_1hour / 2012-10-22

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-22.parquet
  size:    47 KB
  rows:    1,455

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-10-22 00:00:00	ES	Futures	1455.89	1459.98	1455.89	1459.72	8435.0
2012-10-22 01:00:00	ES	Futures	1459.72	1460.23	1458.95	1459.21	4586.0
2012-10-22 02:00:00	ES	Futures	1459.21	1460.74	1458.95	1460.23	9685.0
2012-10-22 03:00:00	ES	Futures	1460.23	1460.49	1455.63	1459.21	41477.0
2012-10-22 04:00:00	ES	Futures	1459.21	1460.74	1457.42	1460.23	20696.0
2012-10-22 05:00:00	ES	Futures	1460.23	1462.53	1460.23	1461.0	22248.0
2012-10-22 06:00:00	ES	Futures	1461.0	1462.02	1459.98	1460.49	15658.0
2012-10-22 07:00:00	ES	Futures	1460.49	1461.51	1458.19	1458.44	41444.0
2012-10-22 08:00:00	ES	Futures	1458.44	1459.46	1456.4	1457.16	40143.0
2012-10-22 09:00:00	ES	Futures	1457.16	1459.98	1455.38	1458.44	205124.0
2012-10-22 10:00:00	ES	Futures	1458.44	1462.02	1456.4	1457.68	231069.0
2012-10-22 11:00:00	ES	Futures	1457.68	1458.7	1453.33	1457.16	258572.0
2012-10-22 12:00:00	ES	Futures	1457.16	1457.93	1454.35	1454.87	104094.0
2012-10-22 13:00:00	ES	Futures	1454.87	1455.89	1447.71	1450.27	232623.0
2012-10-22 14:00:00	ES	Futures	1450.27	1452.82	1449.5	1450.27	132999.0
2012-10-22 15:00:00	ES	Futures	1450.27	1461.0	1448.73	1459.46	285170.0
2012-10-22 16:00:00	ES	Futures	1459.46	1463.81	1459.21	1463.55	85138.0
2012-10-22 17:00:00	ES	Futures	1463.3	1463.81	1462.79	1463.04	2191.0
2012-10-22 18:00:00	ES	Futures	1463.3	1463.3	1462.27	1462.53	2876.0
2012-10-22 19:00:00	ES	Futures	1462.53	1464.57	1462.02	1464.06	7123.0
2012-10-22 20:00:00	ES	Futures	1464.06	1464.06	1461.0	1461.0	9305.0
2012-10-22 21:00:00	ES	Futures	1461.0	1461.76	1460.23	1460.49	6608.0
2012-10-22 22:00:00	ES	Futures	1460.49	1461.51	1460.23	1461.25	2749.0
2012-10-22 23:00:00	ES	Futures	1461.25	1461.25	1459.46	1460.23	5506.0
2012-10-22 00:00:00	NQ	Futures	3103.94	3112.65	3103.94	3112.07	951.0
2012-10-22 01:00:00	NQ	Futures	3112.36	3114.4	3110.62	3111.2	829.0
2012-10-22 02:00:00	NQ	Futures	3111.2	3113.82	3110.91	3112.36	1210.0
2012-10-22 03:00:00	NQ	Futures	3112.36	3113.53	3104.23	3112.36	4532.0
2012-10-22 04:00:00	NQ	Futures	3112.36	3114.69	3107.42	3113.24	1745.0
2012-10-22 05:00:00	NQ	Futures	3113.53	3118.47	3113.53	3114.98	2789.0
2012-10-22 06:00:00	NQ	Futures	3114.69	3117.01	3113.24	3113.82	1458.0
2012-10-22 07:00:00	NQ	Futures	3113.53	3116.43	3108.88	3109.46	3743.0
2012-10-22 08:00:00	NQ	Futures	3109.75	3112.07	3104.52	3105.1	5181.0
2012-10-22 09:00:00	NQ	Futures	3105.1	3115.27	3101.9	3112.94	42625.0
2012-10-22 10:00:00	NQ	Futures	3112.94	3122.53	3108.01	3109.75	51208.0
2012-10-22 11:00:00	NQ	Futures	3109.75	3117.88	3103.07	3114.4	33241.0
2012-10-22 12:00:00	NQ	Futures	3114.4	3116.43	3108.59	3111.78	18124.0
2012-10-22 13:00:00	NQ	Futures	3111.78	3114.4	3097.25	3104.23	30621.0
2012-10-22 14:00:00	NQ	Futures	3104.23	3112.36	3102.48	3107.13	21430.0
2012-10-22 15:00:00	NQ	Futures	3107.13	3129.51	3103.65	3122.53	41971.0
2012-10-22 16:00:00	NQ	Futures	3122.53	3131.25	3121.08	3130.09	10610.0
2012-10-22 17:00:00	NQ	Futures	3130.09	3130.67	3129.51	3129.8	195.0
2012-10-22 18:00:00	NQ	Futures	3129.8	3130.09	3128.64	3129.8	366.0
2012-10-22 19:00:00	NQ	Futures	3129.22	3132.7	3128.35	3131.83	673.0
2012-10-22 20:00:00	NQ	Futures	3131.83	3131.83	3125.73	3126.02	766.0
2012-10-22 21:00:00	NQ	Futures	3126.02	3127.47	3124.57	3125.15	914.0
2012-10-22 22:00:00	NQ	Futures	3125.15	3125.73	3123.7	3124.57	765.0
2012-10-22 23:00:00	NQ	Futures	3124.28	3124.28	3120.79	3121.95	535.0
2012-10-22 00:00:00	YM	Futures	13269.8	13295.8	13268.8	13295.8	588.0
2012-10-22 01:00:00	YM	Futures	13295.8	13299.8	13289.8	13291.8	371.0

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

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