PREVIEW / futures_1hour / 2012-08-20

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-20.parquet
  size:    45 KB
  rows:    1,392

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-08-20 00:00:00	ES	Futures	1438.99	1439.5	1438.74	1438.99	1378.0
2012-08-20 01:00:00	ES	Futures	1438.99	1439.5	1438.48	1439.24	2098.0
2012-08-20 02:00:00	ES	Futures	1439.24	1440.52	1438.99	1440.26	5805.0
2012-08-20 03:00:00	ES	Futures	1440.01	1441.28	1439.24	1440.52	21046.0
2012-08-20 04:00:00	ES	Futures	1440.26	1441.28	1440.01	1441.02	16549.0
2012-08-20 05:00:00	ES	Futures	1441.02	1442.3	1440.77	1441.79	22290.0
2012-08-20 06:00:00	ES	Futures	1441.79	1441.79	1439.75	1440.52	19938.0
2012-08-20 07:00:00	ES	Futures	1440.52	1440.77	1437.46	1438.23	35783.0
2012-08-20 08:00:00	ES	Futures	1438.23	1438.99	1437.46	1437.46	29893.0
2012-08-20 09:00:00	ES	Futures	1437.46	1439.24	1435.18	1436.19	171120.0
2012-08-20 10:00:00	ES	Futures	1436.19	1436.7	1433.65	1436.19	233655.0
2012-08-20 11:00:00	ES	Futures	1436.45	1438.48	1435.18	1437.46	165073.0
2012-08-20 12:00:00	ES	Futures	1437.46	1438.99	1436.96	1437.46	66699.0
2012-08-20 13:00:00	ES	Futures	1437.21	1438.23	1436.45	1437.72	43545.0
2012-08-20 14:00:00	ES	Futures	1437.72	1440.01	1436.7	1438.74	73478.0
2012-08-20 15:00:00	ES	Futures	1438.74	1440.26	1437.72	1439.75	120897.0
2012-08-20 16:00:00	ES	Futures	1439.75	1440.52	1438.48	1439.24	56224.0
2012-08-20 17:00:00	ES	Futures	1439.24	1440.26	1439.24	1439.75	2311.0
2012-08-20 18:00:00	ES	Futures	1439.5	1440.26	1439.5	1439.75	2228.0
2012-08-20 19:00:00	ES	Futures	1439.75	1439.75	1439.24	1439.5	777.0
2012-08-20 20:00:00	ES	Futures	1439.5	1439.75	1438.74	1438.99	2605.0
2012-08-20 21:00:00	ES	Futures	1438.74	1439.24	1437.97	1438.99	5006.0
2012-08-20 22:00:00	ES	Futures	1439.24	1440.01	1439.24	1439.5	2028.0
2012-08-20 23:00:00	ES	Futures	1439.5	1440.01	1438.74	1438.99	2937.0
2012-08-20 00:00:00	NQ	Futures	3218.59	3220.33	3218.01	3219.46	235.0
2012-08-20 01:00:00	NQ	Futures	3219.46	3220.04	3218.3	3219.46	129.0
2012-08-20 02:00:00	NQ	Futures	3220.04	3221.78	3219.17	3220.62	524.0
2012-08-20 03:00:00	NQ	Futures	3220.62	3222.65	3219.17	3221.78	2004.0
2012-08-20 04:00:00	NQ	Futures	3221.49	3223.52	3220.62	3222.94	1256.0
2012-08-20 05:00:00	NQ	Futures	3223.23	3225.26	3222.94	3224.39	2016.0
2012-08-20 06:00:00	NQ	Futures	3224.1	3224.1	3219.75	3221.2	1781.0
2012-08-20 07:00:00	NQ	Futures	3221.2	3222.65	3216.27	3220.91	3178.0
2012-08-20 08:00:00	NQ	Futures	3220.91	3223.52	3219.17	3222.07	4095.0
2012-08-20 09:00:00	NQ	Futures	3222.36	3223.52	3209.61	3211.35	34411.0
2012-08-20 10:00:00	NQ	Futures	3211.06	3218.01	3208.45	3217.72	39712.0
2012-08-20 11:00:00	NQ	Futures	3217.72	3224.39	3213.95	3223.81	17990.0
2012-08-20 12:00:00	NQ	Futures	3223.52	3227.87	3217.14	3220.91	20511.0
2012-08-20 13:00:00	NQ	Futures	3220.91	3223.52	3215.4	3219.46	15914.0
2012-08-20 14:00:00	NQ	Futures	3219.17	3224.97	3217.72	3223.23	18531.0
2012-08-20 15:00:00	NQ	Futures	3223.23	3228.45	3219.46	3227.29	18167.0
2012-08-20 16:00:00	NQ	Futures	3227.29	3227.87	3223.23	3223.81	4873.0
2012-08-20 17:00:00	NQ	Futures	3223.81	3225.26	3223.81	3224.68	60.0
2012-08-20 18:00:00	NQ	Futures	3224.39	3227.58	3223.81	3226.71	560.0
2012-08-20 19:00:00	NQ	Futures	3226.71	3226.71	3225.26	3225.84	81.0
2012-08-20 20:00:00	NQ	Futures	3225.55	3225.84	3224.1	3224.68	203.0
2012-08-20 21:00:00	NQ	Futures	3224.68	3225.84	3223.23	3225.84	362.0
2012-08-20 22:00:00	NQ	Futures	3225.84	3227.58	3225.55	3226.42	228.0
2012-08-20 23:00:00	NQ	Futures	3226.13	3227.0	3224.68	3224.97	298.0
2012-08-20 00:00:00	YM	Futures	13172.9	13176.8	13171.9	13172.9	85.0
2012-08-20 01:00:00	YM	Futures	13174.8	13174.8	13168.9	13172.9	114.0

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

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