PREVIEW / futures_1hour / 2012-10-30

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-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-10-30 00:00:00	ES	Futures	1427.02	1429.57	1426.76	1429.57	4342.0
2012-10-30 01:00:00	ES	Futures	1429.57	1431.11	1427.79	1428.55	6397.0
2012-10-30 02:00:00	ES	Futures	1428.3	1430.85	1427.79	1430.34	3322.0
2012-10-30 03:00:00	ES	Futures	1430.09	1433.41	1430.09	1432.9	10206.0
2012-10-30 04:00:00	ES	Futures	1432.9	1438.52	1432.9	1436.98	26409.0
2012-10-30 05:00:00	ES	Futures	1437.24	1437.49	1435.2	1436.22	11874.0
2012-10-30 06:00:00	ES	Futures	1436.22	1437.24	1435.45	1436.98	7438.0
2012-10-30 07:00:00	ES	Futures	1436.98	1439.54	1435.96	1436.22	22656.0
2012-10-30 08:00:00	ES	Futures	1436.22	1439.28	1435.96	1438.77	20516.0
2012-10-30 09:00:00	ES	Futures	1438.77	1443.11	1438.01	1442.09	19131.0
2012-10-30 18:00:00	ES	Futures	1443.37	1443.37	1440.56	1441.84	8285.0
2012-10-30 19:00:00	ES	Futures	1441.84	1442.35	1440.82	1441.58	4118.0
2012-10-30 20:00:00	ES	Futures	1441.84	1442.09	1439.79	1441.58	6193.0
2012-10-30 21:00:00	ES	Futures	1441.58	1442.6	1440.56	1441.07	4163.0
2012-10-30 22:00:00	ES	Futures	1441.07	1441.58	1440.3	1440.3	1925.0
2012-10-30 23:00:00	ES	Futures	1440.56	1440.82	1439.54	1440.3	2212.0
2012-10-30 00:00:00	NQ	Futures	3059.19	3062.68	3059.19	3062.09	493.0
2012-10-30 01:00:00	NQ	Futures	3062.68	3065.0	3058.32	3059.77	759.0
2012-10-30 02:00:00	NQ	Futures	3059.77	3064.71	3058.9	3062.97	391.0
2012-10-30 03:00:00	NQ	Futures	3063.84	3069.65	3063.84	3069.07	996.0
2012-10-30 04:00:00	NQ	Futures	3069.07	3081.27	3068.78	3079.53	2579.0
2012-10-30 05:00:00	NQ	Futures	3079.82	3081.27	3074.88	3078.08	921.0
2012-10-30 06:00:00	NQ	Futures	3078.08	3079.53	3075.17	3076.33	680.0
2012-10-30 07:00:00	NQ	Futures	3076.62	3083.02	3076.04	3076.04	1536.0
2012-10-30 08:00:00	NQ	Futures	3076.04	3082.14	3074.88	3080.69	1788.0
2012-10-30 09:00:00	NQ	Futures	3080.69	3088.25	3078.66	3087.08	1298.0
2012-10-30 18:00:00	NQ	Futures	3094.35	3094.35	3085.34	3088.54	787.0
2012-10-30 19:00:00	NQ	Futures	3088.83	3090.28	3087.96	3088.83	234.0
2012-10-30 20:00:00	NQ	Futures	3088.83	3089.41	3083.89	3087.66	641.0
2012-10-30 21:00:00	NQ	Futures	3087.66	3089.99	3085.34	3086.5	498.0
2012-10-30 22:00:00	NQ	Futures	3086.5	3087.08	3084.47	3084.76	306.0
2012-10-30 23:00:00	NQ	Futures	3084.76	3085.05	3083.02	3084.47	278.0
2012-10-30 00:00:00	YM	Futures	12957.7	12982.7	12956.7	12980.7	666.0
2012-10-30 01:00:00	YM	Futures	12981.7	12988.7	12965.7	12968.7	751.0
2012-10-30 02:00:00	YM	Futures	12968.7	12986.7	12963.7	12977.7	634.0
2012-10-30 03:00:00	YM	Futures	12978.7	13001.7	12978.7	12999.7	928.0
2012-10-30 04:00:00	YM	Futures	13000.7	13044.7	12999.7	13031.7	1869.0
2012-10-30 05:00:00	YM	Futures	13032.7	13035.7	13017.7	13023.7	697.0
2012-10-30 06:00:00	YM	Futures	13023.7	13036.7	13022.7	13032.7	1136.0
2012-10-30 07:00:00	YM	Futures	13034.7	13052.7	13027.7	13027.7	1607.0
2012-10-30 08:00:00	YM	Futures	13026.7	13049.7	13020.7	13046.7	1566.0
2012-10-30 09:00:00	YM	Futures	13046.7	13072.7	13043.7	13068.7	1244.0
2012-10-30 18:00:00	YM	Futures	13083.7	13085.7	13057.7	13066.7	725.0
2012-10-30 19:00:00	YM	Futures	13066.7	13071.7	13063.7	13067.7	786.0
2012-10-30 20:00:00	YM	Futures	13068.7	13074.7	13058.7	13071.7	991.0
2012-10-30 21:00:00	YM	Futures	13070.7	13075.7	13060.7	13067.7	812.0
2012-10-30 22:00:00	YM	Futures	13064.7	13067.7	13058.7	13058.7	311.0
2012-10-30 23:00:00	YM	Futures	13058.7	13059.7	13050.7	13058.7	564.0
2012-10-30 00:00:00	CL	Futures	138.56	138.69	138.36	138.62	622.0
2012-10-30 01:00:00	CL	Futures	138.62	138.79	138.48	138.49	828.0

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

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