PREVIEW / futures_1hour / 2011-07-29

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-29.parquet
  size:    41 KB
  rows:    1,162

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
2011-07-29 00:00:00	ES	Futures	1285.44	1286.93	1284.44	1286.18	3814.0
2011-07-29 01:00:00	ES	Futures	1286.18	1286.93	1282.44	1285.69	9790.0
2011-07-29 02:00:00	ES	Futures	1285.69	1288.43	1284.69	1287.18	16409.0
2011-07-29 03:00:00	ES	Futures	1287.18	1291.42	1284.94	1287.18	42160.0
2011-07-29 04:00:00	ES	Futures	1287.43	1290.67	1285.44	1289.93	22799.0
2011-07-29 05:00:00	ES	Futures	1290.17	1290.42	1287.43	1290.17	17619.0
2011-07-29 06:00:00	ES	Futures	1290.42	1290.42	1285.93	1286.68	32475.0
2011-07-29 07:00:00	ES	Futures	1286.43	1289.18	1285.93	1287.43	18372.0
2011-07-29 08:00:00	ES	Futures	1287.68	1288.93	1278.95	1281.94	151374.0
2011-07-29 09:00:00	ES	Futures	1281.7	1285.19	1275.46	1283.19	415119.0
2011-07-29 10:00:00	ES	Futures	1283.44	1293.67	1280.95	1291.42	580016.0
2011-07-29 11:00:00	ES	Futures	1291.42	1297.66	1289.43	1292.67	335657.0
2011-07-29 12:00:00	ES	Futures	1292.67	1293.42	1287.18	1287.68	241605.0
2011-07-29 13:00:00	ES	Futures	1287.43	1292.67	1286.43	1291.67	142568.0
2011-07-29 14:00:00	ES	Futures	1291.92	1293.92	1289.18	1289.93	146339.0
2011-07-29 15:00:00	ES	Futures	1289.93	1291.92	1284.19	1285.19	443660.0
2011-07-29 16:00:00	ES	Futures	1285.19	1291.17	1282.19	1289.43	168292.0
2011-07-29 00:00:00	NQ	Futures	2713.63	2717.66	2713.05	2715.93	183.0
2011-07-29 01:00:00	NQ	Futures	2715.35	2716.5	2704.99	2715.07	1103.0
2011-07-29 02:00:00	NQ	Futures	2714.78	2719.96	2712.48	2717.08	1182.0
2011-07-29 03:00:00	NQ	Futures	2716.5	2723.12	2712.48	2717.66	4065.0
2011-07-29 04:00:00	NQ	Futures	2717.37	2725.14	2714.2	2723.7	2247.0
2011-07-29 05:00:00	NQ	Futures	2723.7	2724.56	2718.81	2723.41	1484.0
2011-07-29 06:00:00	NQ	Futures	2722.84	2723.7	2714.78	2716.79	2191.0
2011-07-29 07:00:00	NQ	Futures	2716.5	2720.53	2714.78	2715.93	1723.0
2011-07-29 08:00:00	NQ	Futures	2715.93	2722.55	2702.69	2707.58	14926.0
2011-07-29 09:00:00	NQ	Futures	2707.58	2711.9	2691.18	2711.04	60495.0
2011-07-29 10:00:00	NQ	Futures	2711.04	2733.77	2702.12	2732.33	77655.0
2011-07-29 11:00:00	NQ	Futures	2732.33	2745.57	2726.58	2732.91	41843.0
2011-07-29 12:00:00	NQ	Futures	2733.19	2734.35	2721.11	2722.84	28252.0
2011-07-29 13:00:00	NQ	Futures	2722.55	2736.36	2720.53	2733.77	21127.0
2011-07-29 14:00:00	NQ	Futures	2733.77	2738.09	2726.0	2727.73	16646.0
2011-07-29 15:00:00	NQ	Futures	2727.73	2731.18	2716.5	2717.08	40912.0
2011-07-29 16:00:00	NQ	Futures	2717.37	2722.84	2709.6	2720.82	12424.0
2011-07-29 00:00:00	YM	Futures	11736.0	11752.5	11735.1	11746.7	191.0
2011-07-29 01:00:00	YM	Futures	11746.7	11747.7	11717.6	11740.9	782.0
2011-07-29 02:00:00	YM	Futures	11740.9	11760.2	11730.2	11750.6	1389.0
2011-07-29 03:00:00	YM	Futures	11748.6	11770.9	11735.1	11751.5	2097.0
2011-07-29 04:00:00	YM	Futures	11750.6	11778.6	11738.0	11770.9	1041.0
2011-07-29 05:00:00	YM	Futures	11769.0	11771.9	11751.5	11763.1	809.0
2011-07-29 06:00:00	YM	Futures	11764.1	11766.1	11732.2	11739.9	1392.0
2011-07-29 07:00:00	YM	Futures	11739.9	11757.3	11734.1	11744.7	854.0
2011-07-29 08:00:00	YM	Futures	11744.7	11750.6	11672.1	11688.6	7038.0
2011-07-29 09:00:00	YM	Futures	11687.6	11724.4	11648.9	11706.0	22544.0
2011-07-29 10:00:00	YM	Futures	11706.0	11771.9	11685.7	11752.5	25671.0
2011-07-29 11:00:00	YM	Futures	11752.5	11803.8	11739.9	11756.4	15903.0
2011-07-29 12:00:00	YM	Futures	11757.3	11765.1	11719.6	11728.3	14925.0
2011-07-29 13:00:00	YM	Futures	11727.3	11765.1	11716.7	11755.4	8588.0
2011-07-29 14:00:00	YM	Futures	11756.4	11773.8	11735.1	11744.7	9171.0
2011-07-29 15:00:00	YM	Futures	11744.7	11764.1	11698.3	11712.8	22414.0

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

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