PREVIEW / futures_1hour / 2012-09-11

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-11.parquet
  size:    44 KB
  rows:    1,367

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-11 00:00:00	ES	Futures	1446.87	1447.64	1446.11	1446.36	4044.0
2012-09-11 01:00:00	ES	Futures	1446.62	1448.4	1446.11	1448.14	5941.0
2012-09-11 02:00:00	ES	Futures	1448.4	1453.74	1448.14	1453.23	26185.0
2012-09-11 03:00:00	ES	Futures	1453.23	1455.77	1452.98	1453.99	46766.0
2012-09-11 04:00:00	ES	Futures	1453.99	1455.01	1452.47	1453.99	20769.0
2012-09-11 05:00:00	ES	Futures	1453.99	1455.26	1452.72	1454.5	19910.0
2012-09-11 06:00:00	ES	Futures	1454.25	1454.76	1452.47	1454.25	18311.0
2012-09-11 07:00:00	ES	Futures	1454.5	1456.79	1454.25	1455.26	34325.0
2012-09-11 08:00:00	ES	Futures	1455.26	1457.04	1453.74	1455.01	53686.0
2012-09-11 09:00:00	ES	Futures	1455.01	1459.08	1453.48	1458.06	199675.0
2012-09-11 10:00:00	ES	Futures	1458.32	1459.84	1457.04	1459.33	179341.0
2012-09-11 11:00:00	ES	Futures	1459.33	1462.13	1459.08	1459.59	153649.0
2012-09-11 12:00:00	ES	Futures	1459.84	1460.1	1458.06	1459.33	75437.0
2012-09-11 13:00:00	ES	Futures	1459.33	1461.11	1458.32	1459.84	85151.0
2012-09-11 14:00:00	ES	Futures	1459.84	1460.35	1456.79	1457.81	83706.0
2012-09-11 15:00:00	ES	Futures	1457.55	1458.57	1456.03	1456.79	136089.0
2012-09-11 16:00:00	ES	Futures	1456.79	1457.3	1454.25	1454.76	65825.0
2012-09-11 17:00:00	ES	Futures	1454.5	1454.76	1453.99	1454.25	2626.0
2012-09-11 18:00:00	ES	Futures	1454.5	1454.76	1452.98	1453.48	4220.0
2012-09-11 19:00:00	ES	Futures	1453.48	1454.5	1452.98	1454.25	2354.0
2012-09-11 20:00:00	ES	Futures	1454.25	1457.04	1453.48	1455.77	7141.0
2012-09-11 21:00:00	ES	Futures	1455.77	1457.55	1455.52	1456.54	6467.0
2012-09-11 22:00:00	ES	Futures	1456.79	1458.32	1456.54	1457.55	3919.0
2012-09-11 23:00:00	ES	Futures	1457.55	1457.81	1456.54	1456.79	3268.0
2012-09-11 00:00:00	NQ	Futures	3222.94	3223.81	3221.2	3222.07	386.0
2012-09-11 01:00:00	NQ	Futures	3222.07	3226.42	3221.78	3226.13	400.0
2012-09-11 02:00:00	NQ	Futures	3226.42	3236.86	3226.13	3236.57	1822.0
2012-09-11 03:00:00	NQ	Futures	3236.57	3240.91	3233.96	3236.28	2957.0
2012-09-11 04:00:00	NQ	Futures	3235.99	3237.15	3231.06	3233.38	1444.0
2012-09-11 05:00:00	NQ	Futures	3233.96	3235.99	3231.06	3234.54	958.0
2012-09-11 06:00:00	NQ	Futures	3234.54	3235.41	3229.61	3235.12	1296.0
2012-09-11 07:00:00	NQ	Futures	3235.12	3240.62	3235.12	3237.73	2527.0
2012-09-11 08:00:00	NQ	Futures	3237.44	3241.49	3234.83	3237.73	5532.0
2012-09-11 09:00:00	NQ	Futures	3238.02	3245.26	3228.45	3241.2	31050.0
2012-09-11 10:00:00	NQ	Futures	3241.2	3243.81	3229.61	3240.91	27058.0
2012-09-11 11:00:00	NQ	Futures	3240.91	3246.42	3237.44	3238.59	16617.0
2012-09-11 12:00:00	NQ	Futures	3238.59	3243.23	3232.51	3236.57	11928.0
2012-09-11 13:00:00	NQ	Futures	3236.57	3243.52	3233.96	3238.88	11291.0
2012-09-11 14:00:00	NQ	Futures	3238.59	3240.62	3226.42	3229.32	17567.0
2012-09-11 15:00:00	NQ	Futures	3229.32	3233.09	3222.94	3228.74	22680.0
2012-09-11 16:00:00	NQ	Futures	3229.03	3229.61	3221.78	3223.81	6888.0
2012-09-11 17:00:00	NQ	Futures	3223.81	3224.1	3222.94	3223.52	115.0
2012-09-11 18:00:00	NQ	Futures	3224.39	3224.68	3220.91	3221.49	583.0
2012-09-11 19:00:00	NQ	Futures	3221.49	3224.1	3220.91	3223.52	181.0
2012-09-11 20:00:00	NQ	Futures	3223.52	3229.9	3222.94	3226.42	734.0
2012-09-11 21:00:00	NQ	Futures	3226.42	3231.06	3226.42	3229.03	989.0
2012-09-11 22:00:00	NQ	Futures	3229.03	3234.54	3228.74	3232.8	936.0
2012-09-11 23:00:00	NQ	Futures	3232.8	3233.96	3230.77	3230.77	278.0
2012-09-11 00:00:00	YM	Futures	13137.8	13138.8	13128.8	13128.8	7.0
2012-09-11 01:00:00	YM	Futures	13131.8	13140.8	13131.8	13140.8	4.0

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

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