PREVIEW / futures_1hour / 2011-11-04

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-04.parquet
  size:    41 KB
  rows:    1,170

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-11-04 00:00:00	ES	Futures	1256.05	1258.81	1255.8	1258.05	3030.0
2011-11-04 01:00:00	ES	Futures	1258.05	1259.56	1257.55	1258.3	2992.0
2011-11-04 02:00:00	ES	Futures	1258.55	1260.81	1258.55	1260.31	3861.0
2011-11-04 03:00:00	ES	Futures	1260.31	1262.32	1258.05	1259.31	8590.0
2011-11-04 04:00:00	ES	Futures	1259.31	1260.31	1254.79	1256.3	42635.0
2011-11-04 05:00:00	ES	Futures	1256.55	1260.81	1254.29	1260.06	27269.0
2011-11-04 06:00:00	ES	Futures	1260.31	1261.31	1258.55	1260.31	18831.0
2011-11-04 07:00:00	ES	Futures	1260.06	1260.06	1254.79	1254.79	38124.0
2011-11-04 08:00:00	ES	Futures	1254.79	1262.57	1248.52	1252.29	175213.0
2011-11-04 09:00:00	ES	Futures	1252.54	1253.54	1246.27	1247.27	293733.0
2011-11-04 10:00:00	ES	Futures	1247.27	1248.52	1238.24	1242.76	417082.0
2011-11-04 11:00:00	ES	Futures	1243.01	1245.26	1239.25	1245.01	289422.0
2011-11-04 12:00:00	ES	Futures	1244.76	1247.27	1242.51	1245.52	171623.0
2011-11-04 13:00:00	ES	Futures	1245.52	1255.29	1244.76	1252.79	210541.0
2011-11-04 14:00:00	ES	Futures	1252.54	1255.04	1250.53	1252.29	116354.0
2011-11-04 15:00:00	ES	Futures	1252.54	1254.54	1247.27	1253.29	299328.0
2011-11-04 16:00:00	ES	Futures	1253.29	1257.05	1251.78	1254.54	87927.0
2011-11-04 00:00:00	NQ	Futures	2719.46	2723.78	2718.88	2722.92	314.0
2011-11-04 01:00:00	NQ	Futures	2722.92	2725.22	2720.9	2722.92	293.0
2011-11-04 02:00:00	NQ	Futures	2722.92	2725.51	2722.34	2724.65	363.0
2011-11-04 03:00:00	NQ	Futures	2724.07	2726.95	2720.03	2723.21	786.0
2011-11-04 04:00:00	NQ	Futures	2723.21	2724.94	2714.27	2717.44	3663.0
2011-11-04 05:00:00	NQ	Futures	2717.44	2724.94	2713.11	2723.78	1584.0
2011-11-04 06:00:00	NQ	Futures	2723.49	2725.8	2721.19	2724.07	1252.0
2011-11-04 07:00:00	NQ	Futures	2723.78	2723.78	2704.75	2707.35	4929.0
2011-11-04 08:00:00	NQ	Futures	2707.35	2724.36	2701.58	2707.64	11608.0
2011-11-04 09:00:00	NQ	Futures	2707.64	2716.57	2697.26	2698.7	37279.0
2011-11-04 10:00:00	NQ	Futures	2698.7	2703.6	2683.71	2692.64	42818.0
2011-11-04 11:00:00	NQ	Futures	2692.93	2700.14	2686.88	2698.41	33441.0
2011-11-04 12:00:00	NQ	Futures	2698.7	2705.62	2695.82	2701.87	18839.0
2011-11-04 13:00:00	NQ	Futures	2701.58	2722.63	2699.85	2718.3	20993.0
2011-11-04 14:00:00	NQ	Futures	2718.3	2720.9	2712.54	2715.71	14138.0
2011-11-04 15:00:00	NQ	Futures	2716.0	2716.29	2705.04	2712.25	33489.0
2011-11-04 16:00:00	NQ	Futures	2712.25	2717.44	2710.23	2713.69	6365.0
2011-11-04 00:00:00	YM	Futures	11765.5	11787.2	11763.5	11781.2	371.0
2011-11-04 01:00:00	YM	Futures	11783.2	11794.0	11777.3	11784.2	255.0
2011-11-04 02:00:00	YM	Futures	11785.2	11807.8	11785.2	11805.9	650.0
2011-11-04 03:00:00	YM	Futures	11804.9	11822.6	11785.2	11796.0	660.0
2011-11-04 04:00:00	YM	Futures	11797.0	11803.9	11754.7	11770.4	2570.0
2011-11-04 05:00:00	YM	Futures	11770.4	11806.8	11752.7	11800.0	1746.0
2011-11-04 06:00:00	YM	Futures	11800.0	11810.8	11789.1	11802.9	1130.0
2011-11-04 07:00:00	YM	Futures	11801.9	11801.9	11764.5	11764.5	2015.0
2011-11-04 08:00:00	YM	Futures	11765.5	11822.6	11727.1	11745.8	7610.0
2011-11-04 09:00:00	YM	Futures	11744.8	11751.7	11679.8	11687.7	15664.0
2011-11-04 10:00:00	YM	Futures	11688.7	11705.4	11608.0	11647.3	18632.0
2011-11-04 11:00:00	YM	Futures	11648.3	11665.1	11612.9	11658.2	13130.0
2011-11-04 12:00:00	YM	Futures	11658.2	11669.0	11634.5	11658.2	7882.0
2011-11-04 13:00:00	YM	Futures	11657.2	11745.8	11653.3	11729.1	12646.0
2011-11-04 14:00:00	YM	Futures	11729.1	11744.8	11708.4	11726.1	7723.0
2011-11-04 15:00:00	YM	Futures	11725.1	11751.7	11680.8	11740.9	16155.0

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

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