PREVIEW / futures_1hour / 2012-08-24

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-24.parquet
  size:    40 KB
  rows:    1,156

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-24 00:00:00	ES	Futures	1424.75	1425.26	1423.99	1424.5	2360.0
2012-08-24 01:00:00	ES	Futures	1424.5	1426.28	1424.24	1426.02	3410.0
2012-08-24 02:00:00	ES	Futures	1426.02	1426.53	1424.24	1425.0	11709.0
2012-08-24 03:00:00	ES	Futures	1425.0	1425.51	1422.21	1422.72	32798.0
2012-08-24 04:00:00	ES	Futures	1422.97	1424.75	1421.95	1423.99	16986.0
2012-08-24 05:00:00	ES	Futures	1424.24	1425.0	1423.48	1423.73	10139.0
2012-08-24 06:00:00	ES	Futures	1423.73	1424.24	1422.21	1422.72	11497.0
2012-08-24 07:00:00	ES	Futures	1422.72	1423.48	1420.17	1421.44	26628.0
2012-08-24 08:00:00	ES	Futures	1421.7	1423.73	1419.16	1419.92	67579.0
2012-08-24 09:00:00	ES	Futures	1419.66	1422.46	1419.41	1420.17	147096.0
2012-08-24 10:00:00	ES	Futures	1420.17	1427.29	1419.66	1426.02	277479.0
2012-08-24 11:00:00	ES	Futures	1426.28	1432.12	1426.02	1429.58	379032.0
2012-08-24 12:00:00	ES	Futures	1429.58	1432.63	1429.33	1432.38	107940.0
2012-08-24 13:00:00	ES	Futures	1432.12	1435.18	1431.11	1433.65	99440.0
2012-08-24 14:00:00	ES	Futures	1433.9	1433.9	1431.11	1431.87	56191.0
2012-08-24 15:00:00	ES	Futures	1431.87	1436.19	1430.85	1432.89	219807.0
2012-08-24 16:00:00	ES	Futures	1433.14	1434.92	1432.89	1434.67	69242.0
2012-08-24 00:00:00	NQ	Futures	3203.52	3204.68	3202.65	3203.23	986.0
2012-08-24 01:00:00	NQ	Futures	3203.23	3208.16	3202.65	3208.16	693.0
2012-08-24 02:00:00	NQ	Futures	3208.16	3209.32	3205.55	3207.29	1482.0
2012-08-24 03:00:00	NQ	Futures	3207.29	3207.87	3199.46	3201.49	2865.0
2012-08-24 04:00:00	NQ	Futures	3201.78	3205.26	3200.04	3204.39	1416.0
2012-08-24 05:00:00	NQ	Futures	3204.1	3206.13	3201.49	3201.78	1752.0
2012-08-24 06:00:00	NQ	Futures	3202.07	3204.1	3200.04	3200.91	1710.0
2012-08-24 07:00:00	NQ	Futures	3201.2	3203.52	3195.4	3198.59	2478.0
2012-08-24 08:00:00	NQ	Futures	3198.88	3204.39	3193.37	3194.53	8104.0
2012-08-24 09:00:00	NQ	Futures	3194.53	3198.88	3189.31	3191.34	29067.0
2012-08-24 10:00:00	NQ	Futures	3191.34	3215.11	3190.47	3211.93	36491.0
2012-08-24 11:00:00	NQ	Futures	3211.93	3223.81	3210.19	3217.14	33798.0
2012-08-24 12:00:00	NQ	Futures	3217.14	3224.68	3215.11	3224.1	13455.0
2012-08-24 13:00:00	NQ	Futures	3224.1	3229.61	3219.17	3224.39	11701.0
2012-08-24 14:00:00	NQ	Futures	3224.68	3224.97	3218.88	3220.33	7541.0
2012-08-24 15:00:00	NQ	Futures	3220.62	3226.42	3215.69	3221.2	25964.0
2012-08-24 16:00:00	NQ	Futures	3220.91	3221.78	3217.72	3220.91	6949.0
2012-08-24 00:00:00	YM	Futures	12977.0	12977.9	12969.0	12973.0	335.0
2012-08-24 01:00:00	YM	Futures	12972.0	12985.9	12970.0	12985.9	312.0
2012-08-24 02:00:00	YM	Futures	12984.9	12988.9	12976.0	12980.9	843.0
2012-08-24 03:00:00	YM	Futures	12979.9	12981.9	12956.1	12963.0	2028.0
2012-08-24 04:00:00	YM	Futures	12964.0	12976.0	12959.1	12973.0	1154.0
2012-08-24 05:00:00	YM	Futures	12973.0	12979.9	12970.0	12972.0	741.0
2012-08-24 06:00:00	YM	Futures	12973.0	12977.9	12963.0	12963.0	912.0
2012-08-24 07:00:00	YM	Futures	12962.0	12969.0	12945.1	12954.1	2105.0
2012-08-24 08:00:00	YM	Futures	12955.1	12971.0	12938.2	12945.1	5085.0
2012-08-24 09:00:00	YM	Futures	12945.1	12965.0	12938.2	12942.2	13942.0
2012-08-24 10:00:00	YM	Futures	12943.1	13006.8	12939.2	12997.8	20486.0
2012-08-24 11:00:00	YM	Futures	12997.8	13058.5	12996.8	13030.7	22702.0
2012-08-24 12:00:00	YM	Futures	13031.6	13053.5	13027.7	13046.6	6421.0
2012-08-24 13:00:00	YM	Futures	13045.6	13073.4	13037.6	13062.5	7013.0
2012-08-24 14:00:00	YM	Futures	13063.5	13065.5	13045.6	13050.5	3919.0
2012-08-24 15:00:00	YM	Futures	13050.5	13088.3	13042.6	13068.4	13437.0

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

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