PREVIEW / futures_1hour / 2012-07-19

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-19.parquet
  size:    50 KB
  rows:    1,534

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-07-19 00:00:00	ES	Futures	1395.0	1395.51	1394.24	1394.74	1492.0
2012-07-19 01:00:00	ES	Futures	1394.49	1395.25	1393.98	1394.24	3082.0
2012-07-19 02:00:00	ES	Futures	1393.98	1395.0	1393.47	1394.49	7925.0
2012-07-19 03:00:00	ES	Futures	1394.24	1395.51	1393.47	1393.73	24051.0
2012-07-19 04:00:00	ES	Futures	1393.73	1395.0	1391.95	1392.71	19290.0
2012-07-19 05:00:00	ES	Futures	1392.71	1395.0	1392.2	1394.49	12611.0
2012-07-19 06:00:00	ES	Futures	1394.49	1398.56	1394.49	1396.02	38798.0
2012-07-19 07:00:00	ES	Futures	1396.02	1397.29	1394.74	1396.78	25379.0
2012-07-19 08:00:00	ES	Futures	1396.78	1399.07	1395.25	1395.76	65684.0
2012-07-19 09:00:00	ES	Futures	1395.76	1397.29	1392.96	1396.78	189061.0
2012-07-19 10:00:00	ES	Futures	1396.78	1396.78	1389.4	1393.98	393053.0
2012-07-19 11:00:00	ES	Futures	1393.98	1396.52	1393.73	1395.25	205516.0
2012-07-19 12:00:00	ES	Futures	1395.25	1399.58	1394.24	1394.49	158436.0
2012-07-19 13:00:00	ES	Futures	1394.49	1397.29	1390.68	1392.2	156413.0
2012-07-19 14:00:00	ES	Futures	1392.46	1396.02	1391.95	1395.0	119296.0
2012-07-19 15:00:00	ES	Futures	1395.0	1397.03	1392.96	1394.74	211513.0
2012-07-19 16:00:00	ES	Futures	1394.74	1396.02	1393.22	1395.0	74472.0
2012-07-19 17:00:00	ES	Futures	1395.0	1395.25	1394.74	1395.0	702.0
2012-07-19 18:00:00	ES	Futures	1395.0	1395.51	1394.49	1395.0	1862.0
2012-07-19 19:00:00	ES	Futures	1394.74	1395.0	1393.98	1394.24	975.0
2012-07-19 20:00:00	ES	Futures	1394.24	1394.49	1391.44	1392.2	6050.0
2012-07-19 21:00:00	ES	Futures	1391.95	1393.22	1391.44	1392.96	3605.0
2012-07-19 22:00:00	ES	Futures	1392.96	1393.22	1391.44	1392.2	3266.0
2012-07-19 23:00:00	ES	Futures	1392.2	1392.71	1390.93	1391.44	3697.0
2012-07-19 00:00:00	NQ	Futures	3056.55	3056.55	3053.36	3054.23	393.0
2012-07-19 01:00:00	NQ	Futures	3054.23	3055.1	3052.49	3053.07	434.0
2012-07-19 02:00:00	NQ	Futures	3053.36	3053.65	3051.04	3053.07	883.0
2012-07-19 03:00:00	NQ	Futures	3053.07	3056.26	3050.75	3053.07	2854.0
2012-07-19 04:00:00	NQ	Futures	3052.78	3055.39	3048.43	3050.75	1907.0
2012-07-19 05:00:00	NQ	Futures	3050.46	3053.94	3049.59	3052.49	1390.0
2012-07-19 06:00:00	NQ	Futures	3052.78	3059.16	3052.2	3054.52	2925.0
2012-07-19 07:00:00	NQ	Futures	3054.52	3056.84	3051.91	3056.26	2215.0
2012-07-19 08:00:00	NQ	Futures	3056.26	3060.9	3055.1	3057.71	7236.0
2012-07-19 09:00:00	NQ	Futures	3058.0	3070.17	3055.97	3066.11	40659.0
2012-07-19 10:00:00	NQ	Futures	3066.4	3069.01	3053.94	3065.24	48579.0
2012-07-19 11:00:00	NQ	Futures	3065.82	3073.94	3065.82	3071.62	24583.0
2012-07-19 12:00:00	NQ	Futures	3071.62	3082.06	3071.33	3073.36	26281.0
2012-07-19 13:00:00	NQ	Futures	3073.36	3079.45	3061.76	3066.98	22713.0
2012-07-19 14:00:00	NQ	Futures	3066.69	3076.55	3066.4	3073.65	18528.0
2012-07-19 15:00:00	NQ	Futures	3073.65	3080.32	3070.75	3071.91	30243.0
2012-07-19 16:00:00	NQ	Futures	3071.91	3080.9	3069.01	3078.29	14781.0
2012-07-19 17:00:00	NQ	Futures	3078.29	3078.87	3077.71	3077.71	170.0
2012-07-19 18:00:00	NQ	Futures	3078.0	3078.58	3077.13	3077.71	370.0
2012-07-19 19:00:00	NQ	Futures	3077.71	3077.71	3075.39	3075.68	438.0
2012-07-19 20:00:00	NQ	Futures	3075.39	3075.97	3069.88	3071.91	1183.0
2012-07-19 21:00:00	NQ	Futures	3071.91	3075.39	3070.75	3075.1	480.0
2012-07-19 22:00:00	NQ	Futures	3075.1	3077.13	3073.94	3076.26	1027.0
2012-07-19 23:00:00	NQ	Futures	3076.26	3077.71	3075.1	3075.97	869.0
2012-07-19 00:00:00	YM	Futures	12825.8	12829.8	12821.8	12825.8	388.0
2012-07-19 01:00:00	YM	Futures	12825.8	12832.8	12822.8	12827.8	723.0

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

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