PREVIEW / futures_1hour / 2012-05-04

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-04.parquet
  size:    41 KB
  rows:    1,201

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-05-04 00:00:00	ES	Futures	1402.55	1403.05	1401.79	1402.55	1738.0
2012-05-04 01:00:00	ES	Futures	1402.55	1403.56	1402.29	1402.8	1795.0
2012-05-04 02:00:00	ES	Futures	1402.8	1405.08	1402.55	1404.57	6665.0
2012-05-04 03:00:00	ES	Futures	1404.32	1405.58	1401.28	1403.05	29613.0
2012-05-04 04:00:00	ES	Futures	1403.05	1403.81	1399.51	1400.52	28582.0
2012-05-04 05:00:00	ES	Futures	1400.52	1402.29	1399.76	1400.52	14659.0
2012-05-04 06:00:00	ES	Futures	1400.52	1405.08	1400.27	1404.57	20414.0
2012-05-04 07:00:00	ES	Futures	1404.82	1405.33	1401.53	1402.04	30541.0
2012-05-04 08:00:00	ES	Futures	1402.04	1405.58	1394.7	1398.75	208923.0
2012-05-04 09:00:00	ES	Futures	1398.75	1399.76	1390.66	1391.92	299722.0
2012-05-04 10:00:00	ES	Futures	1391.67	1392.17	1386.1	1389.14	355227.0
2012-05-04 11:00:00	ES	Futures	1389.14	1389.39	1381.8	1382.31	304366.0
2012-05-04 12:00:00	ES	Futures	1382.31	1384.84	1380.03	1382.81	148027.0
2012-05-04 13:00:00	ES	Futures	1382.81	1384.84	1381.8	1384.33	112051.0
2012-05-04 14:00:00	ES	Futures	1384.08	1384.33	1379.78	1382.31	122445.0
2012-05-04 15:00:00	ES	Futures	1382.31	1384.84	1380.79	1380.79	240002.0
2012-05-04 16:00:00	ES	Futures	1380.79	1381.29	1377.75	1378.76	128994.0
2012-05-04 00:00:00	NQ	Futures	3117.29	3118.45	3116.71	3117.58	215.0
2012-05-04 01:00:00	NQ	Futures	3117.29	3118.74	3116.71	3116.71	407.0
2012-05-04 02:00:00	NQ	Futures	3117.0	3122.21	3116.71	3121.92	898.0
2012-05-04 03:00:00	NQ	Futures	3121.63	3123.94	3114.4	3118.74	3783.0
2012-05-04 04:00:00	NQ	Futures	3118.74	3120.47	3111.51	3112.38	2798.0
2012-05-04 05:00:00	NQ	Futures	3112.38	3116.71	3111.8	3113.82	2364.0
2012-05-04 06:00:00	NQ	Futures	3113.82	3122.79	3113.24	3122.5	2350.0
2012-05-04 07:00:00	NQ	Futures	3122.79	3123.94	3112.95	3114.11	4092.0
2012-05-04 08:00:00	NQ	Futures	3113.82	3121.34	3099.07	3105.72	24222.0
2012-05-04 09:00:00	NQ	Futures	3105.44	3107.46	3080.85	3083.17	51181.0
2012-05-04 10:00:00	NQ	Futures	3083.17	3083.75	3067.55	3078.54	57527.0
2012-05-04 11:00:00	NQ	Futures	3078.54	3079.41	3057.14	3060.9	47652.0
2012-05-04 12:00:00	NQ	Futures	3060.61	3065.53	3050.49	3057.43	25438.0
2012-05-04 13:00:00	NQ	Futures	3057.43	3060.9	3052.22	3058.01	21294.0
2012-05-04 14:00:00	NQ	Futures	3058.3	3058.3	3047.31	3052.22	21819.0
2012-05-04 15:00:00	NQ	Futures	3052.22	3058.87	3045.86	3046.44	39383.0
2012-05-04 16:00:00	NQ	Futures	3046.44	3047.02	3036.89	3038.34	11831.0
2012-05-04 00:00:00	YM	Futures	13092.4	13094.4	13086.4	13091.4	123.0
2012-05-04 01:00:00	YM	Futures	13089.4	13098.4	13089.4	13093.4	149.0
2012-05-04 02:00:00	YM	Futures	13090.4	13108.3	13090.4	13106.3	474.0
2012-05-04 03:00:00	YM	Futures	13106.3	13115.3	13082.4	13094.4	3619.0
2012-05-04 04:00:00	YM	Futures	13094.4	13104.3	13070.5	13077.4	2571.0
2012-05-04 05:00:00	YM	Futures	13077.4	13088.4	13072.4	13076.4	1786.0
2012-05-04 06:00:00	YM	Futures	13073.4	13108.3	13071.5	13105.3	1835.0
2012-05-04 07:00:00	YM	Futures	13106.3	13112.3	13087.4	13090.4	1875.0
2012-05-04 08:00:00	YM	Futures	13090.4	13119.3	13039.6	13056.5	10766.0
2012-05-04 09:00:00	YM	Futures	13056.5	13064.5	12998.7	13006.7	22362.0
2012-05-04 10:00:00	YM	Futures	13006.7	13012.7	12959.9	12986.8	26525.0
2012-05-04 11:00:00	YM	Futures	12985.8	12987.8	12929.0	12936.0	22099.0
2012-05-04 12:00:00	YM	Futures	12936.0	12956.9	12916.0	12939.9	10190.0
2012-05-04 13:00:00	YM	Futures	12939.9	12952.9	12928.0	12949.9	6539.0
2012-05-04 14:00:00	YM	Futures	12949.9	12949.9	12918.0	12938.9	8575.0
2012-05-04 15:00:00	YM	Futures	12939.9	12959.9	12929.0	12929.0	13815.0

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

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