PREVIEW / futures_1hour / 2011-07-07

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-07.parquet
  size:    47 KB
  rows:    1,455

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
2011-07-07 00:00:00	ES	Futures	1338.06	1339.56	1337.56	1339.31	4064.0
2011-07-07 01:00:00	ES	Futures	1339.31	1340.31	1337.81	1337.81	6175.0
2011-07-07 02:00:00	ES	Futures	1337.81	1339.06	1337.06	1337.31	8782.0
2011-07-07 03:00:00	ES	Futures	1337.56	1337.81	1334.07	1335.57	38884.0
2011-07-07 04:00:00	ES	Futures	1335.32	1337.31	1335.32	1336.81	14128.0
2011-07-07 05:00:00	ES	Futures	1336.56	1338.31	1335.82	1336.56	12284.0
2011-07-07 06:00:00	ES	Futures	1336.31	1337.06	1335.32	1336.81	7396.0
2011-07-07 07:00:00	ES	Futures	1336.56	1338.31	1336.31	1337.31	26830.0
2011-07-07 08:00:00	ES	Futures	1337.31	1346.54	1336.31	1344.79	160350.0
2011-07-07 09:00:00	ES	Futures	1344.79	1345.29	1341.05	1342.8	223792.0
2011-07-07 10:00:00	ES	Futures	1342.8	1345.29	1341.8	1344.79	291636.0
2011-07-07 11:00:00	ES	Futures	1344.55	1344.79	1342.3	1343.55	171351.0
2011-07-07 12:00:00	ES	Futures	1343.55	1345.54	1342.8	1344.55	91326.0
2011-07-07 13:00:00	ES	Futures	1344.55	1347.29	1344.05	1346.29	120840.0
2011-07-07 14:00:00	ES	Futures	1346.04	1349.53	1346.04	1348.54	128417.0
2011-07-07 15:00:00	ES	Futures	1348.54	1349.28	1345.54	1346.29	217183.0
2011-07-07 16:00:00	ES	Futures	1346.54	1349.03	1346.04	1348.04	97547.0
2011-07-07 17:00:00	ES	Futures	1348.04	1349.03	1347.54	1348.54	3217.0
2011-07-07 18:00:00	ES	Futures	1348.29	1348.54	1347.29	1347.54	1649.0
2011-07-07 19:00:00	ES	Futures	1347.54	1348.04	1347.04	1347.79	2636.0
2011-07-07 20:00:00	ES	Futures	1347.79	1348.29	1346.79	1347.29	4359.0
2011-07-07 21:00:00	ES	Futures	1347.29	1348.54	1347.29	1348.29	3538.0
2011-07-07 22:00:00	ES	Futures	1348.04	1348.54	1347.29	1347.54	1708.0
2011-07-07 23:00:00	ES	Futures	1347.54	1348.29	1347.29	1347.79	1403.0
2011-07-07 00:00:00	NQ	Futures	2746.72	2748.73	2745.28	2748.45	529.0
2011-07-07 01:00:00	NQ	Futures	2748.16	2749.89	2744.71	2744.99	381.0
2011-07-07 02:00:00	NQ	Futures	2744.71	2747.87	2744.42	2744.99	990.0
2011-07-07 03:00:00	NQ	Futures	2745.28	2746.14	2738.09	2740.39	2961.0
2011-07-07 04:00:00	NQ	Futures	2740.39	2744.42	2740.39	2743.55	1560.0
2011-07-07 05:00:00	NQ	Futures	2743.27	2746.43	2741.25	2741.54	1228.0
2011-07-07 06:00:00	NQ	Futures	2741.54	2743.27	2740.68	2742.4	1318.0
2011-07-07 07:00:00	NQ	Futures	2742.4	2744.71	2740.96	2742.69	2973.0
2011-07-07 08:00:00	NQ	Futures	2742.4	2761.4	2741.25	2757.08	15344.0
2011-07-07 09:00:00	NQ	Futures	2757.08	2759.96	2752.19	2757.08	38117.0
2011-07-07 10:00:00	NQ	Futures	2757.08	2766.29	2752.19	2765.71	34476.0
2011-07-07 11:00:00	NQ	Futures	2765.42	2767.73	2763.12	2767.15	17283.0
2011-07-07 12:00:00	NQ	Futures	2767.15	2771.18	2765.71	2770.32	13811.0
2011-07-07 13:00:00	NQ	Futures	2770.32	2774.63	2769.45	2772.04	18959.0
2011-07-07 14:00:00	NQ	Futures	2772.04	2780.96	2771.76	2778.66	22701.0
2011-07-07 15:00:00	NQ	Futures	2778.66	2780.96	2772.91	2774.06	28668.0
2011-07-07 16:00:00	NQ	Futures	2774.06	2781.25	2773.48	2779.81	8376.0
2011-07-07 17:00:00	NQ	Futures	2780.1	2782.11	2779.52	2781.25	327.0
2011-07-07 18:00:00	NQ	Futures	2780.96	2781.54	2779.52	2780.68	361.0
2011-07-07 19:00:00	NQ	Futures	2780.39	2780.68	2779.52	2780.1	149.0
2011-07-07 20:00:00	NQ	Futures	2780.39	2780.96	2778.09	2780.1	500.0
2011-07-07 21:00:00	NQ	Futures	2780.1	2781.83	2780.1	2780.96	342.0
2011-07-07 22:00:00	NQ	Futures	2780.96	2782.69	2780.1	2780.39	449.0
2011-07-07 23:00:00	NQ	Futures	2780.39	2782.11	2780.1	2780.68	303.0
2011-07-07 00:00:00	YM	Futures	12217.3	12228.0	12213.5	12225.1	152.0
2011-07-07 01:00:00	YM	Futures	12225.1	12230.9	12211.5	12211.5	330.0

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

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