PREVIEW / futures_1hour / 2012-12-03

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-03.parquet
  size:    47 KB
  rows:    1,458

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-12-03 00:00:00	ES	Futures	1448.22	1448.73	1446.18	1446.44	5450.0
2012-12-03 01:00:00	ES	Futures	1446.69	1447.71	1445.41	1445.92	3775.0
2012-12-03 02:00:00	ES	Futures	1445.67	1446.69	1445.16	1445.92	5350.0
2012-12-03 03:00:00	ES	Futures	1445.92	1448.22	1445.41	1446.69	21359.0
2012-12-03 04:00:00	ES	Futures	1446.95	1447.97	1445.16	1445.16	17750.0
2012-12-03 05:00:00	ES	Futures	1445.41	1448.73	1445.16	1448.22	12684.0
2012-12-03 06:00:00	ES	Futures	1448.22	1450.01	1447.46	1449.5	15646.0
2012-12-03 07:00:00	ES	Futures	1449.5	1455.12	1449.25	1451.8	83529.0
2012-12-03 08:00:00	ES	Futures	1451.8	1453.08	1450.78	1452.57	37363.0
2012-12-03 09:00:00	ES	Futures	1452.57	1453.84	1449.5	1450.01	167099.0
2012-12-03 10:00:00	ES	Futures	1450.01	1450.01	1443.37	1444.39	317076.0
2012-12-03 11:00:00	ES	Futures	1444.65	1447.2	1442.86	1446.95	210133.0
2012-12-03 12:00:00	ES	Futures	1447.2	1447.2	1444.39	1444.65	87894.0
2012-12-03 13:00:00	ES	Futures	1444.39	1444.39	1439.54	1441.07	123868.0
2012-12-03 14:00:00	ES	Futures	1441.07	1443.37	1439.54	1441.07	102990.0
2012-12-03 15:00:00	ES	Futures	1440.82	1443.88	1437.24	1438.52	285666.0
2012-12-03 16:00:00	ES	Futures	1438.52	1439.79	1435.45	1436.73	84610.0
2012-12-03 17:00:00	ES	Futures	1436.73	1436.73	1435.2	1436.47	2090.0
2012-12-03 18:00:00	ES	Futures	1436.73	1437.49	1436.22	1436.73	5232.0
2012-12-03 19:00:00	ES	Futures	1436.73	1436.73	1434.17	1434.94	9612.0
2012-12-03 20:00:00	ES	Futures	1434.94	1436.47	1434.43	1434.43	7401.0
2012-12-03 21:00:00	ES	Futures	1434.43	1435.2	1433.15	1434.43	6214.0
2012-12-03 22:00:00	ES	Futures	1434.17	1435.96	1434.17	1435.2	5550.0
2012-12-03 23:00:00	ES	Futures	1435.2	1435.45	1433.41	1433.92	5243.0
2012-12-03 00:00:00	NQ	Futures	3121.95	3122.24	3118.18	3119.34	626.0
2012-12-03 01:00:00	NQ	Futures	3119.05	3121.37	3116.43	3117.3	384.0
2012-12-03 02:00:00	NQ	Futures	3117.3	3119.63	3115.56	3117.3	763.0
2012-12-03 03:00:00	NQ	Futures	3117.59	3122.82	3116.43	3120.21	2178.0
2012-12-03 04:00:00	NQ	Futures	3120.21	3121.95	3116.72	3117.3	1710.0
2012-12-03 05:00:00	NQ	Futures	3117.3	3123.41	3117.01	3122.24	1099.0
2012-12-03 06:00:00	NQ	Futures	3122.24	3126.02	3120.5	3125.73	1845.0
2012-12-03 07:00:00	NQ	Futures	3126.02	3135.32	3124.86	3129.8	7134.0
2012-12-03 08:00:00	NQ	Futures	3130.09	3132.99	3128.35	3131.83	4028.0
2012-12-03 09:00:00	NQ	Futures	3131.83	3136.48	3128.35	3131.83	27434.0
2012-12-03 10:00:00	NQ	Futures	3132.12	3132.7	3114.98	3118.18	50014.0
2012-12-03 11:00:00	NQ	Futures	3118.18	3123.41	3113.53	3123.12	27564.0
2012-12-03 12:00:00	NQ	Futures	3122.82	3123.41	3114.4	3114.4	13457.0
2012-12-03 13:00:00	NQ	Futures	3114.11	3115.56	3107.42	3112.07	17803.0
2012-12-03 14:00:00	NQ	Futures	3111.78	3115.27	3106.55	3110.33	15526.0
2012-12-03 15:00:00	NQ	Futures	3110.04	3116.14	3102.19	3105.1	34689.0
2012-12-03 16:00:00	NQ	Futures	3104.81	3107.42	3099.58	3101.32	5741.0
2012-12-03 17:00:00	NQ	Futures	3101.32	3101.9	3099.0	3100.45	111.0
2012-12-03 18:00:00	NQ	Futures	3100.74	3103.94	3100.74	3102.48	260.0
2012-12-03 19:00:00	NQ	Futures	3102.19	3102.77	3096.38	3097.83	918.0
2012-12-03 20:00:00	NQ	Futures	3097.83	3101.9	3096.96	3097.25	796.0
2012-12-03 21:00:00	NQ	Futures	3096.96	3098.13	3094.35	3096.96	748.0
2012-12-03 22:00:00	NQ	Futures	3096.96	3100.16	3096.09	3098.42	825.0
2012-12-03 23:00:00	NQ	Futures	3098.71	3099.87	3095.51	3096.09	913.0
2012-12-03 00:00:00	YM	Futures	13042.7	13045.7	13029.7	13031.7	417.0
2012-12-03 01:00:00	YM	Futures	13032.7	13038.7	13020.7	13025.7	361.0

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

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