PREVIEW / futures_1hour / 2012-08-30

all futures 1-hour files

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

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-30 00:00:00	ES	Futures	1426.02	1426.78	1425.51	1425.77	3397.0
2012-08-30 01:00:00	ES	Futures	1425.77	1428.56	1425.77	1428.06	6060.0
2012-08-30 02:00:00	ES	Futures	1428.06	1428.31	1426.53	1427.04	7323.0
2012-08-30 03:00:00	ES	Futures	1427.29	1428.82	1426.53	1428.56	18902.0
2012-08-30 04:00:00	ES	Futures	1428.31	1428.56	1426.53	1427.04	10418.0
2012-08-30 05:00:00	ES	Futures	1427.04	1428.31	1427.04	1427.55	11244.0
2012-08-30 06:00:00	ES	Futures	1427.55	1428.06	1425.0	1425.77	14713.0
2012-08-30 07:00:00	ES	Futures	1425.77	1426.78	1425.0	1426.02	17702.0
2012-08-30 08:00:00	ES	Futures	1426.02	1427.8	1425.26	1425.51	30052.0
2012-08-30 09:00:00	ES	Futures	1425.51	1426.78	1423.73	1424.5	159911.0
2012-08-30 10:00:00	ES	Futures	1424.75	1425.77	1419.16	1420.94	275826.0
2012-08-30 11:00:00	ES	Futures	1421.19	1423.99	1420.68	1422.21	172078.0
2012-08-30 12:00:00	ES	Futures	1422.21	1423.22	1420.94	1423.22	62692.0
2012-08-30 13:00:00	ES	Futures	1423.22	1423.22	1420.94	1422.97	57755.0
2012-08-30 14:00:00	ES	Futures	1422.97	1424.75	1422.46	1424.24	67095.0
2012-08-30 15:00:00	ES	Futures	1424.5	1426.53	1421.7	1422.21	182640.0
2012-08-30 16:00:00	ES	Futures	1422.46	1422.46	1419.66	1420.17	78847.0
2012-08-30 17:00:00	ES	Futures	1420.43	1420.94	1420.17	1420.17	1163.0
2012-08-30 18:00:00	ES	Futures	1420.68	1420.94	1419.41	1419.92	3038.0
2012-08-30 19:00:00	ES	Futures	1419.92	1420.43	1419.41	1420.17	2011.0
2012-08-30 20:00:00	ES	Futures	1420.17	1422.46	1419.92	1422.21	7466.0
2012-08-30 21:00:00	ES	Futures	1422.21	1422.72	1421.44	1421.95	3746.0
2012-08-30 22:00:00	ES	Futures	1421.95	1422.21	1420.94	1421.44	3487.0
2012-08-30 23:00:00	ES	Futures	1421.44	1422.46	1420.68	1421.95	2703.0
2012-08-30 00:00:00	NQ	Futures	3215.4	3216.56	3214.24	3215.4	324.0
2012-08-30 01:00:00	NQ	Futures	3214.82	3219.75	3214.24	3218.88	444.0
2012-08-30 02:00:00	NQ	Futures	3218.3	3218.88	3216.27	3218.01	520.0
2012-08-30 03:00:00	NQ	Futures	3218.01	3219.75	3215.69	3219.17	1766.0
2012-08-30 04:00:00	NQ	Futures	3218.88	3219.17	3214.53	3215.11	1205.0
2012-08-30 05:00:00	NQ	Futures	3215.11	3218.3	3215.11	3215.98	1014.0
2012-08-30 06:00:00	NQ	Futures	3215.98	3216.56	3210.48	3211.93	1860.0
2012-08-30 07:00:00	NQ	Futures	3211.93	3213.95	3210.48	3211.64	1815.0
2012-08-30 08:00:00	NQ	Futures	3211.64	3215.98	3210.19	3212.51	5878.0
2012-08-30 09:00:00	NQ	Futures	3212.22	3215.4	3205.55	3206.71	26194.0
2012-08-30 10:00:00	NQ	Futures	3206.42	3208.45	3189.02	3194.53	36731.0
2012-08-30 11:00:00	NQ	Futures	3194.53	3200.91	3193.95	3195.69	17659.0
2012-08-30 12:00:00	NQ	Futures	3195.98	3196.85	3191.63	3195.4	9481.0
2012-08-30 13:00:00	NQ	Futures	3195.11	3195.98	3189.6	3195.69	9503.0
2012-08-30 14:00:00	NQ	Futures	3195.4	3200.91	3194.82	3200.04	12570.0
2012-08-30 15:00:00	NQ	Futures	3200.04	3204.1	3192.21	3194.24	25373.0
2012-08-30 16:00:00	NQ	Futures	3194.24	3195.69	3190.76	3192.79	9699.0
2012-08-30 17:00:00	NQ	Futures	3193.37	3193.66	3192.79	3192.79	48.0
2012-08-30 18:00:00	NQ	Futures	3193.66	3193.66	3191.05	3192.21	251.0
2012-08-30 19:00:00	NQ	Futures	3192.21	3193.08	3191.34	3192.79	131.0
2012-08-30 20:00:00	NQ	Futures	3192.5	3197.43	3192.5	3197.14	560.0
2012-08-30 21:00:00	NQ	Futures	3197.14	3197.72	3195.69	3196.56	563.0
2012-08-30 22:00:00	NQ	Futures	3196.56	3196.85	3194.53	3195.4	365.0
2012-08-30 23:00:00	NQ	Futures	3195.4	3197.72	3194.53	3197.43	374.0
2012-08-30 00:00:00	YM	Futures	12966.0	12972.0	12963.0	12967.0	511.0
2012-08-30 01:00:00	YM	Futures	12967.0	12986.9	12967.0	12981.9	669.0

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

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