PREVIEW / futures_1hour / 2012-09-10

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-10.parquet
  size:    41 KB
  rows:    1,283

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-09-10 00:00:00	ES	Futures	1457.81	1458.32	1457.55	1457.81	2073.0
2012-09-10 01:00:00	ES	Futures	1457.81	1458.57	1457.55	1457.55	2659.0
2012-09-10 02:00:00	ES	Futures	1457.81	1458.57	1457.55	1458.32	5051.0
2012-09-10 03:00:00	ES	Futures	1458.32	1460.35	1457.81	1458.32	28060.0
2012-09-10 04:00:00	ES	Futures	1458.32	1459.84	1457.81	1459.84	14383.0
2012-09-10 05:00:00	ES	Futures	1459.84	1460.6	1459.08	1459.84	9728.0
2012-09-10 06:00:00	ES	Futures	1459.84	1460.6	1459.59	1460.35	9580.0
2012-09-10 07:00:00	ES	Futures	1460.35	1460.35	1459.08	1460.35	14115.0
2012-09-10 08:00:00	ES	Futures	1460.35	1460.35	1458.57	1458.82	29642.0
2012-09-10 09:00:00	ES	Futures	1458.57	1461.11	1458.06	1460.35	149696.0
2012-09-10 10:00:00	ES	Futures	1460.1	1462.64	1459.59	1460.6	165890.0
2012-09-10 11:00:00	ES	Futures	1460.6	1462.13	1459.84	1461.11	85523.0
2012-09-10 12:00:00	ES	Futures	1460.86	1461.62	1459.33	1460.6	61263.0
2012-09-10 13:00:00	ES	Futures	1460.6	1461.62	1458.57	1458.57	56928.0
2012-09-10 14:00:00	ES	Futures	1458.57	1459.84	1457.3	1457.3	85333.0
2012-09-10 15:00:00	ES	Futures	1457.55	1458.06	1452.72	1453.23	216685.0
2012-09-10 16:00:00	ES	Futures	1453.23	1453.48	1448.65	1448.91	82615.0
2012-09-10 17:00:00	ES	Futures	1448.91	1450.18	1448.91	1449.92	2387.0
2012-09-10 18:00:00	ES	Futures	1450.18	1450.69	1449.67	1450.43	4487.0
2012-09-10 19:00:00	ES	Futures	1450.43	1451.2	1450.18	1450.43	2490.0
2012-09-10 20:00:00	ES	Futures	1450.43	1450.94	1449.42	1450.94	3865.0
2012-09-10 21:00:00	ES	Futures	1450.69	1450.94	1448.4	1449.42	8616.0
2012-09-10 22:00:00	ES	Futures	1449.16	1449.42	1447.64	1447.64	9733.0
2012-09-10 23:00:00	ES	Futures	1447.64	1447.89	1445.86	1446.62	9594.0
2012-09-10 00:00:00	NQ	Futures	3265.55	3267.0	3265.26	3266.13	189.0
2012-09-10 01:00:00	NQ	Futures	3265.84	3267.0	3265.26	3265.84	189.0
2012-09-10 02:00:00	NQ	Futures	3265.84	3267.58	3265.55	3266.42	546.0
2012-09-10 03:00:00	NQ	Futures	3266.42	3269.9	3264.97	3264.97	2717.0
2012-09-10 04:00:00	NQ	Futures	3264.97	3267.58	3264.1	3266.71	1696.0
2012-09-10 05:00:00	NQ	Futures	3267.0	3268.74	3265.55	3267.29	921.0
2012-09-10 06:00:00	NQ	Futures	3267.0	3268.74	3267.0	3267.58	1068.0
2012-09-10 07:00:00	NQ	Futures	3267.58	3268.16	3266.13	3268.16	1306.0
2012-09-10 08:00:00	NQ	Futures	3268.45	3268.74	3265.55	3266.13	3297.0
2012-09-10 09:00:00	NQ	Futures	3266.13	3274.25	3261.21	3262.95	36731.0
2012-09-10 10:00:00	NQ	Futures	3262.95	3267.87	3253.38	3256.57	36729.0
2012-09-10 11:00:00	NQ	Futures	3256.86	3262.08	3254.25	3261.21	13698.0
2012-09-10 12:00:00	NQ	Futures	3261.5	3261.79	3252.22	3256.57	11351.0
2012-09-10 13:00:00	NQ	Futures	3256.57	3259.18	3246.71	3247.29	10493.0
2012-09-10 14:00:00	NQ	Futures	3247.0	3250.19	3238.3	3238.59	20482.0
2012-09-10 15:00:00	NQ	Futures	3238.59	3242.94	3231.35	3233.67	33523.0
2012-09-10 16:00:00	NQ	Futures	3233.96	3234.83	3225.55	3227.87	8671.0
2012-09-10 17:00:00	NQ	Futures	3227.58	3229.61	3227.29	3229.61	363.0
2012-09-10 18:00:00	NQ	Futures	3229.32	3230.77	3229.03	3230.19	301.0
2012-09-10 19:00:00	NQ	Futures	3230.48	3231.93	3229.03	3229.61	209.0
2012-09-10 20:00:00	NQ	Futures	3229.61	3231.64	3228.45	3231.64	256.0
2012-09-10 21:00:00	NQ	Futures	3231.06	3231.06	3226.71	3228.45	528.0
2012-09-10 22:00:00	NQ	Futures	3228.16	3228.45	3225.55	3225.84	775.0
2012-09-10 23:00:00	NQ	Futures	3225.84	3225.84	3220.91	3222.65	849.0
2012-09-10 00:00:00	YM	Futures	13184.8	13184.8	13184.8	13184.8	1.0
2012-09-10 01:00:00	YM	Futures	13184.8	13193.8	13184.8	13193.8	2.0

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

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