PREVIEW / futures_1hour / 2012-07-20

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-20.parquet
  size:    41 KB
  rows:    1,204

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-20 00:00:00	ES	Futures	1391.44	1391.95	1390.93	1391.18	1793.0
2012-07-20 01:00:00	ES	Futures	1391.18	1391.44	1389.91	1390.17	4276.0
2012-07-20 02:00:00	ES	Futures	1390.17	1391.44	1389.91	1390.93	5341.0
2012-07-20 03:00:00	ES	Futures	1391.18	1393.22	1390.42	1392.96	24145.0
2012-07-20 04:00:00	ES	Futures	1392.71	1393.73	1391.44	1393.73	11743.0
2012-07-20 05:00:00	ES	Futures	1393.47	1393.98	1391.69	1391.95	14488.0
2012-07-20 06:00:00	ES	Futures	1391.69	1391.69	1388.9	1390.17	31254.0
2012-07-20 07:00:00	ES	Futures	1389.91	1390.68	1385.84	1386.86	49981.0
2012-07-20 08:00:00	ES	Futures	1386.86	1387.88	1385.08	1386.86	65063.0
2012-07-20 09:00:00	ES	Futures	1386.86	1388.39	1384.57	1386.61	293911.0
2012-07-20 10:00:00	ES	Futures	1386.61	1388.9	1383.81	1387.12	294317.0
2012-07-20 11:00:00	ES	Futures	1387.12	1388.64	1383.81	1385.34	265780.0
2012-07-20 12:00:00	ES	Futures	1385.59	1385.59	1380.5	1383.81	195634.0
2012-07-20 13:00:00	ES	Futures	1383.81	1384.32	1380.25	1382.54	120310.0
2012-07-20 14:00:00	ES	Futures	1382.79	1384.06	1380.76	1381.27	84230.0
2012-07-20 15:00:00	ES	Futures	1381.27	1383.05	1380.25	1382.03	229875.0
2012-07-20 16:00:00	ES	Futures	1382.03	1382.79	1380.76	1382.03	82004.0
2012-07-20 00:00:00	NQ	Futures	3075.97	3077.42	3075.68	3076.55	357.0
2012-07-20 01:00:00	NQ	Futures	3076.55	3076.84	3073.07	3074.23	549.0
2012-07-20 02:00:00	NQ	Futures	3073.94	3076.26	3073.36	3075.1	796.0
2012-07-20 03:00:00	NQ	Futures	3075.39	3080.61	3074.23	3079.74	2592.0
2012-07-20 04:00:00	NQ	Futures	3079.74	3081.48	3077.13	3081.19	1534.0
2012-07-20 05:00:00	NQ	Futures	3081.19	3081.48	3075.1	3075.39	2229.0
2012-07-20 06:00:00	NQ	Futures	3075.1	3075.1	3069.59	3073.94	3363.0
2012-07-20 07:00:00	NQ	Futures	3073.65	3075.39	3065.53	3067.85	4245.0
2012-07-20 08:00:00	NQ	Futures	3068.14	3069.01	3062.92	3066.69	5084.0
2012-07-20 09:00:00	NQ	Futures	3066.4	3072.2	3053.65	3060.03	45146.0
2012-07-20 10:00:00	NQ	Futures	3060.03	3068.43	3048.14	3057.13	43630.0
2012-07-20 11:00:00	NQ	Futures	3057.42	3062.05	3043.79	3047.56	33504.0
2012-07-20 12:00:00	NQ	Futures	3047.56	3047.85	3035.68	3044.08	20514.0
2012-07-20 13:00:00	NQ	Futures	3044.37	3046.11	3036.26	3041.47	18275.0
2012-07-20 14:00:00	NQ	Futures	3041.18	3044.37	3037.41	3038.28	10456.0
2012-07-20 15:00:00	NQ	Futures	3038.28	3042.34	3029.59	3031.91	30540.0
2012-07-20 16:00:00	NQ	Futures	3031.91	3032.78	3029.59	3032.2	9478.0
2012-07-20 00:00:00	YM	Futures	12776.1	12780.1	12774.1	12778.1	298.0
2012-07-20 01:00:00	YM	Futures	12779.1	12780.1	12770.1	12773.1	497.0
2012-07-20 02:00:00	YM	Futures	12772.1	12780.1	12772.1	12777.1	691.0
2012-07-20 03:00:00	YM	Futures	12777.1	12797.0	12773.1	12794.0	2232.0
2012-07-20 04:00:00	YM	Futures	12794.0	12800.0	12782.1	12800.0	1185.0
2012-07-20 05:00:00	YM	Futures	12799.0	12801.9	12781.1	12782.1	1334.0
2012-07-20 06:00:00	YM	Futures	12781.1	12781.1	12761.2	12770.1	2008.0
2012-07-20 07:00:00	YM	Futures	12769.1	12774.1	12734.3	12742.3	2549.0
2012-07-20 08:00:00	YM	Futures	12742.3	12752.2	12729.3	12747.2	3630.0
2012-07-20 09:00:00	YM	Futures	12748.2	12752.2	12717.4	12742.3	22470.0
2012-07-20 10:00:00	YM	Futures	12743.3	12766.1	12703.5	12736.3	22728.0
2012-07-20 11:00:00	YM	Futures	12736.3	12750.2	12711.4	12729.3	15474.0
2012-07-20 12:00:00	YM	Futures	12729.3	12729.3	12685.6	12711.4	11679.0
2012-07-20 13:00:00	YM	Futures	12710.5	12715.4	12681.6	12693.5	8731.0
2012-07-20 14:00:00	YM	Futures	12693.5	12709.5	12679.6	12689.6	7101.0
2012-07-20 15:00:00	YM	Futures	12689.6	12708.5	12685.6	12700.5	11248.0

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

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