PREVIEW / futures_1hour / 2011-01-24

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-24.parquet
  size:    48 KB
  rows:    1,451

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-01-24 00:00:00	ES	Futures	1269.8	1270.79	1269.55	1270.54	2508.0
2011-01-24 01:00:00	ES	Futures	1270.79	1272.02	1270.29	1271.03	6119.0
2011-01-24 02:00:00	ES	Futures	1271.28	1271.28	1269.05	1269.3	6776.0
2011-01-24 03:00:00	ES	Futures	1269.55	1271.28	1266.08	1267.57	28289.0
2011-01-24 04:00:00	ES	Futures	1267.57	1268.06	1265.34	1267.32	18120.0
2011-01-24 05:00:00	ES	Futures	1267.32	1267.82	1265.59	1266.83	11279.0
2011-01-24 06:00:00	ES	Futures	1266.83	1267.32	1265.09	1265.34	10624.0
2011-01-24 07:00:00	ES	Futures	1265.59	1268.06	1265.09	1267.82	15102.0
2011-01-24 08:00:00	ES	Futures	1268.06	1268.81	1266.58	1267.82	25540.0
2011-01-24 09:00:00	ES	Futures	1267.82	1269.55	1265.59	1266.33	218380.0
2011-01-24 10:00:00	ES	Futures	1266.58	1270.79	1265.59	1270.29	231833.0
2011-01-24 11:00:00	ES	Futures	1270.54	1273.51	1269.55	1272.27	241824.0
2011-01-24 12:00:00	ES	Futures	1272.52	1274.74	1272.27	1272.52	164183.0
2011-01-24 13:00:00	ES	Futures	1272.76	1274.74	1272.27	1273.51	127526.0
2011-01-24 14:00:00	ES	Futures	1273.75	1275.49	1272.27	1272.76	141386.0
2011-01-24 15:00:00	ES	Futures	1272.52	1274.5	1270.54	1274.25	253667.0
2011-01-24 16:00:00	ES	Futures	1274.0	1276.48	1273.75	1274.5	107647.0
2011-01-24 17:00:00	ES	Futures	1274.5	1274.74	1274.25	1274.74	685.0
2011-01-24 18:00:00	ES	Futures	1274.74	1275.24	1274.25	1274.5	3147.0
2011-01-24 19:00:00	ES	Futures	1274.25	1275.49	1274.25	1275.24	4423.0
2011-01-24 20:00:00	ES	Futures	1275.24	1275.73	1274.25	1274.74	3852.0
2011-01-24 21:00:00	ES	Futures	1274.99	1274.99	1274.25	1274.99	3134.0
2011-01-24 22:00:00	ES	Futures	1274.99	1275.73	1274.74	1274.99	3105.0
2011-01-24 23:00:00	ES	Futures	1274.99	1275.49	1274.74	1275.49	1348.0
2011-01-24 00:00:00	NQ	Futures	2610.56	2613.14	2609.99	2612.28	354.0
2011-01-24 01:00:00	NQ	Futures	2612.86	2616.01	2612.28	2614.29	513.0
2011-01-24 02:00:00	NQ	Futures	2614.29	2614.87	2610.27	2611.13	831.0
2011-01-24 03:00:00	NQ	Futures	2610.85	2614.29	2604.53	2606.54	2427.0
2011-01-24 04:00:00	NQ	Futures	2606.83	2607.69	2602.24	2606.54	1134.0
2011-01-24 05:00:00	NQ	Futures	2606.54	2607.69	2601.95	2605.97	1237.0
2011-01-24 06:00:00	NQ	Futures	2605.39	2606.83	2602.81	2603.38	1150.0
2011-01-24 07:00:00	NQ	Futures	2603.38	2607.69	2602.24	2607.69	1260.0
2011-01-24 08:00:00	NQ	Futures	2607.69	2608.55	2603.96	2605.68	2613.0
2011-01-24 09:00:00	NQ	Futures	2605.68	2616.87	2602.52	2605.11	32809.0
2011-01-24 10:00:00	NQ	Futures	2605.11	2617.16	2602.81	2615.44	30856.0
2011-01-24 11:00:00	NQ	Futures	2615.44	2629.79	2614.0	2628.64	35256.0
2011-01-24 12:00:00	NQ	Futures	2628.64	2636.11	2628.36	2633.24	26191.0
2011-01-24 13:00:00	NQ	Futures	2633.24	2639.55	2632.37	2634.67	24984.0
2011-01-24 14:00:00	NQ	Futures	2634.67	2639.55	2633.81	2636.11	18278.0
2011-01-24 15:00:00	NQ	Futures	2636.11	2638.98	2631.23	2638.69	28997.0
2011-01-24 16:00:00	NQ	Futures	2638.69	2641.56	2634.38	2635.82	12603.0
2011-01-24 17:00:00	NQ	Futures	2636.11	2636.97	2635.53	2636.68	208.0
2011-01-24 18:00:00	NQ	Futures	2636.97	2637.83	2634.96	2635.82	213.0
2011-01-24 19:00:00	NQ	Futures	2636.11	2637.54	2635.53	2636.97	310.0
2011-01-24 20:00:00	NQ	Futures	2636.68	2637.83	2635.53	2635.82	302.0
2011-01-24 21:00:00	NQ	Futures	2636.11	2636.97	2634.67	2636.97	253.0
2011-01-24 22:00:00	NQ	Futures	2636.97	2638.12	2636.39	2636.68	161.0
2011-01-24 23:00:00	NQ	Futures	2636.97	2638.12	2636.11	2636.68	162.0
2011-01-24 00:00:00	YM	Futures	11344.9	11358.3	11344.0	11356.4	372.0
2011-01-24 01:00:00	YM	Futures	11356.4	11368.9	11353.6	11358.3	399.0

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

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