PREVIEW / futures_1hour / 2012-04-16

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-16.parquet
  size:    47 KB
  rows:    1,443

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-16 00:00:00	ES	Futures	1377.75	1379.27	1377.75	1378.51	2423.0
2012-04-16 01:00:00	ES	Futures	1378.76	1380.79	1378.01	1380.79	4722.0
2012-04-16 02:00:00	ES	Futures	1380.79	1381.8	1376.74	1379.78	14660.0
2012-04-16 03:00:00	ES	Futures	1379.52	1384.08	1378.51	1381.55	41011.0
2012-04-16 04:00:00	ES	Futures	1381.8	1384.33	1379.27	1384.33	37766.0
2012-04-16 05:00:00	ES	Futures	1384.08	1386.35	1382.81	1386.1	19759.0
2012-04-16 06:00:00	ES	Futures	1386.1	1387.62	1385.34	1385.85	22464.0
2012-04-16 07:00:00	ES	Futures	1385.85	1386.35	1382.31	1382.81	30786.0
2012-04-16 08:00:00	ES	Futures	1382.56	1389.64	1381.8	1388.38	114483.0
2012-04-16 09:00:00	ES	Futures	1388.13	1391.67	1383.32	1384.08	275714.0
2012-04-16 10:00:00	ES	Futures	1383.82	1384.33	1376.99	1381.55	466072.0
2012-04-16 11:00:00	ES	Futures	1381.55	1383.57	1378.51	1378.76	231085.0
2012-04-16 12:00:00	ES	Futures	1379.02	1383.32	1378.01	1382.56	153649.0
2012-04-16 13:00:00	ES	Futures	1382.81	1388.13	1380.54	1386.86	153646.0
2012-04-16 14:00:00	ES	Futures	1387.11	1387.37	1384.08	1384.33	103268.0
2012-04-16 15:00:00	ES	Futures	1384.58	1384.84	1381.04	1381.29	178272.0
2012-04-16 16:00:00	ES	Futures	1381.29	1382.05	1379.02	1381.04	70890.0
2012-04-16 17:00:00	ES	Futures	1381.04	1381.29	1380.28	1380.54	941.0
2012-04-16 18:00:00	ES	Futures	1380.54	1380.79	1380.03	1380.54	2072.0
2012-04-16 19:00:00	ES	Futures	1380.54	1381.04	1380.28	1380.79	2065.0
2012-04-16 20:00:00	ES	Futures	1381.04	1381.04	1379.27	1381.04	6145.0
2012-04-16 21:00:00	ES	Futures	1380.79	1381.29	1379.27	1380.03	4197.0
2012-04-16 22:00:00	ES	Futures	1380.28	1381.8	1378.51	1381.04	5784.0
2012-04-16 23:00:00	ES	Futures	1381.29	1381.29	1379.27	1380.28	3239.0
2012-04-16 00:00:00	NQ	Futures	3106.88	3110.64	3106.88	3108.91	231.0
2012-04-16 01:00:00	NQ	Futures	3109.2	3112.95	3107.46	3111.8	405.0
2012-04-16 02:00:00	NQ	Futures	3112.09	3114.11	3104.86	3110.35	1927.0
2012-04-16 03:00:00	NQ	Futures	3110.35	3119.9	3107.75	3115.27	4033.0
2012-04-16 04:00:00	NQ	Futures	3115.27	3121.63	3111.51	3120.76	4143.0
2012-04-16 05:00:00	NQ	Futures	3120.76	3125.97	3118.16	3125.68	1829.0
2012-04-16 06:00:00	NQ	Futures	3125.97	3128.57	3124.52	3124.81	2627.0
2012-04-16 07:00:00	NQ	Futures	3124.81	3125.68	3118.16	3119.61	2567.0
2012-04-16 08:00:00	NQ	Futures	3119.61	3134.36	3117.87	3131.75	8841.0
2012-04-16 09:00:00	NQ	Futures	3131.75	3134.93	3082.88	3086.93	78097.0
2012-04-16 10:00:00	NQ	Futures	3086.06	3097.92	3073.04	3093.0	118448.0
2012-04-16 11:00:00	NQ	Futures	3092.71	3095.31	3080.56	3080.85	32774.0
2012-04-16 12:00:00	NQ	Futures	3081.14	3089.53	3077.38	3087.22	24210.0
2012-04-16 13:00:00	NQ	Futures	3087.22	3096.18	3079.41	3093.0	29557.0
2012-04-16 14:00:00	NQ	Futures	3093.29	3101.39	3087.5	3092.42	24909.0
2012-04-16 15:00:00	NQ	Futures	3092.42	3093.29	3079.12	3084.03	48636.0
2012-04-16 16:00:00	NQ	Futures	3084.03	3085.77	3081.43	3083.46	9116.0
2012-04-16 17:00:00	NQ	Futures	3082.88	3083.46	3082.01	3082.01	73.0
2012-04-16 18:00:00	NQ	Futures	3082.01	3082.59	3081.43	3081.72	357.0
2012-04-16 19:00:00	NQ	Futures	3081.72	3082.01	3080.85	3081.14	262.0
2012-04-16 20:00:00	NQ	Futures	3081.72	3084.03	3080.85	3082.88	715.0
2012-04-16 21:00:00	NQ	Futures	3082.88	3083.17	3078.54	3079.7	547.0
2012-04-16 22:00:00	NQ	Futures	3079.99	3082.88	3077.09	3081.72	725.0
2012-04-16 23:00:00	NQ	Futures	3081.72	3082.3	3078.25	3079.7	529.0
2012-04-16 00:00:00	YM	Futures	12710.8	12723.7	12710.8	12717.8	202.0
2012-04-16 01:00:00	YM	Futures	12718.8	12736.7	12715.8	12735.7	308.0

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

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