PREVIEW / futures_1hour / 2012-11-06

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-06.parquet
  size:    49 KB
  rows:    1,523

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-11-06 00:00:00	ES	Futures	1444.14	1445.41	1443.63	1444.14	3622.0
2012-11-06 01:00:00	ES	Futures	1444.14	1444.9	1443.88	1444.39	2084.0
2012-11-06 02:00:00	ES	Futures	1444.39	1444.9	1443.11	1443.11	3699.0
2012-11-06 03:00:00	ES	Futures	1443.11	1444.39	1441.58	1442.6	21905.0
2012-11-06 04:00:00	ES	Futures	1442.35	1446.69	1442.35	1446.44	19975.0
2012-11-06 05:00:00	ES	Futures	1446.69	1448.48	1446.18	1447.71	21498.0
2012-11-06 06:00:00	ES	Futures	1447.46	1448.48	1446.18	1447.97	13728.0
2012-11-06 07:00:00	ES	Futures	1448.22	1448.73	1445.67	1445.92	18680.0
2012-11-06 08:00:00	ES	Futures	1445.92	1448.22	1444.14	1447.71	38525.0
2012-11-06 09:00:00	ES	Futures	1447.71	1450.52	1445.92	1450.27	179824.0
2012-11-06 10:00:00	ES	Futures	1450.52	1451.03	1446.18	1448.99	163250.0
2012-11-06 11:00:00	ES	Futures	1448.99	1457.68	1448.48	1456.91	234582.0
2012-11-06 12:00:00	ES	Futures	1456.91	1460.49	1455.38	1456.91	226772.0
2012-11-06 13:00:00	ES	Futures	1456.65	1458.95	1455.89	1457.16	103663.0
2012-11-06 14:00:00	ES	Futures	1457.16	1458.7	1454.61	1455.89	81830.0
2012-11-06 15:00:00	ES	Futures	1455.89	1456.14	1452.82	1454.1	239046.0
2012-11-06 16:00:00	ES	Futures	1454.1	1457.68	1453.33	1456.91	86616.0
2012-11-06 17:00:00	ES	Futures	1456.65	1457.16	1455.63	1455.89	2039.0
2012-11-06 18:00:00	ES	Futures	1456.14	1456.91	1453.59	1454.61	8251.0
2012-11-06 19:00:00	ES	Futures	1454.61	1454.61	1450.27	1451.29	13972.0
2012-11-06 20:00:00	ES	Futures	1451.29	1451.29	1447.97	1449.76	15563.0
2012-11-06 21:00:00	ES	Futures	1449.76	1453.08	1443.37	1443.63	34332.0
2012-11-06 22:00:00	ES	Futures	1443.37	1445.92	1441.84	1443.63	24730.0
2012-11-06 23:00:00	ES	Futures	1443.88	1450.78	1443.37	1447.2	41225.0
2012-11-06 00:00:00	NQ	Futures	3096.96	3099.58	3096.38	3097.83	535.0
2012-11-06 01:00:00	NQ	Futures	3097.83	3097.83	3096.38	3097.25	297.0
2012-11-06 02:00:00	NQ	Futures	3097.54	3098.71	3095.51	3095.8	673.0
2012-11-06 03:00:00	NQ	Futures	3095.51	3097.54	3092.9	3093.19	2131.0
2012-11-06 04:00:00	NQ	Futures	3093.19	3108.01	3093.19	3107.71	2946.0
2012-11-06 05:00:00	NQ	Futures	3108.01	3111.49	3106.26	3109.17	2586.0
2012-11-06 06:00:00	NQ	Futures	3109.17	3111.49	3106.26	3110.04	1762.0
2012-11-06 07:00:00	NQ	Futures	3110.04	3110.91	3104.52	3105.39	1897.0
2012-11-06 08:00:00	NQ	Futures	3105.39	3110.04	3102.19	3108.01	4278.0
2012-11-06 09:00:00	NQ	Futures	3108.3	3108.88	3096.96	3103.65	35494.0
2012-11-06 10:00:00	NQ	Futures	3103.65	3105.68	3094.64	3102.77	44132.0
2012-11-06 11:00:00	NQ	Futures	3102.77	3120.5	3100.74	3119.34	31099.0
2012-11-06 12:00:00	NQ	Futures	3119.05	3128.64	3115.56	3119.05	33820.0
2012-11-06 13:00:00	NQ	Futures	3118.76	3121.37	3114.4	3115.56	30243.0
2012-11-06 14:00:00	NQ	Futures	3115.27	3118.76	3106.26	3110.91	16548.0
2012-11-06 15:00:00	NQ	Futures	3110.62	3111.78	3103.36	3108.01	29641.0
2012-11-06 16:00:00	NQ	Futures	3108.3	3114.11	3107.42	3112.07	4782.0
2012-11-06 17:00:00	NQ	Futures	3112.65	3112.94	3109.46	3110.33	439.0
2012-11-06 18:00:00	NQ	Futures	3110.33	3112.07	3105.68	3108.01	442.0
2012-11-06 19:00:00	NQ	Futures	3107.71	3107.71	3101.61	3103.94	1178.0
2012-11-06 20:00:00	NQ	Futures	3103.65	3103.65	3097.25	3101.03	1597.0
2012-11-06 21:00:00	NQ	Futures	3101.32	3108.88	3088.83	3088.83	3206.0
2012-11-06 22:00:00	NQ	Futures	3088.54	3092.6	3084.47	3088.54	2283.0
2012-11-06 23:00:00	NQ	Futures	3088.54	3102.77	3088.25	3096.67	6397.0
2012-11-06 00:00:00	YM	Futures	13072.7	13081.7	13066.7	13073.7	369.0
2012-11-06 01:00:00	YM	Futures	13073.7	13078.7	13071.7	13075.7	201.0

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

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