PREVIEW / futures_1hour / 2012-12-17

all futures 1-hour files

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

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-17 00:00:00	ES	Futures	1451.54	1451.79	1450.77	1451.02	4147.0
2012-12-17 01:00:00	ES	Futures	1451.02	1451.02	1449.74	1450.51	3804.0
2012-12-17 02:00:00	ES	Futures	1450.51	1452.31	1449.23	1451.02	12836.0
2012-12-17 03:00:00	ES	Futures	1451.02	1452.31	1448.97	1449.23	18300.0
2012-12-17 04:00:00	ES	Futures	1449.23	1449.74	1447.43	1447.69	10479.0
2012-12-17 05:00:00	ES	Futures	1447.94	1448.46	1446.4	1447.43	12319.0
2012-12-17 06:00:00	ES	Futures	1447.43	1450.0	1446.66	1448.97	10240.0
2012-12-17 07:00:00	ES	Futures	1449.23	1450.0	1447.17	1449.74	17457.0
2012-12-17 08:00:00	ES	Futures	1449.48	1453.59	1449.48	1450.25	46860.0
2012-12-17 09:00:00	ES	Futures	1450.25	1455.13	1448.71	1454.1	196368.0
2012-12-17 10:00:00	ES	Futures	1454.1	1455.64	1451.28	1452.82	168470.0
2012-12-17 11:00:00	ES	Futures	1452.82	1458.98	1452.56	1457.69	234965.0
2012-12-17 12:00:00	ES	Futures	1457.69	1460.26	1456.92	1458.46	88922.0
2012-12-17 13:00:00	ES	Futures	1458.46	1459.23	1455.13	1455.64	125762.0
2012-12-17 14:00:00	ES	Futures	1455.64	1457.95	1454.1	1456.92	150350.0
2012-12-17 15:00:00	ES	Futures	1456.67	1463.85	1456.15	1463.08	233753.0
2012-12-17 16:00:00	ES	Futures	1462.83	1466.42	1462.57	1465.9	100009.0
2012-12-17 17:00:00	ES	Futures	1465.9	1466.67	1464.11	1465.39	5402.0
2012-12-17 18:00:00	ES	Futures	1465.9	1466.42	1465.14	1465.14	7633.0
2012-12-17 19:00:00	ES	Futures	1465.39	1467.44	1465.14	1467.44	6841.0
2012-12-17 20:00:00	ES	Futures	1467.44	1471.04	1467.19	1470.01	18486.0
2012-12-17 21:00:00	ES	Futures	1470.01	1470.52	1468.98	1469.5	4266.0
2012-12-17 22:00:00	ES	Futures	1469.5	1470.78	1468.98	1470.27	4947.0
2012-12-17 23:00:00	ES	Futures	1470.27	1470.27	1468.98	1468.98	4877.0
2012-12-17 00:00:00	NQ	Futures	3063.5	3064.38	3060.88	3060.88	361.0
2012-12-17 01:00:00	NQ	Futures	3060.88	3061.17	3058.55	3059.72	984.0
2012-12-17 02:00:00	NQ	Futures	3059.72	3063.21	3057.39	3060.3	1445.0
2012-12-17 03:00:00	NQ	Futures	3060.3	3062.92	3054.77	3054.77	2369.0
2012-12-17 04:00:00	NQ	Futures	3055.06	3056.52	3050.7	3050.7	1900.0
2012-12-17 05:00:00	NQ	Futures	3050.99	3051.28	3037.89	3044.58	3943.0
2012-12-17 06:00:00	NQ	Futures	3044.58	3050.11	3041.96	3048.37	2719.0
2012-12-17 07:00:00	NQ	Futures	3048.66	3053.02	3046.91	3053.02	3281.0
2012-12-17 08:00:00	NQ	Futures	3053.31	3067.58	3052.44	3060.01	8372.0
2012-12-17 09:00:00	NQ	Futures	3060.3	3075.73	3053.61	3067.58	46813.0
2012-12-17 10:00:00	NQ	Futures	3067.58	3069.91	3055.64	3065.83	34380.0
2012-12-17 11:00:00	NQ	Futures	3065.54	3087.37	3064.38	3085.04	41086.0
2012-12-17 12:00:00	NQ	Futures	3085.33	3092.61	3082.71	3086.79	22236.0
2012-12-17 13:00:00	NQ	Futures	3087.08	3089.12	3074.56	3075.44	19616.0
2012-12-17 14:00:00	NQ	Futures	3075.44	3081.84	3069.91	3079.51	21725.0
2012-12-17 15:00:00	NQ	Futures	3079.8	3097.56	3077.18	3096.39	33840.0
2012-12-17 16:00:00	NQ	Futures	3096.39	3102.8	3095.81	3102.51	8524.0
2012-12-17 17:00:00	NQ	Futures	3102.51	3103.09	3099.3	3101.05	167.0
2012-12-17 18:00:00	NQ	Futures	3102.21	3103.67	3099.89	3100.47	666.0
2012-12-17 19:00:00	NQ	Futures	3100.76	3102.8	3099.59	3102.8	592.0
2012-12-17 20:00:00	NQ	Futures	3102.8	3111.53	3102.8	3110.95	2149.0
2012-12-17 21:00:00	NQ	Futures	3110.95	3112.69	3109.78	3110.07	816.0
2012-12-17 22:00:00	NQ	Futures	3110.07	3113.86	3109.2	3113.57	701.0
2012-12-17 23:00:00	NQ	Futures	3113.57	3113.57	3108.91	3110.66	946.0
2012-12-17 00:00:00	YM	Futures	13197.0	13198.0	13191.0	13192.0	337.0
2012-12-17 01:00:00	YM	Futures	13191.0	13191.0	13184.0	13190.0	308.0

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

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