PREVIEW / futures_1hour / 2012-07-03

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-03.parquet
  size:    45 KB
  rows:    1,392

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-03 00:00:00	ES	Futures	1382.54	1383.81	1382.28	1382.54	3541.0
2012-07-03 01:00:00	ES	Futures	1382.54	1382.54	1381.27	1381.78	3379.0
2012-07-03 02:00:00	ES	Futures	1382.03	1383.05	1379.74	1380.25	9876.0
2012-07-03 03:00:00	ES	Futures	1380.25	1381.52	1379.23	1380.5	35030.0
2012-07-03 04:00:00	ES	Futures	1380.5	1382.03	1378.47	1380.0	27333.0
2012-07-03 05:00:00	ES	Futures	1380.0	1382.28	1379.74	1381.27	17594.0
2012-07-03 06:00:00	ES	Futures	1381.27	1381.78	1379.49	1380.5	17002.0
2012-07-03 07:00:00	ES	Futures	1380.25	1382.79	1380.25	1381.78	17062.0
2012-07-03 08:00:00	ES	Futures	1382.03	1382.79	1380.76	1382.28	27457.0
2012-07-03 09:00:00	ES	Futures	1382.28	1386.35	1381.01	1385.59	150451.0
2012-07-03 10:00:00	ES	Futures	1385.59	1389.4	1385.59	1388.9	245700.0
2012-07-03 11:00:00	ES	Futures	1388.64	1392.96	1388.64	1391.18	199001.0
2012-07-03 12:00:00	ES	Futures	1391.18	1392.2	1387.37	1391.69	196446.0
2012-07-03 13:00:00	ES	Futures	1391.95	1392.71	1390.93	1392.2	58356.0
2012-07-03 16:00:00	ES	Futures	1389.91	1392.46	1389.66	1391.44	3290.0
2012-07-03 17:00:00	ES	Futures	1391.44	1392.2	1391.18	1391.95	317.0
2012-07-03 18:00:00	ES	Futures	1392.2	1392.71	1391.44	1391.69	1034.0
2012-07-03 19:00:00	ES	Futures	1391.69	1392.2	1391.18	1391.69	1381.0
2012-07-03 20:00:00	ES	Futures	1391.44	1392.2	1390.68	1391.44	3030.0
2012-07-03 21:00:00	ES	Futures	1391.18	1392.96	1390.93	1391.18	3813.0
2012-07-03 22:00:00	ES	Futures	1391.18	1391.95	1390.93	1391.69	1448.0
2012-07-03 23:00:00	ES	Futures	1391.69	1392.2	1391.44	1391.95	693.0
2012-07-03 00:00:00	NQ	Futures	3038.57	3040.89	3037.7	3037.99	589.0
2012-07-03 01:00:00	NQ	Futures	3037.7	3038.57	3035.68	3037.12	331.0
2012-07-03 02:00:00	NQ	Futures	3037.41	3039.15	3033.65	3035.1	734.0
2012-07-03 03:00:00	NQ	Futures	3034.81	3037.7	3032.78	3034.81	3891.0
2012-07-03 04:00:00	NQ	Futures	3035.1	3037.99	3031.33	3034.23	3127.0
2012-07-03 05:00:00	NQ	Futures	3034.52	3037.99	3033.65	3035.97	2240.0
2012-07-03 06:00:00	NQ	Futures	3035.97	3036.54	3032.49	3033.94	2096.0
2012-07-03 07:00:00	NQ	Futures	3033.65	3037.99	3033.65	3035.97	2200.0
2012-07-03 08:00:00	NQ	Futures	3035.97	3040.02	3034.81	3038.28	3828.0
2012-07-03 09:00:00	NQ	Futures	3038.28	3042.34	3033.07	3040.31	18873.0
2012-07-03 10:00:00	NQ	Futures	3040.89	3051.33	3040.31	3050.17	22754.0
2012-07-03 11:00:00	NQ	Futures	3050.17	3060.03	3049.59	3056.26	19221.0
2012-07-03 12:00:00	NQ	Futures	3056.26	3062.63	3052.49	3061.48	18253.0
2012-07-03 13:00:00	NQ	Futures	3061.76	3064.08	3060.03	3062.63	4623.0
2012-07-03 16:00:00	NQ	Futures	3062.34	3064.66	3039.15	3062.92	804.0
2012-07-03 17:00:00	NQ	Futures	3062.63	3063.5	3060.9	3062.63	185.0
2012-07-03 18:00:00	NQ	Futures	3062.92	3064.37	3061.76	3062.63	221.0
2012-07-03 19:00:00	NQ	Futures	3062.05	3063.5	3062.05	3062.05	227.0
2012-07-03 20:00:00	NQ	Futures	3062.34	3063.5	3061.48	3062.63	628.0
2012-07-03 21:00:00	NQ	Futures	3062.63	3066.69	3062.05	3062.92	661.0
2012-07-03 22:00:00	NQ	Futures	3063.21	3064.08	3061.48	3063.5	517.0
2012-07-03 23:00:00	NQ	Futures	3063.21	3064.37	3062.92	3064.08	126.0
2012-07-03 00:00:00	YM	Futures	12709.5	12718.4	12706.5	12707.5	565.0
2012-07-03 01:00:00	YM	Futures	12709.5	12710.5	12701.5	12706.5	408.0
2012-07-03 02:00:00	YM	Futures	12706.5	12715.4	12690.6	12694.5	748.0
2012-07-03 03:00:00	YM	Futures	12695.5	12705.5	12688.6	12694.5	2459.0
2012-07-03 04:00:00	YM	Futures	12695.5	12709.5	12681.6	12694.5	1921.0
2012-07-03 05:00:00	YM	Futures	12694.5	12710.5	12692.6	12701.5	1098.0

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

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