PREVIEW / futures_1hour / 2012-12-06

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-06.parquet
  size:    47 KB
  rows:    1,478

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-12-06 00:00:00	ES	Futures	1435.45	1436.47	1434.68	1436.47	4002.0
2012-12-06 01:00:00	ES	Futures	1436.47	1436.73	1435.45	1436.22	2057.0
2012-12-06 02:00:00	ES	Futures	1436.47	1437.24	1435.2	1435.96	5431.0
2012-12-06 03:00:00	ES	Futures	1435.96	1439.03	1434.94	1438.77	25446.0
2012-12-06 04:00:00	ES	Futures	1439.03	1441.58	1438.52	1440.82	27126.0
2012-12-06 05:00:00	ES	Futures	1440.82	1441.07	1439.03	1439.79	11791.0
2012-12-06 06:00:00	ES	Futures	1439.79	1440.82	1436.47	1436.98	25004.0
2012-12-06 07:00:00	ES	Futures	1436.98	1439.03	1436.73	1438.26	24673.0
2012-12-06 08:00:00	ES	Futures	1438.26	1439.03	1434.68	1435.96	43742.0
2012-12-06 09:00:00	ES	Futures	1435.96	1441.07	1435.45	1438.52	216762.0
2012-12-06 10:00:00	ES	Futures	1438.26	1443.37	1435.45	1442.09	267020.0
2012-12-06 11:00:00	ES	Futures	1442.35	1444.14	1441.07	1441.84	166498.0
2012-12-06 12:00:00	ES	Futures	1442.09	1442.6	1438.52	1438.77	114796.0
2012-12-06 13:00:00	ES	Futures	1438.52	1442.86	1438.26	1442.35	78837.0
2012-12-06 14:00:00	ES	Futures	1442.6	1443.63	1440.82	1441.58	80121.0
2012-12-06 15:00:00	ES	Futures	1441.58	1444.39	1440.05	1443.37	169609.0
2012-12-06 16:00:00	ES	Futures	1443.37	1444.39	1442.6	1443.88	69621.0
2012-12-06 17:00:00	ES	Futures	1443.88	1444.39	1443.37	1443.63	2171.0
2012-12-06 18:00:00	ES	Futures	1443.11	1444.65	1442.6	1444.39	5125.0
2012-12-06 19:00:00	ES	Futures	1444.39	1445.41	1444.14	1444.65	5788.0
2012-12-06 20:00:00	ES	Futures	1444.9	1445.16	1444.14	1444.9	5437.0
2012-12-06 21:00:00	ES	Futures	1444.65	1444.9	1443.37	1444.39	4653.0
2012-12-06 22:00:00	ES	Futures	1444.39	1444.9	1443.88	1444.14	2090.0
2012-12-06 23:00:00	ES	Futures	1444.39	1444.39	1443.37	1444.39	1368.0
2012-12-06 00:00:00	NQ	Futures	3062.38	3063.26	3060.64	3063.26	524.0
2012-12-06 01:00:00	NQ	Futures	3063.26	3063.55	3060.93	3062.68	411.0
2012-12-06 02:00:00	NQ	Futures	3062.38	3064.13	3057.15	3059.19	1863.0
2012-12-06 03:00:00	NQ	Futures	3059.19	3065.0	3056.28	3064.13	5739.0
2012-12-06 04:00:00	NQ	Futures	3064.13	3069.94	3062.97	3067.91	4299.0
2012-12-06 05:00:00	NQ	Futures	3067.61	3068.78	3064.42	3067.32	1539.0
2012-12-06 06:00:00	NQ	Futures	3067.03	3069.36	3061.8	3062.97	2708.0
2012-12-06 07:00:00	NQ	Futures	3062.68	3066.16	3060.35	3062.38	2441.0
2012-12-06 08:00:00	NQ	Futures	3062.68	3064.42	3053.67	3057.15	7278.0
2012-12-06 09:00:00	NQ	Futures	3057.15	3073.72	3048.15	3066.16	56203.0
2012-12-06 10:00:00	NQ	Futures	3065.87	3089.12	3060.93	3087.37	70146.0
2012-12-06 11:00:00	NQ	Futures	3087.66	3094.06	3081.85	3088.83	35989.0
2012-12-06 12:00:00	NQ	Futures	3088.83	3091.44	3075.75	3077.49	24431.0
2012-12-06 13:00:00	NQ	Futures	3077.49	3089.7	3074.3	3089.41	19467.0
2012-12-06 14:00:00	NQ	Futures	3089.7	3090.28	3078.37	3080.98	20168.0
2012-12-06 15:00:00	NQ	Futures	3080.98	3089.12	3073.72	3085.34	33331.0
2012-12-06 16:00:00	NQ	Futures	3085.34	3087.96	3082.43	3085.92	6266.0
2012-12-06 17:00:00	NQ	Futures	3086.5	3087.08	3085.92	3086.5	45.0
2012-12-06 18:00:00	NQ	Futures	3085.92	3087.37	3085.05	3086.79	268.0
2012-12-06 19:00:00	NQ	Futures	3086.5	3087.96	3085.92	3087.08	319.0
2012-12-06 20:00:00	NQ	Futures	3086.79	3087.66	3085.34	3086.79	472.0
2012-12-06 21:00:00	NQ	Futures	3086.79	3087.37	3085.05	3086.79	401.0
2012-12-06 22:00:00	NQ	Futures	3086.5	3087.08	3085.63	3086.21	179.0
2012-12-06 23:00:00	NQ	Futures	3086.21	3086.5	3084.76	3086.21	123.0
2012-12-06 00:00:00	YM	Futures	13009.7	13012.7	13003.7	13010.7	424.0
2012-12-06 01:00:00	YM	Futures	13012.7	13016.7	13008.7	13014.7	268.0

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

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