PREVIEW / futures_1hour / 2011-10-12

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-12.parquet
  size:    51 KB
  rows:    1,492

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-10-12 00:00:00	ES	Futures	1188.84	1190.6	1188.84	1189.09	3281.0
2011-10-12 01:00:00	ES	Futures	1188.84	1192.1	1188.84	1190.1	5493.0
2011-10-12 02:00:00	ES	Futures	1190.35	1194.36	1189.6	1193.36	17867.0
2011-10-12 03:00:00	ES	Futures	1193.36	1193.61	1188.09	1192.61	40015.0
2011-10-12 04:00:00	ES	Futures	1192.86	1202.38	1192.1	1201.13	67358.0
2011-10-12 05:00:00	ES	Futures	1201.13	1206.65	1200.88	1205.39	57189.0
2011-10-12 06:00:00	ES	Futures	1205.64	1207.4	1203.39	1204.89	41614.0
2011-10-12 07:00:00	ES	Futures	1204.89	1205.9	1201.13	1201.38	42616.0
2011-10-12 08:00:00	ES	Futures	1201.13	1205.39	1200.13	1204.64	65264.0
2011-10-12 09:00:00	ES	Futures	1204.89	1207.15	1201.38	1206.4	335026.0
2011-10-12 10:00:00	ES	Futures	1206.4	1213.42	1203.14	1208.15	441784.0
2011-10-12 11:00:00	ES	Futures	1208.15	1213.17	1208.15	1210.41	227053.0
2011-10-12 12:00:00	ES	Futures	1210.41	1215.68	1208.65	1214.67	163193.0
2011-10-12 13:00:00	ES	Futures	1214.42	1217.43	1212.92	1213.67	157601.0
2011-10-12 14:00:00	ES	Futures	1213.67	1219.69	1211.16	1212.16	244118.0
2011-10-12 15:00:00	ES	Futures	1212.16	1214.42	1205.14	1205.39	449955.0
2011-10-12 16:00:00	ES	Futures	1205.39	1207.65	1200.13	1202.38	146439.0
2011-10-12 17:00:00	ES	Futures	1202.38	1203.14	1201.88	1202.64	2246.0
2011-10-12 18:00:00	ES	Futures	1202.38	1203.64	1202.13	1203.64	5263.0
2011-10-12 19:00:00	ES	Futures	1203.64	1203.64	1201.88	1202.38	3667.0
2011-10-12 20:00:00	ES	Futures	1202.13	1202.64	1200.13	1201.88	9104.0
2011-10-12 21:00:00	ES	Futures	1201.88	1201.88	1199.88	1201.13	7289.0
2011-10-12 22:00:00	ES	Futures	1201.38	1203.14	1200.38	1201.63	5994.0
2011-10-12 23:00:00	ES	Futures	1201.63	1203.14	1200.88	1202.64	3597.0
2011-10-12 00:00:00	NQ	Futures	2633.25	2637.0	2633.25	2634.4	251.0
2011-10-12 01:00:00	NQ	Futures	2634.11	2640.17	2634.11	2637.29	502.0
2011-10-12 02:00:00	NQ	Futures	2637.29	2645.07	2635.56	2642.48	1407.0
2011-10-12 03:00:00	NQ	Futures	2642.48	2643.05	2631.81	2641.9	3661.0
2011-10-12 04:00:00	NQ	Futures	2641.9	2661.5	2640.46	2658.62	4844.0
2011-10-12 05:00:00	NQ	Futures	2658.62	2669.29	2658.04	2668.42	4931.0
2011-10-12 06:00:00	NQ	Futures	2668.42	2673.04	2664.39	2666.69	3140.0
2011-10-12 07:00:00	NQ	Futures	2666.69	2671.6	2662.37	2663.23	5500.0
2011-10-12 08:00:00	NQ	Futures	2662.95	2672.46	2660.93	2671.31	6478.0
2011-10-12 09:00:00	NQ	Futures	2671.31	2674.48	2660.06	2671.6	45867.0
2011-10-12 10:00:00	NQ	Futures	2671.6	2683.71	2662.66	2669.29	50461.0
2011-10-12 11:00:00	NQ	Futures	2669.0	2681.4	2669.0	2673.61	23627.0
2011-10-12 12:00:00	NQ	Futures	2673.61	2679.09	2668.71	2677.36	18440.0
2011-10-12 13:00:00	NQ	Futures	2677.65	2684.86	2672.75	2673.9	21322.0
2011-10-12 14:00:00	NQ	Futures	2674.48	2686.01	2660.06	2664.1	38599.0
2011-10-12 15:00:00	NQ	Futures	2663.81	2673.04	2652.57	2656.03	60452.0
2011-10-12 16:00:00	NQ	Futures	2656.03	2660.06	2646.8	2651.41	11349.0
2011-10-12 17:00:00	NQ	Futures	2651.13	2652.28	2650.55	2651.7	117.0
2011-10-12 18:00:00	NQ	Futures	2649.68	2654.3	2649.4	2653.14	353.0
2011-10-12 19:00:00	NQ	Futures	2653.43	2654.01	2650.26	2651.13	306.0
2011-10-12 20:00:00	NQ	Futures	2650.55	2651.7	2647.38	2649.68	680.0
2011-10-12 21:00:00	NQ	Futures	2649.97	2650.55	2645.65	2649.11	698.0
2011-10-12 22:00:00	NQ	Futures	2649.11	2653.43	2647.67	2650.26	672.0
2011-10-12 23:00:00	NQ	Futures	2650.55	2654.01	2649.11	2652.86	389.0
2011-10-12 00:00:00	YM	Futures	11122.6	11135.4	11122.6	11124.5	361.0
2011-10-12 01:00:00	YM	Futures	11125.5	11153.1	11125.5	11141.3	617.0

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

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