PREVIEW / futures_1hour / 2012-08-06

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-06.parquet
  size:    46 KB
  rows:    1,427

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-06 00:00:00	ES	Futures	1412.8	1413.82	1412.54	1413.56	1810.0
2012-08-06 01:00:00	ES	Futures	1413.56	1414.32	1412.54	1412.8	4158.0
2012-08-06 02:00:00	ES	Futures	1412.54	1414.58	1412.04	1412.54	5531.0
2012-08-06 03:00:00	ES	Futures	1412.29	1413.05	1411.27	1412.04	24219.0
2012-08-06 04:00:00	ES	Futures	1412.04	1416.1	1411.02	1414.58	31356.0
2012-08-06 05:00:00	ES	Futures	1414.83	1415.85	1414.07	1415.34	18173.0
2012-08-06 06:00:00	ES	Futures	1415.34	1415.85	1414.83	1415.34	10446.0
2012-08-06 07:00:00	ES	Futures	1415.09	1416.87	1414.83	1416.36	17004.0
2012-08-06 08:00:00	ES	Futures	1416.36	1416.61	1414.83	1415.6	28186.0
2012-08-06 09:00:00	ES	Futures	1415.34	1419.41	1413.56	1417.63	195589.0
2012-08-06 10:00:00	ES	Futures	1417.38	1419.66	1416.61	1418.14	237569.0
2012-08-06 11:00:00	ES	Futures	1417.88	1418.9	1416.1	1417.63	150514.0
2012-08-06 12:00:00	ES	Futures	1417.88	1419.66	1416.61	1419.16	59040.0
2012-08-06 13:00:00	ES	Futures	1419.16	1419.66	1417.12	1417.63	49940.0
2012-08-06 14:00:00	ES	Futures	1417.88	1419.16	1417.63	1418.39	44424.0
2012-08-06 15:00:00	ES	Futures	1418.39	1419.16	1413.31	1414.07	191671.0
2012-08-06 16:00:00	ES	Futures	1414.07	1414.83	1412.54	1413.05	70187.0
2012-08-06 17:00:00	ES	Futures	1413.05	1413.31	1412.29	1412.29	2203.0
2012-08-06 18:00:00	ES	Futures	1412.8	1413.56	1412.8	1413.31	1842.0
2012-08-06 19:00:00	ES	Futures	1413.31	1413.56	1412.8	1412.8	1376.0
2012-08-06 20:00:00	ES	Futures	1412.8	1413.05	1411.78	1412.29	3436.0
2012-08-06 21:00:00	ES	Futures	1412.04	1414.32	1411.27	1414.07	5541.0
2012-08-06 22:00:00	ES	Futures	1413.82	1414.83	1413.82	1414.58	1785.0
2012-08-06 23:00:00	ES	Futures	1414.58	1415.09	1413.56	1415.09	2739.0
2012-08-06 00:00:00	NQ	Futures	3100.03	3104.67	3099.74	3103.22	690.0
2012-08-06 01:00:00	NQ	Futures	3103.22	3106.41	3101.77	3103.22	837.0
2012-08-06 02:00:00	NQ	Futures	3103.51	3107.28	3102.93	3103.8	667.0
2012-08-06 03:00:00	NQ	Futures	3103.51	3105.83	3101.77	3104.96	3466.0
2012-08-06 04:00:00	NQ	Futures	3104.67	3113.07	3103.22	3109.31	3595.0
2012-08-06 05:00:00	NQ	Futures	3109.31	3112.78	3108.15	3111.34	1684.0
2012-08-06 06:00:00	NQ	Futures	3111.34	3111.92	3109.89	3110.18	1270.0
2012-08-06 07:00:00	NQ	Futures	3110.18	3113.07	3109.6	3111.92	1566.0
2012-08-06 08:00:00	NQ	Futures	3111.63	3112.49	3107.57	3110.47	3592.0
2012-08-06 09:00:00	NQ	Futures	3109.89	3119.45	3104.38	3113.65	26678.0
2012-08-06 10:00:00	NQ	Futures	3113.94	3122.64	3113.94	3119.16	26834.0
2012-08-06 11:00:00	NQ	Futures	3119.16	3126.7	3117.42	3126.12	17591.0
2012-08-06 12:00:00	NQ	Futures	3126.12	3132.79	3122.93	3131.34	16456.0
2012-08-06 13:00:00	NQ	Futures	3131.34	3131.92	3125.54	3127.28	9858.0
2012-08-06 14:00:00	NQ	Futures	3127.57	3130.76	3126.41	3128.15	9113.0
2012-08-06 15:00:00	NQ	Futures	3128.15	3129.6	3115.97	3118.29	25969.0
2012-08-06 16:00:00	NQ	Futures	3118.0	3118.87	3114.81	3116.84	7284.0
2012-08-06 17:00:00	NQ	Futures	3117.13	3117.71	3116.55	3116.55	68.0
2012-08-06 18:00:00	NQ	Futures	3116.55	3117.71	3116.26	3117.71	259.0
2012-08-06 19:00:00	NQ	Futures	3117.42	3118.0	3116.26	3116.26	136.0
2012-08-06 20:00:00	NQ	Futures	3116.26	3116.84	3115.39	3116.26	342.0
2012-08-06 21:00:00	NQ	Futures	3116.26	3121.48	3114.81	3120.9	905.0
2012-08-06 22:00:00	NQ	Futures	3120.9	3122.93	3120.9	3122.35	448.0
2012-08-06 23:00:00	NQ	Futures	3122.35	3123.22	3120.32	3123.22	615.0
2012-08-06 00:00:00	YM	Futures	12977.9	12985.9	12976.0	12981.9	159.0
2012-08-06 01:00:00	YM	Futures	12981.9	12990.9	12977.9	12979.9	548.0

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

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