PREVIEW / futures_1hour / 2012-11-29

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-29.parquet
  size:    47 KB
  rows:    1,485

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-29 00:00:00	ES	Futures	1439.79	1444.9	1439.79	1442.6	19614.0
2012-11-29 01:00:00	ES	Futures	1442.6	1443.37	1440.56	1441.84	8022.0
2012-11-29 02:00:00	ES	Futures	1441.84	1443.37	1440.82	1443.11	9965.0
2012-11-29 03:00:00	ES	Futures	1443.11	1447.71	1441.33	1447.2	38700.0
2012-11-29 04:00:00	ES	Futures	1446.95	1447.46	1445.92	1446.69	20387.0
2012-11-29 05:00:00	ES	Futures	1446.44	1446.95	1445.16	1445.92	21269.0
2012-11-29 06:00:00	ES	Futures	1445.92	1447.71	1445.67	1446.44	15318.0
2012-11-29 07:00:00	ES	Futures	1446.69	1447.46	1445.16	1446.95	30558.0
2012-11-29 08:00:00	ES	Futures	1446.95	1446.95	1443.88	1443.88	58693.0
2012-11-29 09:00:00	ES	Futures	1443.63	1448.48	1443.11	1447.71	205752.0
2012-11-29 10:00:00	ES	Futures	1447.71	1449.5	1441.33	1446.18	345186.0
2012-11-29 11:00:00	ES	Futures	1445.92	1447.71	1437.75	1441.07	403355.0
2012-11-29 12:00:00	ES	Futures	1441.33	1445.67	1439.54	1443.88	187047.0
2012-11-29 13:00:00	ES	Futures	1443.88	1448.22	1442.86	1446.69	98515.0
2012-11-29 14:00:00	ES	Futures	1446.69	1447.97	1445.67	1446.69	75045.0
2012-11-29 15:00:00	ES	Futures	1446.44	1447.2	1442.09	1445.67	226912.0
2012-11-29 16:00:00	ES	Futures	1445.67	1447.2	1445.41	1445.67	70778.0
2012-11-29 17:00:00	ES	Futures	1445.41	1445.67	1442.09	1443.11	7660.0
2012-11-29 18:00:00	ES	Futures	1442.35	1443.11	1440.56	1442.6	11166.0
2012-11-29 19:00:00	ES	Futures	1442.86	1443.11	1440.82	1442.09	6036.0
2012-11-29 20:00:00	ES	Futures	1442.09	1444.65	1442.09	1444.39	8794.0
2012-11-29 21:00:00	ES	Futures	1444.14	1445.67	1443.37	1444.39	6941.0
2012-11-29 22:00:00	ES	Futures	1444.39	1444.9	1442.6	1444.39	6143.0
2012-11-29 23:00:00	ES	Futures	1444.39	1444.65	1443.63	1444.39	2532.0
2012-11-29 00:00:00	NQ	Futures	3099.87	3108.01	3099.87	3104.81	2323.0
2012-11-29 01:00:00	NQ	Futures	3105.39	3106.84	3102.77	3105.39	931.0
2012-11-29 02:00:00	NQ	Futures	3105.97	3110.04	3103.65	3110.04	1524.0
2012-11-29 03:00:00	NQ	Futures	3109.75	3117.88	3105.97	3116.14	5374.0
2012-11-29 04:00:00	NQ	Futures	3116.43	3117.88	3113.82	3116.14	2529.0
2012-11-29 05:00:00	NQ	Futures	3116.14	3116.72	3112.36	3112.94	2539.0
2012-11-29 06:00:00	NQ	Futures	3113.24	3116.14	3112.07	3113.82	2190.0
2012-11-29 07:00:00	NQ	Futures	3113.53	3115.85	3112.07	3114.98	3110.0
2012-11-29 08:00:00	NQ	Futures	3114.98	3115.27	3109.17	3109.46	6109.0
2012-11-29 09:00:00	NQ	Futures	3109.17	3124.86	3107.13	3121.08	41016.0
2012-11-29 10:00:00	NQ	Futures	3120.21	3124.86	3107.13	3120.21	55612.0
2012-11-29 11:00:00	NQ	Futures	3120.5	3121.66	3099.0	3108.59	51414.0
2012-11-29 12:00:00	NQ	Futures	3108.88	3117.3	3102.77	3112.36	26107.0
2012-11-29 13:00:00	NQ	Futures	3112.36	3119.92	3108.3	3117.3	15110.0
2012-11-29 14:00:00	NQ	Futures	3117.3	3122.24	3112.65	3117.59	17167.0
2012-11-29 15:00:00	NQ	Futures	3117.59	3119.63	3110.04	3114.4	31447.0
2012-11-29 16:00:00	NQ	Futures	3114.11	3116.14	3113.24	3113.24	6228.0
2012-11-29 17:00:00	NQ	Futures	3113.24	3113.24	3106.26	3107.42	456.0
2012-11-29 18:00:00	NQ	Futures	3105.68	3108.88	3104.23	3107.13	593.0
2012-11-29 19:00:00	NQ	Futures	3107.13	3111.49	3105.39	3109.46	965.0
2012-11-29 20:00:00	NQ	Futures	3109.75	3114.98	3109.17	3114.69	825.0
2012-11-29 21:00:00	NQ	Futures	3114.69	3117.3	3113.24	3115.27	741.0
2012-11-29 22:00:00	NQ	Futures	3115.27	3116.14	3110.62	3114.11	999.0
2012-11-29 23:00:00	NQ	Futures	3114.11	3114.69	3112.94	3114.11	384.0
2012-11-29 00:00:00	YM	Futures	12980.7	13016.7	12980.7	13004.7	2653.0
2012-11-29 01:00:00	YM	Futures	13005.7	13010.7	12991.7	12997.7	741.0

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

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