PREVIEW / futures_1hour / 2012-09-04

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-04.parquet
  size:    46 KB
  rows:    1,422

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-04 00:00:00	ES	Futures	1431.11	1431.87	1430.09	1431.11	3040.0
2012-09-04 01:00:00	ES	Futures	1431.11	1432.12	1430.85	1431.11	4314.0
2012-09-04 02:00:00	ES	Futures	1431.11	1433.14	1431.11	1432.63	7173.0
2012-09-04 03:00:00	ES	Futures	1432.63	1432.63	1430.34	1431.62	19336.0
2012-09-04 04:00:00	ES	Futures	1431.62	1432.63	1429.84	1430.09	16871.0
2012-09-04 05:00:00	ES	Futures	1430.09	1431.36	1429.58	1431.11	12182.0
2012-09-04 06:00:00	ES	Futures	1431.36	1431.36	1426.53	1427.04	25033.0
2012-09-04 07:00:00	ES	Futures	1427.29	1429.84	1426.78	1429.33	21860.0
2012-09-04 08:00:00	ES	Futures	1429.33	1429.84	1427.55	1427.8	22869.0
2012-09-04 09:00:00	ES	Futures	1427.8	1429.33	1425.77	1427.29	150783.0
2012-09-04 10:00:00	ES	Futures	1427.04	1427.8	1418.39	1419.66	403493.0
2012-09-04 11:00:00	ES	Futures	1419.66	1422.46	1418.9	1421.44	148106.0
2012-09-04 12:00:00	ES	Futures	1421.7	1422.46	1420.17	1422.21	63980.0
2012-09-04 13:00:00	ES	Futures	1422.21	1423.73	1421.7	1422.72	60920.0
2012-09-04 14:00:00	ES	Futures	1422.72	1432.38	1421.95	1429.84	226962.0
2012-09-04 15:00:00	ES	Futures	1430.09	1431.36	1426.78	1427.04	194601.0
2012-09-04 16:00:00	ES	Futures	1426.78	1430.6	1426.02	1428.06	98551.0
2012-09-04 17:00:00	ES	Futures	1428.06	1430.09	1427.8	1428.06	6356.0
2012-09-04 18:00:00	ES	Futures	1428.06	1429.58	1427.55	1428.56	5068.0
2012-09-04 19:00:00	ES	Futures	1428.56	1428.82	1427.29	1427.55	3452.0
2012-09-04 20:00:00	ES	Futures	1427.55	1428.31	1426.53	1428.06	5979.0
2012-09-04 21:00:00	ES	Futures	1428.31	1428.56	1426.78	1427.29	5889.0
2012-09-04 22:00:00	ES	Futures	1427.55	1428.06	1426.28	1428.06	4193.0
2012-09-04 23:00:00	ES	Futures	1427.8	1428.06	1426.53	1426.78	3156.0
2012-09-04 00:00:00	NQ	Futures	3222.65	3223.52	3220.33	3222.65	314.0
2012-09-04 01:00:00	NQ	Futures	3223.23	3224.39	3221.78	3222.94	277.0
2012-09-04 02:00:00	NQ	Futures	3222.94	3226.13	3222.65	3225.26	490.0
2012-09-04 03:00:00	NQ	Futures	3225.26	3225.55	3220.04	3223.52	2713.0
2012-09-04 04:00:00	NQ	Futures	3223.52	3224.97	3218.88	3219.17	1846.0
2012-09-04 05:00:00	NQ	Futures	3219.46	3221.49	3218.01	3221.2	925.0
2012-09-04 06:00:00	NQ	Futures	3221.49	3221.78	3210.19	3211.35	2422.0
2012-09-04 07:00:00	NQ	Futures	3211.35	3215.69	3209.61	3215.4	2354.0
2012-09-04 08:00:00	NQ	Futures	3215.11	3215.98	3208.74	3208.74	3197.0
2012-09-04 09:00:00	NQ	Futures	3209.03	3214.82	3201.49	3210.77	24529.0
2012-09-04 10:00:00	NQ	Futures	3210.77	3213.66	3180.33	3184.1	50941.0
2012-09-04 11:00:00	NQ	Futures	3183.81	3193.37	3180.91	3191.92	27826.0
2012-09-04 12:00:00	NQ	Futures	3192.21	3196.56	3188.15	3195.69	14593.0
2012-09-04 13:00:00	NQ	Futures	3195.98	3201.49	3195.69	3198.59	10148.0
2012-09-04 14:00:00	NQ	Futures	3198.59	3224.1	3197.72	3219.17	33962.0
2012-09-04 15:00:00	NQ	Futures	3219.17	3221.49	3212.22	3212.8	31211.0
2012-09-04 16:00:00	NQ	Futures	3212.8	3219.75	3209.9	3215.11	9064.0
2012-09-04 17:00:00	NQ	Futures	3215.69	3218.01	3214.82	3215.11	150.0
2012-09-04 18:00:00	NQ	Futures	3215.11	3217.14	3214.24	3215.69	188.0
2012-09-04 19:00:00	NQ	Futures	3215.11	3215.69	3212.22	3212.51	256.0
2012-09-04 20:00:00	NQ	Futures	3212.22	3215.11	3211.06	3215.11	333.0
2012-09-04 21:00:00	NQ	Futures	3215.4	3216.27	3211.06	3213.08	471.0
2012-09-04 22:00:00	NQ	Futures	3213.08	3214.82	3210.77	3214.24	245.0
2012-09-04 23:00:00	NQ	Futures	3214.24	3214.24	3211.93	3212.22	183.0
2012-09-04 00:00:00	YM	Futures	13023.7	13027.7	13015.7	13021.7	302.0
2012-09-04 01:00:00	YM	Futures	13022.7	13032.6	13020.7	13026.7	739.0

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

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