PREVIEW / futures_1hour / 2012-10-26

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-26.parquet
  size:    41 KB
  rows:    1,198

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-26 00:00:00	ES	Futures	1428.55	1428.81	1427.02	1427.53	7251.0
2012-10-26 01:00:00	ES	Futures	1427.53	1428.55	1424.98	1427.02	18193.0
2012-10-26 02:00:00	ES	Futures	1426.76	1431.36	1426.76	1429.32	17095.0
2012-10-26 03:00:00	ES	Futures	1429.32	1432.13	1428.3	1429.32	35818.0
2012-10-26 04:00:00	ES	Futures	1429.32	1431.36	1427.02	1429.06	29484.0
2012-10-26 05:00:00	ES	Futures	1428.81	1430.6	1427.79	1428.3	25159.0
2012-10-26 06:00:00	ES	Futures	1428.04	1428.3	1426.25	1427.53	28723.0
2012-10-26 07:00:00	ES	Futures	1427.28	1431.11	1426.76	1430.6	43154.0
2012-10-26 08:00:00	ES	Futures	1430.6	1440.05	1430.34	1438.01	143639.0
2012-10-26 09:00:00	ES	Futures	1438.26	1442.6	1435.96	1436.47	260274.0
2012-10-26 10:00:00	ES	Futures	1436.47	1440.3	1430.85	1432.64	395391.0
2012-10-26 11:00:00	ES	Futures	1432.64	1436.22	1431.11	1432.39	165599.0
2012-10-26 12:00:00	ES	Futures	1432.39	1433.92	1428.04	1433.66	185469.0
2012-10-26 13:00:00	ES	Futures	1433.66	1438.52	1430.85	1436.98	138475.0
2012-10-26 14:00:00	ES	Futures	1437.24	1440.56	1435.71	1438.26	118325.0
2012-10-26 15:00:00	ES	Futures	1438.26	1443.37	1436.22	1437.49	252606.0
2012-10-26 16:00:00	ES	Futures	1437.75	1438.77	1436.98	1438.26	74353.0
2012-10-26 00:00:00	NQ	Futures	3056.86	3059.19	3054.25	3055.7	1047.0
2012-10-26 01:00:00	NQ	Futures	3055.99	3057.74	3049.6	3057.44	1727.0
2012-10-26 02:00:00	NQ	Futures	3057.44	3064.13	3056.57	3060.06	2989.0
2012-10-26 03:00:00	NQ	Futures	3059.77	3064.71	3052.5	3056.86	5305.0
2012-10-26 04:00:00	NQ	Futures	3056.86	3060.06	3050.18	3055.41	4370.0
2012-10-26 05:00:00	NQ	Futures	3055.41	3060.64	3055.41	3058.9	1713.0
2012-10-26 06:00:00	NQ	Futures	3058.61	3059.77	3055.12	3058.61	2044.0
2012-10-26 07:00:00	NQ	Futures	3058.03	3071.97	3056.86	3070.52	5039.0
2012-10-26 08:00:00	NQ	Futures	3070.81	3085.34	3069.94	3079.53	16892.0
2012-10-26 09:00:00	NQ	Futures	3079.53	3099.58	3075.75	3087.66	52068.0
2012-10-26 10:00:00	NQ	Futures	3087.66	3096.96	3071.39	3072.55	47097.0
2012-10-26 11:00:00	NQ	Futures	3072.55	3080.4	3067.03	3069.36	32755.0
2012-10-26 12:00:00	NQ	Futures	3069.36	3071.97	3056.57	3071.1	34771.0
2012-10-26 13:00:00	NQ	Futures	3071.1	3088.25	3064.71	3085.34	26332.0
2012-10-26 14:00:00	NQ	Futures	3085.34	3095.51	3081.85	3091.44	28564.0
2012-10-26 15:00:00	NQ	Futures	3091.44	3102.48	3088.83	3089.99	47296.0
2012-10-26 16:00:00	NQ	Futures	3089.99	3094.06	3089.12	3091.44	7663.0
2012-10-26 00:00:00	YM	Futures	12963.7	12974.7	12956.7	12963.7	858.0
2012-10-26 01:00:00	YM	Futures	12962.7	12967.7	12943.7	12955.7	1271.0
2012-10-26 02:00:00	YM	Futures	12954.7	12977.7	12954.7	12968.7	2019.0
2012-10-26 03:00:00	YM	Futures	12968.7	12986.7	12953.7	12964.7	2913.0
2012-10-26 04:00:00	YM	Futures	12963.7	12989.7	12948.7	12972.7	2074.0
2012-10-26 05:00:00	YM	Futures	12971.7	12989.7	12970.7	12973.7	1231.0
2012-10-26 06:00:00	YM	Futures	12972.7	12972.7	12951.7	12963.7	1294.0
2012-10-26 07:00:00	YM	Futures	12963.7	12984.7	12961.7	12982.7	1792.0
2012-10-26 08:00:00	YM	Futures	12981.7	13048.7	12979.7	13037.7	7756.0
2012-10-26 09:00:00	YM	Futures	13036.7	13075.7	13024.7	13026.7	16987.0
2012-10-26 10:00:00	YM	Futures	13027.7	13060.7	12994.7	13011.7	22572.0
2012-10-26 11:00:00	YM	Futures	13011.7	13041.7	13005.7	13013.7	10915.0
2012-10-26 12:00:00	YM	Futures	13014.7	13027.7	12980.7	13025.7	12339.0
2012-10-26 13:00:00	YM	Futures	13025.7	13062.7	13005.7	13045.7	10368.0
2012-10-26 14:00:00	YM	Futures	13043.7	13072.7	13035.7	13055.7	9502.0
2012-10-26 15:00:00	YM	Futures	13055.7	13093.7	13037.7	13049.7	15133.0

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

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