PREVIEW / futures_1hour / 2012-01-04

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-04.parquet
  size:    47 KB
  rows:    1,465

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
2012-01-04 00:00:00	ES	Futures	1281.86	1282.11	1280.6	1280.86	3103.0
2012-01-04 01:00:00	ES	Futures	1281.11	1281.11	1278.34	1279.6	8650.0
2012-01-04 02:00:00	ES	Futures	1279.6	1281.61	1277.83	1280.6	13717.0
2012-01-04 03:00:00	ES	Futures	1280.6	1284.63	1279.6	1280.6	37484.0
2012-01-04 04:00:00	ES	Futures	1280.35	1284.38	1279.6	1282.87	24729.0
2012-01-04 05:00:00	ES	Futures	1282.62	1284.89	1280.86	1281.11	23537.0
2012-01-04 06:00:00	ES	Futures	1281.11	1281.86	1278.08	1279.09	26526.0
2012-01-04 07:00:00	ES	Futures	1278.84	1281.61	1277.83	1279.09	27118.0
2012-01-04 08:00:00	ES	Futures	1279.34	1279.34	1276.07	1276.82	45064.0
2012-01-04 09:00:00	ES	Futures	1276.82	1280.35	1276.32	1279.34	179999.0
2012-01-04 10:00:00	ES	Futures	1279.34	1279.6	1272.79	1275.56	275882.0
2012-01-04 11:00:00	ES	Futures	1275.82	1279.6	1275.56	1278.84	189736.0
2012-01-04 12:00:00	ES	Futures	1278.84	1282.11	1278.34	1281.86	119797.0
2012-01-04 13:00:00	ES	Futures	1282.11	1283.12	1279.34	1282.62	97381.0
2012-01-04 14:00:00	ES	Futures	1282.37	1283.88	1280.35	1282.62	102772.0
2012-01-04 15:00:00	ES	Futures	1282.62	1283.88	1280.86	1282.62	154953.0
2012-01-04 16:00:00	ES	Futures	1282.37	1283.88	1282.11	1283.12	58573.0
2012-01-04 17:00:00	ES	Futures	1283.37	1283.37	1282.87	1283.12	674.0
2012-01-04 18:00:00	ES	Futures	1283.12	1283.12	1281.86	1282.62	4717.0
2012-01-04 19:00:00	ES	Futures	1282.37	1282.87	1281.86	1282.11	4279.0
2012-01-04 20:00:00	ES	Futures	1282.37	1282.62	1281.11	1282.11	4598.0
2012-01-04 21:00:00	ES	Futures	1282.11	1282.87	1281.86	1282.11	2520.0
2012-01-04 22:00:00	ES	Futures	1282.37	1282.37	1281.36	1281.61	2992.0
2012-01-04 23:00:00	ES	Futures	1281.61	1281.86	1279.6	1280.35	4615.0
2012-01-04 00:00:00	NQ	Futures	2674.27	2674.56	2671.96	2672.54	101.0
2012-01-04 01:00:00	NQ	Futures	2672.54	2672.54	2668.21	2670.81	341.0
2012-01-04 02:00:00	NQ	Futures	2670.81	2673.98	2667.92	2673.7	453.0
2012-01-04 03:00:00	NQ	Futures	2673.98	2685.54	2673.98	2676.87	2504.0
2012-01-04 04:00:00	NQ	Futures	2676.87	2684.67	2674.56	2681.2	1196.0
2012-01-04 05:00:00	NQ	Futures	2680.63	2684.67	2674.85	2676.01	1704.0
2012-01-04 06:00:00	NQ	Futures	2676.01	2678.6	2672.25	2674.85	1631.0
2012-01-04 07:00:00	NQ	Futures	2674.27	2678.6	2673.41	2675.14	3208.0
2012-01-04 08:00:00	NQ	Futures	2675.43	2675.43	2669.07	2669.94	3826.0
2012-01-04 09:00:00	NQ	Futures	2669.94	2674.85	2662.43	2670.81	22970.0
2012-01-04 10:00:00	NQ	Futures	2670.52	2671.38	2659.83	2669.36	23181.0
2012-01-04 11:00:00	NQ	Futures	2669.36	2681.2	2668.79	2678.6	16001.0
2012-01-04 12:00:00	NQ	Futures	2678.6	2686.69	2677.74	2686.11	14599.0
2012-01-04 13:00:00	NQ	Futures	2686.11	2688.14	2679.76	2686.4	12351.0
2012-01-04 14:00:00	NQ	Futures	2686.69	2690.73	2680.34	2688.42	13134.0
2012-01-04 15:00:00	NQ	Futures	2688.42	2689.0	2682.07	2686.98	17236.0
2012-01-04 16:00:00	NQ	Futures	2686.98	2691.02	2686.4	2689.87	6990.0
2012-01-04 17:00:00	NQ	Futures	2689.87	2690.16	2689.0	2690.16	55.0
2012-01-04 18:00:00	NQ	Futures	2689.29	2690.45	2688.42	2689.0	226.0
2012-01-04 19:00:00	NQ	Futures	2689.0	2689.87	2688.14	2688.71	177.0
2012-01-04 20:00:00	NQ	Futures	2689.29	2689.29	2687.27	2689.0	219.0
2012-01-04 21:00:00	NQ	Futures	2689.0	2690.73	2688.71	2690.45	295.0
2012-01-04 22:00:00	NQ	Futures	2689.87	2690.16	2688.14	2688.42	153.0
2012-01-04 23:00:00	NQ	Futures	2688.14	2688.42	2684.96	2686.11	341.0
2012-01-04 00:00:00	YM	Futures	12228.6	12228.6	12216.7	12217.7	157.0
2012-01-04 01:00:00	YM	Futures	12217.7	12217.7	12192.9	12205.8	563.0

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

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