PREVIEW / futures_1hour / 2012-11-30

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-30.parquet
  size:    40 KB
  rows:    1,202

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-30 00:00:00	ES	Futures	1444.14	1444.39	1443.11	1444.14	3374.0
2012-11-30 01:00:00	ES	Futures	1444.14	1444.39	1443.37	1443.88	3042.0
2012-11-30 02:00:00	ES	Futures	1443.88	1445.67	1443.63	1445.16	6215.0
2012-11-30 03:00:00	ES	Futures	1445.16	1447.46	1444.65	1446.44	15189.0
2012-11-30 04:00:00	ES	Futures	1446.44	1447.46	1445.41	1445.92	14242.0
2012-11-30 05:00:00	ES	Futures	1445.92	1448.22	1445.92	1447.71	17518.0
2012-11-30 06:00:00	ES	Futures	1447.46	1450.52	1447.2	1448.48	27121.0
2012-11-30 07:00:00	ES	Futures	1448.73	1449.76	1447.46	1447.97	25776.0
2012-11-30 08:00:00	ES	Futures	1447.71	1447.97	1445.16	1446.44	44139.0
2012-11-30 09:00:00	ES	Futures	1446.44	1446.95	1443.37	1444.9	158181.0
2012-11-30 10:00:00	ES	Futures	1444.9	1447.46	1442.09	1444.65	248696.0
2012-11-30 11:00:00	ES	Futures	1444.39	1445.41	1440.82	1442.86	222584.0
2012-11-30 12:00:00	ES	Futures	1442.86	1444.39	1441.07	1442.35	120873.0
2012-11-30 13:00:00	ES	Futures	1442.6	1445.16	1442.09	1443.88	100255.0
2012-11-30 14:00:00	ES	Futures	1443.88	1445.92	1441.84	1441.84	119796.0
2012-11-30 15:00:00	ES	Futures	1441.84	1448.73	1440.82	1444.65	359844.0
2012-11-30 16:00:00	ES	Futures	1444.65	1446.44	1442.86	1445.67	147069.0
2012-11-30 17:00:00	ES	Futures	1445.92	1447.2	1445.67	1446.69	2697.0
2012-11-30 00:00:00	NQ	Futures	3113.24	3114.11	3112.07	3113.82	699.0
2012-11-30 01:00:00	NQ	Futures	3113.53	3114.98	3112.07	3113.53	446.0
2012-11-30 02:00:00	NQ	Futures	3113.53	3117.59	3112.94	3116.43	1206.0
2012-11-30 03:00:00	NQ	Futures	3116.43	3121.37	3114.98	3120.21	1818.0
2012-11-30 04:00:00	NQ	Futures	3119.92	3122.24	3118.18	3119.92	2044.0
2012-11-30 05:00:00	NQ	Futures	3119.63	3121.95	3118.76	3120.79	2250.0
2012-11-30 06:00:00	NQ	Futures	3120.79	3126.31	3120.5	3123.99	3153.0
2012-11-30 07:00:00	NQ	Futures	3123.99	3125.15	3121.08	3121.37	2879.0
2012-11-30 08:00:00	NQ	Futures	3121.37	3121.95	3115.27	3115.56	5713.0
2012-11-30 09:00:00	NQ	Futures	3115.27	3117.59	3107.42	3108.88	33056.0
2012-11-30 10:00:00	NQ	Futures	3108.88	3114.11	3105.1	3111.2	33794.0
2012-11-30 11:00:00	NQ	Futures	3110.91	3111.78	3100.16	3106.84	28698.0
2012-11-30 12:00:00	NQ	Futures	3107.13	3110.33	3102.77	3105.68	19431.0
2012-11-30 13:00:00	NQ	Futures	3105.68	3111.2	3104.52	3110.04	13185.0
2012-11-30 14:00:00	NQ	Futures	3110.04	3114.4	3104.23	3104.52	15000.0
2012-11-30 15:00:00	NQ	Futures	3104.52	3117.59	3101.9	3110.04	37768.0
2012-11-30 16:00:00	NQ	Futures	3110.33	3114.98	3108.01	3114.69	7528.0
2012-11-30 17:00:00	NQ	Futures	3114.4	3116.14	3114.11	3115.56	213.0
2012-11-30 00:00:00	YM	Futures	13007.7	13010.7	13002.7	13010.7	422.0
2012-11-30 01:00:00	YM	Futures	13009.7	13011.7	13005.7	13009.7	382.0
2012-11-30 02:00:00	YM	Futures	13009.7	13022.7	13004.7	13019.7	819.0
2012-11-30 03:00:00	YM	Futures	13019.7	13045.7	13015.7	13029.7	3198.0
2012-11-30 04:00:00	YM	Futures	13031.7	13040.7	13022.7	13029.7	921.0
2012-11-30 05:00:00	YM	Futures	13031.7	13048.7	13029.7	13045.7	2830.0
2012-11-30 06:00:00	YM	Futures	13046.7	13062.7	13042.7	13051.7	2432.0
2012-11-30 07:00:00	YM	Futures	13051.7	13057.7	13039.7	13039.7	1722.0
2012-11-30 08:00:00	YM	Futures	13040.7	13042.7	13022.7	13029.7	3713.0
2012-11-30 09:00:00	YM	Futures	13029.7	13038.7	13008.7	13025.7	14960.0
2012-11-30 10:00:00	YM	Futures	13025.7	13046.7	12989.7	13015.7	22901.0
2012-11-30 11:00:00	YM	Futures	13014.7	13021.7	12979.7	12994.7	14453.0
2012-11-30 12:00:00	YM	Futures	12995.7	13006.7	12980.7	12991.7	8046.0
2012-11-30 13:00:00	YM	Futures	12992.7	13012.7	12989.7	13002.7	6323.0

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

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