PREVIEW / futures_1hour / 2012-10-31

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-31.parquet
  size:    48 KB
  rows:    1,505

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-31 00:00:00	ES	Futures	1440.56	1440.82	1439.54	1440.56	1421.0
2012-10-31 01:00:00	ES	Futures	1440.3	1440.56	1438.77	1439.54	2524.0
2012-10-31 02:00:00	ES	Futures	1439.28	1440.05	1438.52	1439.79	2622.0
2012-10-31 03:00:00	ES	Futures	1439.79	1444.9	1439.79	1444.39	13972.0
2012-10-31 04:00:00	ES	Futures	1444.65	1448.48	1443.88	1447.46	40621.0
2012-10-31 05:00:00	ES	Futures	1447.2	1449.25	1446.69	1447.71	22813.0
2012-10-31 06:00:00	ES	Futures	1447.71	1448.48	1446.95	1447.71	19486.0
2012-10-31 07:00:00	ES	Futures	1447.71	1447.71	1445.92	1446.69	27809.0
2012-10-31 08:00:00	ES	Futures	1446.44	1446.44	1444.14	1444.65	42090.0
2012-10-31 09:00:00	ES	Futures	1444.65	1445.41	1440.3	1442.6	252452.0
2012-10-31 10:00:00	ES	Futures	1442.35	1443.37	1436.47	1437.49	236149.0
2012-10-31 11:00:00	ES	Futures	1437.49	1438.01	1433.15	1435.71	283599.0
2012-10-31 12:00:00	ES	Futures	1435.45	1435.71	1431.11	1433.92	210795.0
2012-10-31 13:00:00	ES	Futures	1434.17	1435.45	1432.39	1434.68	70076.0
2012-10-31 14:00:00	ES	Futures	1434.68	1437.75	1434.68	1435.2	89060.0
2012-10-31 15:00:00	ES	Futures	1435.45	1440.56	1433.92	1436.73	295100.0
2012-10-31 16:00:00	ES	Futures	1436.73	1437.24	1431.87	1432.39	142354.0
2012-10-31 17:00:00	ES	Futures	1432.39	1432.9	1431.62	1431.87	3790.0
2012-10-31 18:00:00	ES	Futures	1432.13	1433.41	1431.11	1433.15	4711.0
2012-10-31 19:00:00	ES	Futures	1433.15	1433.92	1432.39	1432.9	2807.0
2012-10-31 20:00:00	ES	Futures	1432.9	1433.66	1432.64	1433.41	3883.0
2012-10-31 21:00:00	ES	Futures	1433.41	1434.17	1429.06	1433.15	14426.0
2012-10-31 22:00:00	ES	Futures	1433.15	1434.94	1431.62	1434.68	6024.0
2012-10-31 23:00:00	ES	Futures	1434.43	1435.96	1433.66	1433.92	5623.0
2012-10-31 00:00:00	NQ	Futures	3084.18	3084.47	3082.43	3083.89	285.0
2012-10-31 01:00:00	NQ	Futures	3083.6	3083.89	3081.27	3081.85	364.0
2012-10-31 02:00:00	NQ	Futures	3082.14	3083.31	3080.69	3083.02	212.0
2012-10-31 03:00:00	NQ	Futures	3083.31	3093.77	3083.31	3093.48	1929.0
2012-10-31 04:00:00	NQ	Futures	3093.19	3107.71	3092.31	3107.13	4983.0
2012-10-31 05:00:00	NQ	Futures	3106.84	3111.2	3105.39	3105.68	2362.0
2012-10-31 06:00:00	NQ	Futures	3105.68	3106.55	3103.36	3103.65	1397.0
2012-10-31 07:00:00	NQ	Futures	3103.94	3103.94	3099.58	3100.45	1768.0
2012-10-31 08:00:00	NQ	Futures	3100.16	3100.74	3087.96	3092.02	5750.0
2012-10-31 09:00:00	NQ	Futures	3092.02	3094.06	3078.37	3079.82	38107.0
2012-10-31 10:00:00	NQ	Futures	3079.82	3083.31	3064.71	3067.32	53664.0
2012-10-31 11:00:00	NQ	Futures	3067.32	3074.3	3059.77	3067.03	64506.0
2012-10-31 12:00:00	NQ	Futures	3066.74	3069.07	3058.9	3068.78	55777.0
2012-10-31 13:00:00	NQ	Futures	3068.49	3070.23	3062.68	3067.32	26058.0
2012-10-31 14:00:00	NQ	Futures	3067.03	3075.46	3067.03	3069.07	20093.0
2012-10-31 15:00:00	NQ	Futures	3068.78	3076.33	3065.29	3068.78	36386.0
2012-10-31 16:00:00	NQ	Futures	3069.07	3070.23	3059.19	3060.35	12221.0
2012-10-31 17:00:00	NQ	Futures	3060.35	3060.64	3057.74	3057.74	853.0
2012-10-31 18:00:00	NQ	Futures	3056.86	3060.93	3055.99	3060.35	885.0
2012-10-31 19:00:00	NQ	Futures	3060.64	3062.09	3059.48	3060.64	374.0
2012-10-31 20:00:00	NQ	Futures	3060.64	3062.09	3059.77	3061.51	633.0
2012-10-31 21:00:00	NQ	Futures	3061.51	3063.55	3053.67	3062.68	1862.0
2012-10-31 22:00:00	NQ	Futures	3063.26	3066.16	3060.06	3065.87	800.0
2012-10-31 23:00:00	NQ	Futures	3066.16	3067.91	3064.42	3064.42	775.0
2012-10-31 00:00:00	YM	Futures	13058.7	13059.7	13049.7	13057.7	702.0
2012-10-31 01:00:00	YM	Futures	13055.7	13056.7	13043.7	13047.7	296.0

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

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