PREVIEW / futures_1hour / 2012-05-25

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-25.parquet
  size:    41 KB
  rows:    1,193

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-05-25 00:00:00	ES	Futures	1333.23	1336.01	1332.72	1334.49	5111.0
2012-05-25 01:00:00	ES	Futures	1334.49	1335.76	1333.73	1335.25	3286.0
2012-05-25 02:00:00	ES	Futures	1335.25	1339.3	1334.49	1339.05	11774.0
2012-05-25 03:00:00	ES	Futures	1339.05	1345.62	1338.29	1343.6	72694.0
2012-05-25 04:00:00	ES	Futures	1343.35	1345.62	1341.32	1341.83	41696.0
2012-05-25 05:00:00	ES	Futures	1341.83	1343.35	1340.06	1341.32	21343.0
2012-05-25 06:00:00	ES	Futures	1341.32	1343.09	1336.77	1338.79	31267.0
2012-05-25 07:00:00	ES	Futures	1338.54	1340.56	1337.78	1338.54	24558.0
2012-05-25 08:00:00	ES	Futures	1338.54	1339.3	1333.99	1334.49	77692.0
2012-05-25 09:00:00	ES	Futures	1334.24	1338.54	1333.73	1337.02	225011.0
2012-05-25 10:00:00	ES	Futures	1337.28	1338.29	1332.47	1333.48	284426.0
2012-05-25 11:00:00	ES	Futures	1333.48	1337.78	1333.48	1336.52	168918.0
2012-05-25 12:00:00	ES	Futures	1336.26	1336.77	1332.97	1333.99	83584.0
2012-05-25 13:00:00	ES	Futures	1334.24	1335.5	1333.23	1334.24	57486.0
2012-05-25 14:00:00	ES	Futures	1334.24	1334.75	1329.94	1331.2	104871.0
2012-05-25 15:00:00	ES	Futures	1331.2	1332.72	1327.66	1331.46	178171.0
2012-05-25 16:00:00	ES	Futures	1331.46	1331.46	1328.67	1330.44	67697.0
2012-05-25 00:00:00	NQ	Futures	2922.95	2927.58	2922.66	2923.53	526.0
2012-05-25 01:00:00	NQ	Futures	2924.11	2927.58	2923.24	2926.13	280.0
2012-05-25 02:00:00	NQ	Futures	2926.42	2936.54	2924.4	2936.25	1195.0
2012-05-25 03:00:00	NQ	Futures	2935.96	2951.29	2934.23	2946.66	7196.0
2012-05-25 04:00:00	NQ	Futures	2946.66	2951.58	2943.48	2944.35	4148.0
2012-05-25 05:00:00	NQ	Futures	2944.35	2947.24	2939.43	2941.75	1974.0
2012-05-25 06:00:00	NQ	Futures	2942.04	2947.24	2934.23	2938.86	3239.0
2012-05-25 07:00:00	NQ	Futures	2938.57	2941.75	2935.39	2937.12	2574.0
2012-05-25 08:00:00	NQ	Futures	2937.41	2939.43	2925.55	2926.13	9363.0
2012-05-25 09:00:00	NQ	Futures	2925.84	2934.23	2924.11	2929.6	28528.0
2012-05-25 10:00:00	NQ	Futures	2929.31	2931.05	2916.01	2917.46	37115.0
2012-05-25 11:00:00	NQ	Futures	2917.17	2926.13	2916.88	2922.37	19020.0
2012-05-25 12:00:00	NQ	Futures	2922.37	2925.26	2918.03	2922.66	9981.0
2012-05-25 13:00:00	NQ	Futures	2922.08	2931.34	2920.35	2927.29	12018.0
2012-05-25 14:00:00	NQ	Futures	2927.29	2928.16	2917.46	2919.19	12404.0
2012-05-25 15:00:00	NQ	Futures	2919.19	2923.24	2913.12	2920.93	25646.0
2012-05-25 16:00:00	NQ	Futures	2920.93	2923.53	2917.17	2922.08	6970.0
2012-05-25 00:00:00	YM	Futures	12445.8	12468.7	12445.8	12454.7	668.0
2012-05-25 01:00:00	YM	Futures	12455.7	12467.7	12451.8	12463.7	364.0
2012-05-25 02:00:00	YM	Futures	12462.7	12492.6	12455.7	12491.6	943.0
2012-05-25 03:00:00	YM	Futures	12490.6	12539.4	12484.6	12521.5	7300.0
2012-05-25 04:00:00	YM	Futures	12522.5	12536.4	12505.6	12509.5	3884.0
2012-05-25 05:00:00	YM	Futures	12509.5	12518.5	12493.6	12505.6	2487.0
2012-05-25 06:00:00	YM	Futures	12505.6	12520.5	12469.7	12483.6	2746.0
2012-05-25 07:00:00	YM	Futures	12482.6	12495.6	12473.7	12479.6	2499.0
2012-05-25 08:00:00	YM	Futures	12479.6	12486.6	12441.8	12443.8	6656.0
2012-05-25 09:00:00	YM	Futures	12443.8	12465.7	12426.8	12452.7	22089.0
2012-05-25 10:00:00	YM	Futures	12452.7	12469.7	12418.9	12429.8	24103.0
2012-05-25 11:00:00	YM	Futures	12428.8	12459.7	12427.8	12442.8	13327.0
2012-05-25 12:00:00	YM	Futures	12442.8	12445.8	12409.9	12422.9	7454.0
2012-05-25 13:00:00	YM	Futures	12423.9	12430.8	12414.9	12418.9	4785.0
2012-05-25 14:00:00	YM	Futures	12418.9	12422.9	12377.0	12387.0	10308.0
2012-05-25 15:00:00	YM	Futures	12388.0	12398.9	12355.1	12385.0	17342.0

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

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