PREVIEW / futures_1hour / 2012-09-06

all futures 1-hour files

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

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-06 00:00:00	ES	Futures	1431.11	1431.36	1430.09	1430.6	1042.0
2012-09-06 01:00:00	ES	Futures	1430.85	1431.87	1430.34	1431.36	2542.0
2012-09-06 02:00:00	ES	Futures	1431.62	1432.12	1430.85	1432.12	5223.0
2012-09-06 03:00:00	ES	Futures	1432.12	1435.68	1430.6	1435.43	44844.0
2012-09-06 04:00:00	ES	Futures	1435.43	1437.21	1435.18	1436.96	34529.0
2012-09-06 05:00:00	ES	Futures	1436.7	1437.46	1434.92	1435.43	17388.0
2012-09-06 06:00:00	ES	Futures	1435.43	1436.96	1435.18	1435.68	15145.0
2012-09-06 07:00:00	ES	Futures	1435.68	1436.19	1431.87	1435.43	40116.0
2012-09-06 08:00:00	ES	Futures	1435.43	1438.23	1431.36	1433.9	178015.0
2012-09-06 09:00:00	ES	Futures	1433.9	1443.57	1433.65	1443.06	340604.0
2012-09-06 10:00:00	ES	Futures	1443.06	1453.48	1443.06	1452.72	424749.0
2012-09-06 11:00:00	ES	Futures	1452.72	1454.76	1450.69	1453.74	242226.0
2012-09-06 12:00:00	ES	Futures	1453.74	1455.26	1452.98	1454.25	117709.0
2012-09-06 13:00:00	ES	Futures	1454.25	1455.01	1453.23	1454.5	80464.0
2012-09-06 14:00:00	ES	Futures	1454.25	1455.26	1452.72	1453.99	97949.0
2012-09-06 15:00:00	ES	Futures	1453.99	1455.77	1451.96	1455.52	224426.0
2012-09-06 16:00:00	ES	Futures	1455.52	1457.04	1454.76	1456.79	106504.0
2012-09-06 17:00:00	ES	Futures	1456.79	1457.55	1456.79	1457.04	2624.0
2012-09-06 18:00:00	ES	Futures	1456.54	1456.54	1455.26	1455.52	5392.0
2012-09-06 19:00:00	ES	Futures	1455.52	1456.28	1455.26	1456.28	2888.0
2012-09-06 20:00:00	ES	Futures	1456.28	1456.54	1455.26	1456.28	5058.0
2012-09-06 21:00:00	ES	Futures	1456.28	1456.54	1455.01	1456.03	5175.0
2012-09-06 22:00:00	ES	Futures	1456.03	1457.04	1455.77	1456.28	3668.0
2012-09-06 23:00:00	ES	Futures	1456.28	1457.3	1455.52	1456.28	4968.0
2012-09-06 00:00:00	NQ	Futures	3215.4	3215.98	3214.24	3215.11	181.0
2012-09-06 01:00:00	NQ	Futures	3215.4	3217.43	3214.24	3216.85	181.0
2012-09-06 02:00:00	NQ	Futures	3216.56	3218.01	3215.69	3218.01	445.0
2012-09-06 03:00:00	NQ	Futures	3218.01	3226.13	3215.11	3225.84	4898.0
2012-09-06 04:00:00	NQ	Futures	3226.13	3230.77	3225.84	3228.45	3396.0
2012-09-06 05:00:00	NQ	Futures	3228.45	3229.9	3224.68	3225.84	2185.0
2012-09-06 06:00:00	NQ	Futures	3225.55	3229.9	3225.55	3227.0	1038.0
2012-09-06 07:00:00	NQ	Futures	3227.29	3227.87	3220.04	3225.55	3228.0
2012-09-06 08:00:00	NQ	Futures	3224.97	3230.19	3216.85	3223.81	14000.0
2012-09-06 09:00:00	NQ	Futures	3223.52	3246.42	3222.07	3245.84	48451.0
2012-09-06 10:00:00	NQ	Futures	3246.13	3267.58	3246.13	3267.29	55635.0
2012-09-06 11:00:00	NQ	Futures	3267.0	3274.25	3263.52	3272.8	44089.0
2012-09-06 12:00:00	NQ	Futures	3273.09	3278.02	3272.51	3273.96	17655.0
2012-09-06 13:00:00	NQ	Futures	3273.96	3278.89	3272.8	3277.15	12001.0
2012-09-06 14:00:00	NQ	Futures	3277.44	3280.92	3273.38	3277.44	15175.0
2012-09-06 15:00:00	NQ	Futures	3277.44	3280.34	3274.25	3278.31	31348.0
2012-09-06 16:00:00	NQ	Futures	3278.6	3280.92	3276.86	3280.92	9592.0
2012-09-06 17:00:00	NQ	Futures	3280.63	3281.5	3280.05	3280.05	312.0
2012-09-06 18:00:00	NQ	Futures	3279.18	3279.76	3277.15	3277.44	321.0
2012-09-06 19:00:00	NQ	Futures	3277.15	3278.02	3276.57	3277.15	471.0
2012-09-06 20:00:00	NQ	Futures	3277.15	3277.73	3275.99	3277.44	1508.0
2012-09-06 21:00:00	NQ	Futures	3277.44	3277.73	3274.25	3276.57	802.0
2012-09-06 22:00:00	NQ	Futures	3276.86	3278.6	3275.99	3277.15	592.0
2012-09-06 23:00:00	NQ	Futures	3277.44	3279.76	3275.99	3278.02	713.0
2012-09-06 00:00:00	YM	Futures	13002.8	13002.8	12991.9	12994.9	236.0
2012-09-06 01:00:00	YM	Futures	12996.8	13006.8	12993.9	13002.8	208.0

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

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