PREVIEW / futures_1hour / 2011-10-20

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-20.parquet
  size:    50 KB
  rows:    1,485

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-20 00:00:00	ES	Futures	1210.16	1210.16	1207.15	1208.15	6180.0
2011-10-20 01:00:00	ES	Futures	1207.9	1208.9	1205.39	1205.39	8868.0
2011-10-20 02:00:00	ES	Futures	1205.39	1209.16	1204.64	1207.65	14578.0
2011-10-20 03:00:00	ES	Futures	1207.65	1210.91	1205.14	1209.41	44959.0
2011-10-20 04:00:00	ES	Futures	1209.66	1213.92	1208.4	1210.16	37786.0
2011-10-20 05:00:00	ES	Futures	1209.91	1219.94	1208.15	1215.17	58214.0
2011-10-20 06:00:00	ES	Futures	1215.17	1219.44	1214.67	1217.18	32473.0
2011-10-20 07:00:00	ES	Futures	1216.93	1217.18	1211.66	1215.93	42910.0
2011-10-20 08:00:00	ES	Futures	1215.68	1218.18	1214.17	1215.93	55960.0
2011-10-20 09:00:00	ES	Futures	1215.93	1217.43	1206.65	1208.65	338557.0
2011-10-20 10:00:00	ES	Futures	1208.4	1216.18	1204.39	1204.64	499549.0
2011-10-20 11:00:00	ES	Futures	1204.64	1206.4	1198.87	1200.63	402521.0
2011-10-20 12:00:00	ES	Futures	1200.88	1206.15	1196.12	1205.14	261250.0
2011-10-20 13:00:00	ES	Futures	1205.14	1215.42	1204.14	1210.16	418459.0
2011-10-20 14:00:00	ES	Futures	1209.91	1219.19	1206.9	1216.93	259489.0
2011-10-20 15:00:00	ES	Futures	1216.93	1217.68	1210.16	1214.17	292282.0
2011-10-20 16:00:00	ES	Futures	1214.17	1215.17	1211.66	1213.67	77962.0
2011-10-20 17:00:00	ES	Futures	1213.42	1213.92	1212.67	1212.67	1749.0
2011-10-20 18:00:00	ES	Futures	1212.92	1214.42	1212.92	1213.42	2149.0
2011-10-20 19:00:00	ES	Futures	1213.42	1214.17	1212.92	1214.17	2820.0
2011-10-20 20:00:00	ES	Futures	1213.92	1216.68	1213.67	1214.92	8611.0
2011-10-20 21:00:00	ES	Futures	1214.92	1217.93	1214.92	1216.93	7995.0
2011-10-20 22:00:00	ES	Futures	1216.68	1218.93	1216.43	1217.68	6535.0
2011-10-20 23:00:00	ES	Futures	1217.68	1218.43	1214.92	1215.17	6683.0
2011-10-20 00:00:00	NQ	Futures	2671.6	2672.17	2666.41	2668.42	421.0
2011-10-20 01:00:00	NQ	Futures	2668.14	2669.87	2662.95	2662.95	620.0
2011-10-20 02:00:00	NQ	Futures	2662.95	2671.02	2660.64	2667.27	962.0
2011-10-20 03:00:00	NQ	Futures	2667.27	2675.06	2660.93	2669.87	3783.0
2011-10-20 04:00:00	NQ	Futures	2670.44	2677.07	2665.83	2669.29	2362.0
2011-10-20 05:00:00	NQ	Futures	2669.0	2690.34	2666.12	2681.69	3203.0
2011-10-20 06:00:00	NQ	Futures	2681.98	2690.05	2680.53	2687.45	2220.0
2011-10-20 07:00:00	NQ	Futures	2687.17	2687.17	2673.04	2681.98	3028.0
2011-10-20 08:00:00	NQ	Futures	2681.98	2685.15	2676.79	2680.25	3634.0
2011-10-20 09:00:00	NQ	Futures	2679.96	2681.98	2647.38	2653.43	53647.0
2011-10-20 10:00:00	NQ	Futures	2654.01	2668.14	2644.21	2644.49	57879.0
2011-10-20 11:00:00	NQ	Futures	2644.49	2644.78	2626.62	2631.52	46173.0
2011-10-20 12:00:00	NQ	Futures	2631.81	2639.3	2616.24	2638.44	39375.0
2011-10-20 13:00:00	NQ	Futures	2638.44	2660.35	2637.0	2651.7	49896.0
2011-10-20 14:00:00	NQ	Futures	2651.41	2665.54	2646.51	2662.66	31162.0
2011-10-20 15:00:00	NQ	Futures	2662.37	2664.1	2647.95	2655.16	36385.0
2011-10-20 16:00:00	NQ	Futures	2655.45	2657.47	2647.38	2650.55	7924.0
2011-10-20 17:00:00	NQ	Futures	2650.26	2651.41	2649.68	2649.68	205.0
2011-10-20 18:00:00	NQ	Futures	2650.26	2651.7	2649.68	2651.41	168.0
2011-10-20 19:00:00	NQ	Futures	2651.41	2654.58	2650.55	2653.72	347.0
2011-10-20 20:00:00	NQ	Futures	2653.43	2659.77	2652.86	2658.04	668.0
2011-10-20 21:00:00	NQ	Futures	2657.47	2662.95	2657.47	2661.22	565.0
2011-10-20 22:00:00	NQ	Futures	2660.93	2664.96	2660.64	2662.95	537.0
2011-10-20 23:00:00	NQ	Futures	2662.66	2663.52	2656.6	2656.6	346.0
2011-10-20 00:00:00	YM	Futures	11261.4	11264.4	11237.8	11246.6	486.0
2011-10-20 01:00:00	YM	Futures	11242.7	11251.6	11226.0	11227.9	835.0

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

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