PREVIEW / futures_1hour / 2012-11-01

all futures 1-hour files

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

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-01 00:00:00	ES	Futures	1433.92	1434.94	1432.39	1432.64	4370.0
2012-11-01 01:00:00	ES	Futures	1432.64	1432.9	1431.11	1432.64	7393.0
2012-11-01 02:00:00	ES	Futures	1432.64	1434.17	1431.87	1433.92	3618.0
2012-11-01 03:00:00	ES	Futures	1433.92	1434.43	1430.85	1432.64	9623.0
2012-11-01 04:00:00	ES	Futures	1432.39	1435.71	1431.62	1433.92	26010.0
2012-11-01 05:00:00	ES	Futures	1433.92	1434.43	1431.62	1433.41	17508.0
2012-11-01 06:00:00	ES	Futures	1433.41	1436.73	1432.9	1436.22	23494.0
2012-11-01 07:00:00	ES	Futures	1436.22	1438.77	1435.71	1438.26	36693.0
2012-11-01 08:00:00	ES	Futures	1438.01	1440.82	1436.47	1439.03	79963.0
2012-11-01 09:00:00	ES	Futures	1439.28	1447.71	1438.01	1446.44	228402.0
2012-11-01 10:00:00	ES	Futures	1446.44	1454.61	1446.44	1452.82	333195.0
2012-11-01 11:00:00	ES	Futures	1452.82	1455.12	1450.52	1453.33	221536.0
2012-11-01 12:00:00	ES	Futures	1453.33	1454.35	1451.03	1451.54	141968.0
2012-11-01 13:00:00	ES	Futures	1451.8	1452.31	1450.01	1450.52	91679.0
2012-11-01 14:00:00	ES	Futures	1450.52	1454.1	1449.5	1453.33	110536.0
2012-11-01 15:00:00	ES	Futures	1453.33	1454.35	1450.78	1453.59	207142.0
2012-11-01 16:00:00	ES	Futures	1453.59	1456.65	1453.08	1455.89	123053.0
2012-11-01 17:00:00	ES	Futures	1455.63	1456.14	1454.61	1454.61	2301.0
2012-11-01 18:00:00	ES	Futures	1454.87	1455.38	1454.1	1454.35	2796.0
2012-11-01 19:00:00	ES	Futures	1454.35	1454.87	1453.84	1454.87	3191.0
2012-11-01 20:00:00	ES	Futures	1454.61	1454.87	1453.33	1453.59	6176.0
2012-11-01 21:00:00	ES	Futures	1453.59	1455.63	1453.59	1455.12	5322.0
2012-11-01 22:00:00	ES	Futures	1455.12	1455.38	1453.59	1453.59	5185.0
2012-11-01 23:00:00	ES	Futures	1453.59	1454.61	1453.08	1453.33	4574.0
2012-11-01 00:00:00	NQ	Futures	3064.71	3066.45	3061.22	3061.51	611.0
2012-11-01 01:00:00	NQ	Futures	3061.51	3062.38	3058.61	3062.38	465.0
2012-11-01 02:00:00	NQ	Futures	3062.09	3065.29	3060.64	3065.0	362.0
2012-11-01 03:00:00	NQ	Futures	3064.71	3065.29	3059.77	3062.68	1466.0
2012-11-01 04:00:00	NQ	Futures	3062.97	3069.65	3061.22	3067.03	2503.0
2012-11-01 05:00:00	NQ	Futures	3067.32	3068.49	3063.26	3066.16	1778.0
2012-11-01 06:00:00	NQ	Futures	3066.16	3073.72	3065.29	3072.55	2211.0
2012-11-01 07:00:00	NQ	Futures	3072.85	3078.66	3070.81	3077.49	3727.0
2012-11-01 08:00:00	NQ	Futures	3077.49	3083.89	3074.3	3080.11	8722.0
2012-11-01 09:00:00	NQ	Futures	3080.4	3096.38	3078.08	3094.93	39119.0
2012-11-01 10:00:00	NQ	Futures	3094.93	3116.72	3094.64	3114.69	57571.0
2012-11-01 11:00:00	NQ	Futures	3114.98	3120.5	3108.3	3117.3	67685.0
2012-11-01 12:00:00	NQ	Futures	3117.3	3119.05	3110.62	3111.2	18205.0
2012-11-01 13:00:00	NQ	Futures	3110.91	3113.82	3107.13	3110.91	14881.0
2012-11-01 14:00:00	NQ	Futures	3110.91	3118.18	3108.59	3116.72	16476.0
2012-11-01 15:00:00	NQ	Futures	3116.72	3118.18	3109.75	3114.4	30879.0
2012-11-01 16:00:00	NQ	Futures	3114.4	3125.44	3114.11	3123.12	11858.0
2012-11-01 17:00:00	NQ	Futures	3123.12	3124.28	3121.08	3121.08	185.0
2012-11-01 18:00:00	NQ	Futures	3121.95	3122.82	3120.5	3120.5	229.0
2012-11-01 19:00:00	NQ	Futures	3121.08	3122.53	3120.21	3122.24	240.0
2012-11-01 20:00:00	NQ	Futures	3121.95	3122.24	3119.63	3119.92	350.0
2012-11-01 21:00:00	NQ	Futures	3120.21	3123.12	3119.05	3122.24	343.0
2012-11-01 22:00:00	NQ	Futures	3122.24	3122.53	3119.34	3119.92	489.0
2012-11-01 23:00:00	NQ	Futures	3119.34	3120.21	3115.85	3117.3	998.0
2012-11-01 00:00:00	YM	Futures	13016.7	13022.7	13004.7	13005.7	611.0
2012-11-01 01:00:00	YM	Futures	13005.7	13007.7	12994.7	13007.7	534.0

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

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