PREVIEW / futures_1hour / 2012-04-24

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-24.parquet
  size:    49 KB
  rows:    1,503

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-04-24 00:00:00	ES	Futures	1380.54	1382.05	1380.03	1381.8	2579.0
2012-04-24 01:00:00	ES	Futures	1382.05	1382.81	1381.04	1382.05	3875.0
2012-04-24 02:00:00	ES	Futures	1382.05	1383.32	1381.55	1382.31	9406.0
2012-04-24 03:00:00	ES	Futures	1382.05	1383.57	1380.28	1382.56	27675.0
2012-04-24 04:00:00	ES	Futures	1382.56	1385.34	1381.8	1383.07	26574.0
2012-04-24 05:00:00	ES	Futures	1383.07	1385.6	1382.81	1384.08	16798.0
2012-04-24 06:00:00	ES	Futures	1384.08	1384.33	1382.05	1383.07	17917.0
2012-04-24 07:00:00	ES	Futures	1383.07	1384.58	1382.56	1383.82	26237.0
2012-04-24 08:00:00	ES	Futures	1383.57	1384.58	1378.26	1378.51	65795.0
2012-04-24 09:00:00	ES	Futures	1378.51	1383.07	1377.25	1380.79	259589.0
2012-04-24 10:00:00	ES	Futures	1380.54	1387.11	1379.78	1386.35	272689.0
2012-04-24 11:00:00	ES	Futures	1386.35	1387.62	1384.08	1385.09	189301.0
2012-04-24 12:00:00	ES	Futures	1385.09	1386.1	1382.05	1382.31	83365.0
2012-04-24 13:00:00	ES	Futures	1382.31	1384.58	1381.04	1381.04	71165.0
2012-04-24 14:00:00	ES	Futures	1381.04	1383.82	1379.52	1383.32	97203.0
2012-04-24 15:00:00	ES	Futures	1383.32	1384.84	1381.8	1384.58	152685.0
2012-04-24 16:00:00	ES	Futures	1384.58	1393.69	1384.08	1392.43	113989.0
2012-04-24 17:00:00	ES	Futures	1392.43	1392.68	1390.91	1390.91	6100.0
2012-04-24 18:00:00	ES	Futures	1391.41	1392.68	1391.16	1391.67	4195.0
2012-04-24 19:00:00	ES	Futures	1391.67	1392.68	1391.41	1392.43	3881.0
2012-04-24 20:00:00	ES	Futures	1392.17	1392.68	1390.4	1391.16	4181.0
2012-04-24 21:00:00	ES	Futures	1390.91	1391.16	1389.39	1390.15	5435.0
2012-04-24 22:00:00	ES	Futures	1389.9	1391.16	1389.9	1390.91	2254.0
2012-04-24 23:00:00	ES	Futures	1390.91	1392.17	1390.66	1391.92	2225.0
2012-04-24 00:00:00	NQ	Futures	3069.0	3073.91	3068.42	3073.91	482.0
2012-04-24 01:00:00	NQ	Futures	3073.33	3074.78	3071.31	3073.33	279.0
2012-04-24 02:00:00	NQ	Futures	3073.33	3075.94	3072.47	3073.62	859.0
2012-04-24 03:00:00	NQ	Futures	3073.91	3076.8	3070.73	3074.78	3416.0
2012-04-24 04:00:00	NQ	Futures	3075.36	3081.72	3074.49	3077.38	2451.0
2012-04-24 05:00:00	NQ	Futures	3077.09	3083.46	3076.23	3080.27	1791.0
2012-04-24 06:00:00	NQ	Futures	3080.27	3082.59	3075.65	3081.14	2667.0
2012-04-24 07:00:00	NQ	Futures	3081.14	3084.03	3074.78	3075.36	6823.0
2012-04-24 08:00:00	NQ	Futures	3075.36	3077.09	3058.01	3058.58	11007.0
2012-04-24 09:00:00	NQ	Futures	3058.3	3065.53	3051.93	3056.27	57946.0
2012-04-24 10:00:00	NQ	Futures	3055.98	3071.89	3054.54	3059.45	48183.0
2012-04-24 11:00:00	NQ	Futures	3059.45	3065.53	3053.09	3055.4	26293.0
2012-04-24 12:00:00	NQ	Futures	3055.4	3057.14	3042.68	3043.55	18446.0
2012-04-24 13:00:00	NQ	Futures	3043.55	3047.88	3036.61	3037.47	15205.0
2012-04-24 14:00:00	NQ	Futures	3037.47	3048.75	3036.32	3047.88	23577.0
2012-04-24 15:00:00	NQ	Futures	3047.6	3051.64	3041.52	3048.75	31572.0
2012-04-24 16:00:00	NQ	Futures	3048.75	3094.45	3041.23	3092.42	32279.0
2012-04-24 17:00:00	NQ	Futures	3092.42	3093.29	3087.79	3088.08	3451.0
2012-04-24 18:00:00	NQ	Futures	3088.37	3090.4	3085.19	3085.19	2577.0
2012-04-24 19:00:00	NQ	Futures	3085.48	3091.26	3085.48	3090.69	1239.0
2012-04-24 20:00:00	NQ	Futures	3090.69	3090.98	3086.64	3086.93	371.0
2012-04-24 21:00:00	NQ	Futures	3087.22	3087.79	3085.19	3086.64	636.0
2012-04-24 22:00:00	NQ	Futures	3086.64	3088.08	3085.77	3087.5	314.0
2012-04-24 23:00:00	NQ	Futures	3088.08	3089.24	3087.22	3088.66	371.0
2012-04-24 00:00:00	YM	Futures	12829.3	12843.3	12824.4	12842.3	714.0
2012-04-24 01:00:00	YM	Futures	12841.3	12846.3	12834.3	12842.3	336.0

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

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