PREVIEW / futures_1hour / 2012-03-16

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-16.parquet
  size:    41 KB
  rows:    1,198

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-03-16 00:00:00	ES	Futures	1411.4	1412.41	1411.4	1411.91	1633.0
2012-03-16 01:00:00	ES	Futures	1411.91	1412.41	1410.89	1411.15	3772.0
2012-03-16 02:00:00	ES	Futures	1411.15	1412.16	1410.89	1411.91	2028.0
2012-03-16 03:00:00	ES	Futures	1412.16	1412.41	1411.4	1411.91	4692.0
2012-03-16 04:00:00	ES	Futures	1411.91	1413.42	1411.65	1412.66	24008.0
2012-03-16 05:00:00	ES	Futures	1412.66	1413.42	1412.16	1412.92	14704.0
2012-03-16 06:00:00	ES	Futures	1412.66	1414.18	1412.66	1413.17	26745.0
2012-03-16 07:00:00	ES	Futures	1413.17	1416.21	1412.92	1415.95	48091.0
2012-03-16 08:00:00	ES	Futures	1415.7	1417.22	1414.69	1416.71	62551.0
2012-03-16 09:00:00	ES	Futures	1416.71	1416.97	1412.66	1413.42	274699.0
2012-03-16 10:00:00	ES	Futures	1413.68	1415.95	1412.16	1415.7	235044.0
2012-03-16 11:00:00	ES	Futures	1415.95	1416.46	1413.68	1415.7	153005.0
2012-03-16 12:00:00	ES	Futures	1415.7	1416.97	1414.69	1415.19	114749.0
2012-03-16 13:00:00	ES	Futures	1415.19	1415.95	1414.69	1415.45	63026.0
2012-03-16 14:00:00	ES	Futures	1415.7	1416.46	1415.45	1415.7	48983.0
2012-03-16 15:00:00	ES	Futures	1415.7	1416.21	1413.17	1415.19	162167.0
2012-03-16 16:00:00	ES	Futures	1415.19	1415.95	1413.93	1415.45	82657.0
2012-03-16 00:00:00	NQ	Futures	3135.51	3136.96	3135.22	3135.51	203.0
2012-03-16 01:00:00	NQ	Futures	3135.51	3136.09	3133.49	3134.36	214.0
2012-03-16 02:00:00	NQ	Futures	3134.36	3136.96	3133.78	3136.67	171.0
2012-03-16 03:00:00	NQ	Futures	3136.38	3136.67	3134.36	3136.09	505.0
2012-03-16 04:00:00	NQ	Futures	3136.09	3138.98	3135.51	3137.54	1436.0
2012-03-16 05:00:00	NQ	Futures	3137.54	3138.12	3135.8	3137.25	976.0
2012-03-16 06:00:00	NQ	Futures	3137.25	3140.72	3137.25	3138.98	2296.0
2012-03-16 07:00:00	NQ	Futures	3138.4	3145.35	3138.4	3144.77	3129.0
2012-03-16 08:00:00	NQ	Futures	3144.48	3146.5	3142.45	3145.35	6946.0
2012-03-16 09:00:00	NQ	Futures	3145.35	3145.35	3128.28	3133.49	45222.0
2012-03-16 10:00:00	NQ	Futures	3133.2	3141.3	3126.55	3138.98	38654.0
2012-03-16 11:00:00	NQ	Futures	3138.98	3141.01	3132.62	3138.69	20393.0
2012-03-16 12:00:00	NQ	Futures	3138.69	3139.27	3132.33	3133.78	15230.0
2012-03-16 13:00:00	NQ	Futures	3134.07	3136.96	3132.91	3135.51	8971.0
2012-03-16 14:00:00	NQ	Futures	3135.51	3138.12	3134.64	3134.93	10820.0
2012-03-16 15:00:00	NQ	Futures	3134.93	3134.93	3129.44	3133.49	24640.0
2012-03-16 16:00:00	NQ	Futures	3133.49	3136.38	3130.89	3136.38	5879.0
2012-03-16 00:00:00	YM	Futures	13119.3	13124.3	13119.3	13122.3	135.0
2012-03-16 01:00:00	YM	Futures	13122.3	13123.3	13113.3	13115.3	299.0
2012-03-16 02:00:00	YM	Futures	13115.3	13120.3	13113.3	13117.3	217.0
2012-03-16 03:00:00	YM	Futures	13117.3	13125.3	13115.3	13123.3	334.0
2012-03-16 04:00:00	YM	Futures	13123.3	13131.2	13119.3	13126.2	1122.0
2012-03-16 05:00:00	YM	Futures	13127.2	13131.2	13123.3	13127.2	714.0
2012-03-16 06:00:00	YM	Futures	13127.2	13137.2	13127.2	13132.2	1333.0
2012-03-16 07:00:00	YM	Futures	13131.2	13152.2	13131.2	13150.2	1842.0
2012-03-16 08:00:00	YM	Futures	13150.2	13166.1	13145.2	13159.1	3615.0
2012-03-16 09:00:00	YM	Futures	13158.1	13175.1	13131.2	13136.2	16601.0
2012-03-16 10:00:00	YM	Futures	13137.2	13149.2	13122.3	13148.2	12724.0
2012-03-16 11:00:00	YM	Futures	13148.2	13156.1	13129.2	13139.2	8020.0
2012-03-16 12:00:00	YM	Futures	13139.2	13147.2	13134.2	13137.2	5151.0
2012-03-16 13:00:00	YM	Futures	13138.2	13141.2	13132.2	13136.2	3836.0
2012-03-16 14:00:00	YM	Futures	13136.2	13145.2	13135.2	13141.2	3237.0
2012-03-16 15:00:00	YM	Futures	13141.2	13143.2	13115.3	13119.3	7912.0

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

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