PREVIEW / futures_1hour / 2012-11-28

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-28.parquet
  size:    48 KB
  rows:    1,483

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-28 00:00:00	ES	Futures	1427.28	1427.53	1426.0	1426.51	4806.0
2012-11-28 01:00:00	ES	Futures	1426.51	1426.76	1424.21	1425.74	4020.0
2012-11-28 02:00:00	ES	Futures	1425.49	1427.02	1425.23	1426.51	5327.0
2012-11-28 03:00:00	ES	Futures	1426.25	1428.04	1424.72	1425.74	25233.0
2012-11-28 04:00:00	ES	Futures	1425.49	1426.0	1423.44	1424.47	17454.0
2012-11-28 05:00:00	ES	Futures	1424.72	1426.76	1424.21	1425.49	10892.0
2012-11-28 06:00:00	ES	Futures	1425.49	1425.74	1422.68	1422.93	21110.0
2012-11-28 07:00:00	ES	Futures	1422.93	1424.47	1421.91	1422.42	26996.0
2012-11-28 08:00:00	ES	Futures	1422.42	1423.7	1420.89	1421.66	55209.0
2012-11-28 09:00:00	ES	Futures	1421.66	1422.42	1417.57	1418.85	222917.0
2012-11-28 10:00:00	ES	Futures	1419.1	1427.28	1413.23	1424.47	518588.0
2012-11-28 11:00:00	ES	Futures	1424.72	1430.09	1423.95	1427.02	297586.0
2012-11-28 12:00:00	ES	Futures	1427.02	1434.94	1423.19	1433.41	269934.0
2012-11-28 13:00:00	ES	Futures	1433.41	1435.45	1430.6	1433.41	103119.0
2012-11-28 14:00:00	ES	Futures	1433.41	1434.68	1431.36	1433.92	103111.0
2012-11-28 15:00:00	ES	Futures	1433.92	1439.54	1433.15	1438.77	297636.0
2012-11-28 16:00:00	ES	Futures	1438.52	1439.28	1436.47	1437.75	83414.0
2012-11-28 17:00:00	ES	Futures	1437.49	1438.01	1436.98	1437.24	1023.0
2012-11-28 18:00:00	ES	Futures	1437.49	1437.49	1435.2	1435.71	9268.0
2012-11-28 19:00:00	ES	Futures	1435.71	1437.24	1435.71	1436.98	4351.0
2012-11-28 20:00:00	ES	Futures	1436.98	1437.75	1436.47	1437.75	3852.0
2012-11-28 21:00:00	ES	Futures	1437.49	1438.01	1436.98	1436.98	2453.0
2012-11-28 22:00:00	ES	Futures	1436.98	1438.77	1436.47	1438.26	3489.0
2012-11-28 23:00:00	ES	Futures	1438.26	1440.56	1438.26	1439.79	7769.0
2012-11-28 00:00:00	NQ	Futures	3071.39	3072.26	3068.78	3070.81	536.0
2012-11-28 01:00:00	NQ	Futures	3070.23	3070.23	3065.87	3067.32	590.0
2012-11-28 02:00:00	NQ	Futures	3067.03	3071.68	3066.45	3070.52	824.0
2012-11-28 03:00:00	NQ	Futures	3070.52	3074.01	3065.29	3065.87	3197.0
2012-11-28 04:00:00	NQ	Futures	3065.87	3067.03	3060.93	3064.42	2575.0
2012-11-28 05:00:00	NQ	Futures	3064.13	3068.2	3062.68	3063.26	2069.0
2012-11-28 06:00:00	NQ	Futures	3062.97	3065.0	3060.93	3061.51	1720.0
2012-11-28 07:00:00	NQ	Futures	3061.8	3064.71	3059.77	3060.64	2156.0
2012-11-28 08:00:00	NQ	Futures	3060.64	3063.26	3057.15	3058.9	4953.0
2012-11-28 09:00:00	NQ	Futures	3058.9	3060.06	3044.37	3049.6	39642.0
2012-11-28 10:00:00	NQ	Futures	3048.73	3069.65	3035.36	3063.84	67773.0
2012-11-28 11:00:00	NQ	Futures	3063.55	3075.75	3062.38	3068.78	41529.0
2012-11-28 12:00:00	NQ	Futures	3068.78	3084.47	3060.64	3082.14	44825.0
2012-11-28 13:00:00	NQ	Futures	3082.14	3089.41	3076.91	3084.47	25227.0
2012-11-28 14:00:00	NQ	Futures	3084.47	3086.5	3079.24	3084.47	21396.0
2012-11-28 15:00:00	NQ	Futures	3084.18	3098.13	3083.02	3095.51	39170.0
2012-11-28 16:00:00	NQ	Futures	3095.8	3096.09	3092.02	3094.06	6035.0
2012-11-28 17:00:00	NQ	Futures	3094.06	3095.51	3093.48	3094.35	154.0
2012-11-28 18:00:00	NQ	Futures	3095.8	3095.8	3091.44	3092.02	596.0
2012-11-28 19:00:00	NQ	Futures	3092.31	3094.93	3092.02	3094.06	284.0
2012-11-28 20:00:00	NQ	Futures	3094.35	3095.51	3093.48	3095.51	295.0
2012-11-28 21:00:00	NQ	Futures	3095.51	3096.38	3094.35	3094.93	297.0
2012-11-28 22:00:00	NQ	Futures	3094.93	3097.54	3093.77	3097.25	297.0
2012-11-28 23:00:00	NQ	Futures	3097.54	3100.74	3097.25	3099.58	916.0
2012-11-28 00:00:00	YM	Futures	12864.6	12867.6	12855.6	12859.6	393.0
2012-11-28 01:00:00	YM	Futures	12859.6	12860.6	12845.6	12852.6	479.0

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

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