PREVIEW / futures_1hour / 2012-09-05

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-05.parquet
  size:    47 KB
  rows:    1,438

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-05 00:00:00	ES	Futures	1427.04	1427.04	1424.75	1425.51	5240.0
2012-09-05 01:00:00	ES	Futures	1425.51	1425.77	1424.24	1425.0	4716.0
2012-09-05 02:00:00	ES	Futures	1425.0	1426.02	1423.99	1424.5	8884.0
2012-09-05 03:00:00	ES	Futures	1424.75	1426.28	1422.97	1423.73	22217.0
2012-09-05 04:00:00	ES	Futures	1423.48	1423.48	1421.19	1422.21	25655.0
2012-09-05 05:00:00	ES	Futures	1422.46	1428.06	1422.21	1428.06	32601.0
2012-09-05 06:00:00	ES	Futures	1428.06	1428.31	1426.78	1427.55	15736.0
2012-09-05 07:00:00	ES	Futures	1427.55	1427.8	1424.5	1425.0	38032.0
2012-09-05 08:00:00	ES	Futures	1425.0	1430.34	1424.24	1429.58	126394.0
2012-09-05 09:00:00	ES	Futures	1429.33	1430.6	1423.73	1426.78	192882.0
2012-09-05 10:00:00	ES	Futures	1426.78	1432.38	1425.77	1426.53	368136.0
2012-09-05 11:00:00	ES	Futures	1426.28	1430.85	1425.26	1429.07	144152.0
2012-09-05 12:00:00	ES	Futures	1429.07	1430.09	1428.56	1429.33	45282.0
2012-09-05 13:00:00	ES	Futures	1429.33	1429.58	1423.99	1425.77	103647.0
2012-09-05 14:00:00	ES	Futures	1425.77	1428.06	1424.75	1427.04	69191.0
2012-09-05 15:00:00	ES	Futures	1427.29	1428.06	1425.26	1426.53	130506.0
2012-09-05 16:00:00	ES	Futures	1426.28	1429.58	1426.02	1429.07	53355.0
2012-09-05 17:00:00	ES	Futures	1429.07	1429.33	1428.06	1428.31	1003.0
2012-09-05 18:00:00	ES	Futures	1428.56	1429.33	1427.8	1428.06	3409.0
2012-09-05 19:00:00	ES	Futures	1427.8	1428.56	1427.29	1428.31	2020.0
2012-09-05 20:00:00	ES	Futures	1428.56	1429.84	1427.29	1429.58	6427.0
2012-09-05 21:00:00	ES	Futures	1429.84	1431.87	1428.82	1431.36	10363.0
2012-09-05 22:00:00	ES	Futures	1431.62	1433.14	1431.36	1431.62	7321.0
2012-09-05 23:00:00	ES	Futures	1431.62	1431.62	1430.09	1431.11	2291.0
2012-09-05 00:00:00	NQ	Futures	3212.51	3212.51	3207.58	3208.74	463.0
2012-09-05 01:00:00	NQ	Futures	3208.74	3209.03	3205.55	3206.71	362.0
2012-09-05 02:00:00	NQ	Futures	3207.0	3208.45	3204.97	3205.84	625.0
2012-09-05 03:00:00	NQ	Futures	3205.55	3209.03	3200.91	3202.36	3275.0
2012-09-05 04:00:00	NQ	Futures	3202.07	3202.07	3196.85	3199.17	3131.0
2012-09-05 05:00:00	NQ	Futures	3198.88	3211.35	3198.88	3211.35	3624.0
2012-09-05 06:00:00	NQ	Futures	3211.35	3211.93	3209.03	3210.48	1861.0
2012-09-05 07:00:00	NQ	Futures	3210.77	3210.77	3202.36	3202.36	5893.0
2012-09-05 08:00:00	NQ	Futures	3202.36	3213.66	3201.78	3211.93	12068.0
2012-09-05 09:00:00	NQ	Futures	3212.22	3216.56	3199.75	3214.53	36131.0
2012-09-05 10:00:00	NQ	Futures	3214.53	3224.39	3207.29	3207.58	50782.0
2012-09-05 11:00:00	NQ	Futures	3207.58	3220.33	3202.65	3216.85	24628.0
2012-09-05 12:00:00	NQ	Futures	3216.85	3222.65	3215.98	3219.75	9716.0
2012-09-05 13:00:00	NQ	Futures	3219.75	3220.33	3204.68	3208.74	17385.0
2012-09-05 14:00:00	NQ	Futures	3208.74	3215.11	3206.13	3211.93	15343.0
2012-09-05 15:00:00	NQ	Futures	3211.93	3212.8	3204.39	3208.16	24256.0
2012-09-05 16:00:00	NQ	Futures	3208.16	3212.22	3207.29	3211.35	4492.0
2012-09-05 17:00:00	NQ	Futures	3211.64	3211.64	3209.61	3209.9	51.0
2012-09-05 18:00:00	NQ	Futures	3210.19	3211.35	3209.32	3209.61	131.0
2012-09-05 19:00:00	NQ	Futures	3209.03	3210.77	3208.45	3210.48	171.0
2012-09-05 20:00:00	NQ	Futures	3210.48	3213.37	3208.74	3213.08	434.0
2012-09-05 21:00:00	NQ	Futures	3212.8	3218.01	3211.06	3217.43	860.0
2012-09-05 22:00:00	NQ	Futures	3217.43	3220.33	3216.27	3216.56	664.0
2012-09-05 23:00:00	NQ	Futures	3215.98	3216.27	3213.37	3215.4	364.0
2012-09-05 00:00:00	YM	Futures	12947.1	12952.1	12935.2	12942.2	498.0
2012-09-05 01:00:00	YM	Futures	12941.2	12943.1	12930.2	12940.2	479.0

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

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