PREVIEW / futures_1hour / 2012-08-27

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-27.parquet
  size:    43 KB
  rows:    1,324

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-27 00:00:00	ES	Futures	1435.68	1436.45	1435.18	1435.43	1705.0
2012-08-27 01:00:00	ES	Futures	1435.43	1435.68	1433.9	1434.16	3167.0
2012-08-27 02:00:00	ES	Futures	1434.16	1434.41	1433.14	1433.65	5620.0
2012-08-27 03:00:00	ES	Futures	1433.65	1435.43	1432.89	1434.67	14883.0
2012-08-27 04:00:00	ES	Futures	1434.67	1436.7	1434.41	1435.94	8963.0
2012-08-27 05:00:00	ES	Futures	1435.94	1435.94	1433.9	1434.67	7953.0
2012-08-27 06:00:00	ES	Futures	1434.67	1438.23	1434.67	1437.72	14088.0
2012-08-27 07:00:00	ES	Futures	1437.72	1438.48	1436.7	1437.46	18110.0
2012-08-27 08:00:00	ES	Futures	1437.46	1440.26	1436.96	1437.21	42891.0
2012-08-27 09:00:00	ES	Futures	1437.46	1437.97	1432.12	1432.12	137228.0
2012-08-27 10:00:00	ES	Futures	1432.12	1433.9	1431.36	1433.14	137392.0
2012-08-27 11:00:00	ES	Futures	1432.89	1438.74	1432.63	1436.96	171587.0
2012-08-27 12:00:00	ES	Futures	1436.96	1437.97	1435.94	1436.7	41072.0
2012-08-27 13:00:00	ES	Futures	1436.45	1437.72	1434.92	1435.43	40182.0
2012-08-27 14:00:00	ES	Futures	1435.68	1436.96	1434.16	1435.94	38152.0
2012-08-27 15:00:00	ES	Futures	1435.94	1436.19	1431.11	1432.89	168787.0
2012-08-27 16:00:00	ES	Futures	1433.14	1433.14	1431.62	1432.12	50454.0
2012-08-27 17:00:00	ES	Futures	1432.12	1432.89	1432.12	1432.63	778.0
2012-08-27 18:00:00	ES	Futures	1432.63	1432.89	1432.38	1432.63	1083.0
2012-08-27 19:00:00	ES	Futures	1432.89	1433.65	1432.38	1433.14	1275.0
2012-08-27 20:00:00	ES	Futures	1433.14	1433.4	1430.6	1430.6	4988.0
2012-08-27 21:00:00	ES	Futures	1430.85	1431.36	1430.09	1430.6	5282.0
2012-08-27 22:00:00	ES	Futures	1430.6	1430.85	1428.31	1428.56	6457.0
2012-08-27 23:00:00	ES	Futures	1428.56	1429.58	1428.31	1429.07	3163.0
2012-08-27 00:00:00	NQ	Futures	3229.61	3231.06	3228.16	3229.32	374.0
2012-08-27 01:00:00	NQ	Futures	3229.03	3229.03	3226.13	3227.0	517.0
2012-08-27 02:00:00	NQ	Futures	3226.71	3227.29	3224.39	3226.42	635.0
2012-08-27 03:00:00	NQ	Futures	3226.42	3229.61	3224.68	3228.16	1404.0
2012-08-27 04:00:00	NQ	Futures	3227.87	3233.09	3227.58	3232.22	1371.0
2012-08-27 05:00:00	NQ	Futures	3232.22	3232.22	3227.87	3229.61	970.0
2012-08-27 06:00:00	NQ	Futures	3229.9	3235.99	3229.61	3234.54	2018.0
2012-08-27 07:00:00	NQ	Futures	3234.54	3237.44	3232.8	3235.99	2920.0
2012-08-27 08:00:00	NQ	Futures	3236.28	3241.78	3235.12	3235.41	4814.0
2012-08-27 09:00:00	NQ	Futures	3235.7	3237.73	3221.2	3222.36	28977.0
2012-08-27 10:00:00	NQ	Futures	3222.07	3229.9	3220.91	3226.42	22242.0
2012-08-27 11:00:00	NQ	Futures	3226.42	3239.75	3226.13	3232.51	17681.0
2012-08-27 12:00:00	NQ	Futures	3232.51	3235.7	3227.58	3230.77	9389.0
2012-08-27 13:00:00	NQ	Futures	3230.48	3234.54	3227.29	3229.32	6840.0
2012-08-27 14:00:00	NQ	Futures	3229.32	3233.96	3225.84	3231.93	7481.0
2012-08-27 15:00:00	NQ	Futures	3231.93	3232.51	3219.46	3226.71	21291.0
2012-08-27 16:00:00	NQ	Futures	3226.42	3228.16	3225.26	3227.0	5656.0
2012-08-27 17:00:00	NQ	Futures	3227.0	3228.16	3227.0	3227.87	126.0
2012-08-27 18:00:00	NQ	Futures	3227.58	3227.87	3226.71	3227.58	229.0
2012-08-27 19:00:00	NQ	Futures	3227.87	3229.32	3227.0	3229.32	167.0
2012-08-27 20:00:00	NQ	Futures	3229.32	3229.32	3223.52	3224.1	475.0
2012-08-27 21:00:00	NQ	Futures	3224.1	3225.55	3222.65	3224.1	667.0
2012-08-27 22:00:00	NQ	Futures	3224.1	3224.39	3218.88	3219.75	705.0
2012-08-27 23:00:00	NQ	Futures	3219.46	3221.2	3218.59	3220.33	423.0
2012-08-27 00:00:00	YM	Futures	13090.3	13092.3	13080.4	13082.4	401.0
2012-08-27 01:00:00	YM	Futures	13082.4	13082.4	13070.4	13071.4	371.0

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

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