PREVIEW / futures_1hour / 2012-05-28

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-28.parquet
  size:    33 KB
  rows:    955

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-28 00:00:00	ES	Futures	1341.32	1341.83	1340.82	1341.83	1557.0
2012-05-28 01:00:00	ES	Futures	1341.58	1343.85	1341.07	1343.09	4414.0
2012-05-28 02:00:00	ES	Futures	1342.84	1343.85	1341.83	1341.83	7328.0
2012-05-28 03:00:00	ES	Futures	1341.83	1344.36	1340.06	1340.56	19044.0
2012-05-28 04:00:00	ES	Futures	1340.56	1341.07	1338.54	1339.81	11499.0
2012-05-28 05:00:00	ES	Futures	1339.81	1343.35	1339.3	1343.09	12360.0
2012-05-28 06:00:00	ES	Futures	1342.84	1344.11	1339.81	1340.56	10806.0
2012-05-28 07:00:00	ES	Futures	1340.56	1341.32	1339.81	1340.06	4967.0
2012-05-28 08:00:00	ES	Futures	1340.06	1340.56	1339.3	1340.06	4442.0
2012-05-28 09:00:00	ES	Futures	1340.06	1340.31	1335.5	1339.81	23109.0
2012-05-28 10:00:00	ES	Futures	1339.81	1339.81	1335.5	1338.79	13967.0
2012-05-28 11:00:00	ES	Futures	1338.79	1339.05	1336.77	1337.28	4903.0
2012-05-28 18:00:00	ES	Futures	1336.77	1338.79	1336.26	1337.28	3599.0
2012-05-28 19:00:00	ES	Futures	1337.28	1338.03	1335.0	1335.76	3672.0
2012-05-28 20:00:00	ES	Futures	1335.76	1336.77	1333.23	1336.77	8035.0
2012-05-28 21:00:00	ES	Futures	1336.77	1339.05	1336.01	1338.54	5361.0
2012-05-28 22:00:00	ES	Futures	1338.54	1338.54	1337.02	1338.29	3163.0
2012-05-28 23:00:00	ES	Futures	1338.29	1340.82	1337.78	1340.31	4752.0
2012-05-28 00:00:00	NQ	Futures	2941.75	2942.9	2939.72	2942.62	201.0
2012-05-28 01:00:00	NQ	Futures	2942.04	2949.85	2942.04	2947.24	747.0
2012-05-28 02:00:00	NQ	Futures	2947.24	2948.4	2944.64	2944.64	864.0
2012-05-28 03:00:00	NQ	Futures	2944.64	2948.98	2940.01	2942.62	1745.0
2012-05-28 04:00:00	NQ	Futures	2941.46	2942.62	2936.83	2940.3	931.0
2012-05-28 05:00:00	NQ	Futures	2940.88	2942.9	2937.7	2941.75	1188.0
2012-05-28 06:00:00	NQ	Futures	2941.75	2946.95	2939.15	2940.88	1049.0
2012-05-28 07:00:00	NQ	Futures	2940.88	2942.33	2939.72	2940.01	567.0
2012-05-28 08:00:00	NQ	Futures	2940.01	2942.62	2938.57	2941.17	469.0
2012-05-28 09:00:00	NQ	Futures	2940.59	2943.48	2931.05	2943.19	2956.0
2012-05-28 10:00:00	NQ	Futures	2942.9	2943.19	2934.52	2940.01	1186.0
2012-05-28 11:00:00	NQ	Futures	2940.3	2941.75	2937.12	2937.12	694.0
2012-05-28 18:00:00	NQ	Futures	2935.96	2939.15	2933.65	2935.39	580.0
2012-05-28 19:00:00	NQ	Futures	2935.39	2937.12	2932.2	2933.07	367.0
2012-05-28 20:00:00	NQ	Futures	2932.78	2936.25	2928.44	2935.96	1079.0
2012-05-28 21:00:00	NQ	Futures	2936.25	2942.33	2935.39	2940.59	915.0
2012-05-28 22:00:00	NQ	Futures	2940.59	2940.88	2937.99	2939.72	461.0
2012-05-28 23:00:00	NQ	Futures	2939.72	2944.64	2938.57	2944.06	492.0
2012-05-28 00:00:00	YM	Futures	12454.7	12461.7	12453.7	12460.7	137.0
2012-05-28 01:00:00	YM	Futures	12457.7	12477.7	12450.8	12469.7	883.0
2012-05-28 02:00:00	YM	Futures	12471.7	12477.7	12461.7	12462.7	643.0
2012-05-28 03:00:00	YM	Futures	12462.7	12480.6	12448.8	12450.8	1306.0
2012-05-28 04:00:00	YM	Futures	12450.8	12455.7	12435.8	12448.8	1176.0
2012-05-28 05:00:00	YM	Futures	12452.7	12472.7	12439.8	12467.7	1249.0
2012-05-28 06:00:00	YM	Futures	12466.7	12475.7	12446.8	12457.7	887.0
2012-05-28 07:00:00	YM	Futures	12457.7	12463.7	12449.8	12450.8	390.0
2012-05-28 08:00:00	YM	Futures	12449.8	12457.7	12446.8	12454.7	400.0
2012-05-28 09:00:00	YM	Futures	12451.8	12453.7	12408.9	12446.8	2715.0
2012-05-28 10:00:00	YM	Futures	12445.8	12445.8	12410.9	12435.8	942.0
2012-05-28 11:00:00	YM	Futures	12435.8	12437.8	12419.9	12427.8	530.0
2012-05-28 18:00:00	YM	Futures	12425.8	12438.8	12421.9	12429.8	264.0
2012-05-28 19:00:00	YM	Futures	12428.8	12430.8	12410.9	12413.9	235.0

> showing 50 of 955 rows — these rows as CSV

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