PREVIEW / futures_1hour / 2011-01-25

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-25.parquet
  size:    50 KB
  rows:    1,500

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-25 00:00:00	ES	Futures	1275.49	1276.48	1274.99	1276.23	3830.0
2011-01-25 01:00:00	ES	Futures	1276.48	1278.46	1275.49	1275.98	13146.0
2011-01-25 02:00:00	ES	Futures	1275.98	1278.21	1275.24	1276.48	10119.0
2011-01-25 03:00:00	ES	Futures	1276.72	1276.97	1273.01	1274.74	22338.0
2011-01-25 04:00:00	ES	Futures	1274.5	1275.24	1269.55	1269.8	36690.0
2011-01-25 05:00:00	ES	Futures	1269.8	1271.53	1269.3	1269.55	20521.0
2011-01-25 06:00:00	ES	Futures	1269.3	1272.02	1269.3	1271.28	23909.0
2011-01-25 07:00:00	ES	Futures	1271.28	1271.78	1269.8	1269.8	25308.0
2011-01-25 08:00:00	ES	Futures	1270.04	1270.29	1268.56	1269.05	43199.0
2011-01-25 09:00:00	ES	Futures	1268.81	1273.51	1268.56	1273.51	205795.0
2011-01-25 10:00:00	ES	Futures	1273.51	1275.24	1269.3	1272.76	327223.0
2011-01-25 11:00:00	ES	Futures	1272.76	1273.01	1265.09	1266.58	384195.0
2011-01-25 12:00:00	ES	Futures	1266.33	1271.53	1266.33	1270.54	244405.0
2011-01-25 13:00:00	ES	Futures	1270.29	1270.79	1268.06	1269.8	127219.0
2011-01-25 14:00:00	ES	Futures	1270.04	1270.04	1263.86	1266.58	368979.0
2011-01-25 15:00:00	ES	Futures	1266.58	1274.74	1266.33	1274.25	393614.0
2011-01-25 16:00:00	ES	Futures	1274.5	1274.99	1273.26	1273.75	89756.0
2011-01-25 17:00:00	ES	Futures	1273.51	1274.5	1273.51	1274.25	2335.0
2011-01-25 18:00:00	ES	Futures	1274.25	1274.5	1273.01	1273.01	2477.0
2011-01-25 19:00:00	ES	Futures	1273.01	1274.5	1272.76	1274.25	3349.0
2011-01-25 20:00:00	ES	Futures	1274.25	1275.49	1273.75	1275.24	4969.0
2011-01-25 21:00:00	ES	Futures	1275.24	1277.47	1274.74	1275.49	6690.0
2011-01-25 22:00:00	ES	Futures	1275.49	1276.48	1275.24	1276.23	2847.0
2011-01-25 23:00:00	ES	Futures	1275.98	1277.96	1275.98	1277.22	3513.0
2011-01-25 00:00:00	NQ	Futures	2637.25	2639.55	2636.97	2639.55	592.0
2011-01-25 01:00:00	NQ	Futures	2639.26	2644.43	2638.4	2638.69	1312.0
2011-01-25 02:00:00	NQ	Futures	2638.69	2641.27	2637.54	2637.83	1033.0
2011-01-25 03:00:00	NQ	Futures	2638.12	2638.98	2631.23	2634.67	2164.0
2011-01-25 04:00:00	NQ	Futures	2634.96	2635.82	2624.05	2624.62	3052.0
2011-01-25 05:00:00	NQ	Futures	2624.34	2628.07	2624.05	2624.05	1022.0
2011-01-25 06:00:00	NQ	Futures	2624.62	2629.5	2623.76	2628.93	1598.0
2011-01-25 07:00:00	NQ	Futures	2628.93	2629.5	2626.06	2626.35	1976.0
2011-01-25 08:00:00	NQ	Futures	2626.35	2626.92	2619.17	2620.89	5990.0
2011-01-25 09:00:00	NQ	Futures	2620.89	2636.68	2620.89	2635.82	36026.0
2011-01-25 10:00:00	NQ	Futures	2636.11	2639.26	2626.35	2636.97	47416.0
2011-01-25 11:00:00	NQ	Futures	2637.25	2637.54	2622.9	2626.06	31525.0
2011-01-25 12:00:00	NQ	Futures	2626.35	2638.12	2626.06	2635.53	19513.0
2011-01-25 13:00:00	NQ	Futures	2635.53	2636.11	2630.37	2633.52	12913.0
2011-01-25 14:00:00	NQ	Futures	2633.52	2633.52	2620.03	2626.35	32420.0
2011-01-25 15:00:00	NQ	Futures	2626.63	2643.28	2626.06	2642.13	41030.0
2011-01-25 16:00:00	NQ	Futures	2642.13	2642.99	2638.98	2639.84	9012.0
2011-01-25 17:00:00	NQ	Futures	2639.84	2641.85	2639.26	2641.27	429.0
2011-01-25 18:00:00	NQ	Futures	2641.27	2642.71	2639.26	2639.26	169.0
2011-01-25 19:00:00	NQ	Futures	2639.26	2641.85	2638.4	2641.27	200.0
2011-01-25 20:00:00	NQ	Futures	2641.27	2644.72	2640.7	2644.72	590.0
2011-01-25 21:00:00	NQ	Futures	2644.14	2648.16	2643.57	2644.72	500.0
2011-01-25 22:00:00	NQ	Futures	2644.72	2645.87	2643.28	2644.72	278.0
2011-01-25 23:00:00	NQ	Futures	2645.0	2648.16	2644.72	2646.15	359.0
2011-01-25 00:00:00	YM	Futures	11429.2	11435.0	11425.4	11435.0	166.0
2011-01-25 01:00:00	YM	Futures	11434.0	11445.5	11428.3	11432.1	587.0

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

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