PREVIEW / futures_1hour / 2011-09-02

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-02.parquet
  size:    40 KB
  rows:    1,163

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-09-02 00:00:00	ES	Futures	1192.41	1194.4	1192.41	1193.41	3222.0
2011-09-02 01:00:00	ES	Futures	1193.41	1195.4	1192.66	1193.41	6565.0
2011-09-02 02:00:00	ES	Futures	1193.41	1196.9	1192.41	1196.65	12770.0
2011-09-02 03:00:00	ES	Futures	1196.4	1198.39	1191.16	1192.16	52382.0
2011-09-02 04:00:00	ES	Futures	1192.16	1192.41	1188.42	1189.66	37041.0
2011-09-02 05:00:00	ES	Futures	1189.66	1190.91	1186.92	1189.66	23507.0
2011-09-02 06:00:00	ES	Futures	1189.42	1189.66	1186.92	1188.42	23949.0
2011-09-02 07:00:00	ES	Futures	1188.42	1190.91	1188.17	1189.66	25822.0
2011-09-02 08:00:00	ES	Futures	1189.66	1195.65	1176.94	1179.69	212654.0
2011-09-02 09:00:00	ES	Futures	1179.69	1181.18	1172.46	1177.19	410840.0
2011-09-02 10:00:00	ES	Futures	1176.94	1182.43	1172.46	1177.69	392719.0
2011-09-02 11:00:00	ES	Futures	1177.69	1182.18	1176.45	1178.44	229680.0
2011-09-02 12:00:00	ES	Futures	1178.44	1181.93	1177.94	1178.94	121075.0
2011-09-02 13:00:00	ES	Futures	1178.94	1179.94	1173.2	1174.7	115087.0
2011-09-02 14:00:00	ES	Futures	1174.7	1175.7	1166.47	1168.46	247185.0
2011-09-02 15:00:00	ES	Futures	1168.46	1173.95	1165.72	1169.96	327091.0
2011-09-02 16:00:00	ES	Futures	1169.71	1170.21	1165.72	1166.97	101185.0
2011-09-02 00:00:00	NQ	Futures	2541.54	2545.28	2541.54	2543.27	229.0
2011-09-02 01:00:00	NQ	Futures	2543.85	2546.72	2542.12	2542.98	323.0
2011-09-02 02:00:00	NQ	Futures	2543.56	2549.89	2540.1	2549.31	1072.0
2011-09-02 03:00:00	NQ	Futures	2549.6	2552.19	2536.94	2539.24	3223.0
2011-09-02 04:00:00	NQ	Futures	2538.67	2540.1	2530.61	2533.49	1759.0
2011-09-02 05:00:00	NQ	Futures	2533.49	2536.65	2529.17	2533.49	1015.0
2011-09-02 06:00:00	NQ	Futures	2533.77	2534.35	2527.44	2530.32	2748.0
2011-09-02 07:00:00	NQ	Futures	2530.61	2536.36	2530.32	2533.77	2030.0
2011-09-02 08:00:00	NQ	Futures	2533.49	2546.44	2509.31	2517.37	18784.0
2011-09-02 09:00:00	NQ	Futures	2517.08	2520.25	2498.38	2509.31	49820.0
2011-09-02 10:00:00	NQ	Futures	2509.03	2520.54	2499.24	2509.03	41264.0
2011-09-02 11:00:00	NQ	Futures	2509.03	2516.51	2507.01	2508.45	24499.0
2011-09-02 12:00:00	NQ	Futures	2508.45	2514.78	2508.45	2509.89	17861.0
2011-09-02 13:00:00	NQ	Futures	2510.18	2511.33	2495.79	2498.38	19048.0
2011-09-02 14:00:00	NQ	Futures	2498.38	2500.1	2483.41	2486.29	33599.0
2011-09-02 15:00:00	NQ	Futures	2486.29	2502.69	2481.4	2494.64	38878.0
2011-09-02 16:00:00	NQ	Futures	2494.64	2497.23	2490.03	2492.91	9475.0
2011-09-02 00:00:00	YM	Futures	11062.0	11074.6	11061.1	11067.8	244.0
2011-09-02 01:00:00	YM	Futures	11067.8	11083.3	11062.0	11066.9	335.0
2011-09-02 02:00:00	YM	Futures	11066.9	11093.0	11058.2	11091.1	581.0
2011-09-02 03:00:00	YM	Futures	11090.1	11103.7	11051.4	11058.2	2068.0
2011-09-02 04:00:00	YM	Futures	11058.2	11060.1	11028.1	11037.8	1016.0
2011-09-02 05:00:00	YM	Futures	11034.9	11043.6	11015.5	11036.8	506.0
2011-09-02 06:00:00	YM	Futures	11033.0	11036.8	11009.7	11023.3	792.0
2011-09-02 07:00:00	YM	Futures	11022.3	11043.6	11021.4	11033.9	847.0
2011-09-02 08:00:00	YM	Futures	11032.0	11154.0	10931.3	10954.5	8877.0
2011-09-02 09:00:00	YM	Futures	10954.5	10966.2	10878.0	10910.0	23416.0
2011-09-02 10:00:00	YM	Futures	10909.0	10956.5	10883.8	10924.5	19461.0
2011-09-02 11:00:00	YM	Futures	10924.5	10972.9	10916.8	10937.1	13916.0
2011-09-02 12:00:00	YM	Futures	10937.1	10970.0	10930.3	10942.9	7049.0
2011-09-02 13:00:00	YM	Futures	10943.9	10951.6	10905.1	10923.5	6193.0
2011-09-02 14:00:00	YM	Futures	10922.6	10929.4	10852.9	10867.4	12629.0
2011-09-02 15:00:00	YM	Futures	10866.4	10913.9	10845.1	10876.1	16176.0

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

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