PREVIEW / futures_1hour / 2011-05-04

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-04.parquet
  size:    50 KB
  rows:    1,490

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-05-04 00:00:00	ES	Futures	1338.79	1340.03	1338.54	1340.03	3606.0
2011-05-04 01:00:00	ES	Futures	1340.03	1341.77	1339.04	1339.04	6595.0
2011-05-04 02:00:00	ES	Futures	1339.29	1342.02	1339.04	1341.03	10779.0
2011-05-04 03:00:00	ES	Futures	1341.03	1342.52	1339.04	1342.02	23164.0
2011-05-04 04:00:00	ES	Futures	1342.27	1346.25	1340.53	1346.25	29655.0
2011-05-04 05:00:00	ES	Futures	1346.25	1346.49	1344.51	1345.5	13352.0
2011-05-04 06:00:00	ES	Futures	1345.5	1345.75	1340.53	1341.28	31323.0
2011-05-04 07:00:00	ES	Futures	1341.28	1342.27	1340.78	1341.28	24528.0
2011-05-04 08:00:00	ES	Futures	1341.28	1344.75	1340.28	1343.76	47517.0
2011-05-04 09:00:00	ES	Futures	1344.01	1345.5	1337.3	1338.54	241581.0
2011-05-04 10:00:00	ES	Futures	1338.54	1338.54	1331.84	1335.07	565380.0
2011-05-04 11:00:00	ES	Futures	1335.31	1335.81	1329.85	1333.08	304845.0
2011-05-04 12:00:00	ES	Futures	1333.08	1334.07	1329.1	1331.34	205916.0
2011-05-04 13:00:00	ES	Futures	1331.09	1335.81	1330.59	1335.31	244565.0
2011-05-04 14:00:00	ES	Futures	1335.07	1339.04	1333.08	1336.31	207708.0
2011-05-04 15:00:00	ES	Futures	1336.31	1337.55	1333.82	1335.31	273797.0
2011-05-04 16:00:00	ES	Futures	1335.31	1336.06	1333.82	1335.56	104744.0
2011-05-04 17:00:00	ES	Futures	1335.31	1335.81	1334.82	1334.82	1840.0
2011-05-04 18:00:00	ES	Futures	1335.07	1336.56	1334.82	1336.06	2719.0
2011-05-04 19:00:00	ES	Futures	1336.31	1337.3	1335.56	1336.56	3364.0
2011-05-04 20:00:00	ES	Futures	1336.8	1337.55	1336.31	1337.3	4099.0
2011-05-04 21:00:00	ES	Futures	1337.55	1338.05	1336.31	1337.8	3996.0
2011-05-04 22:00:00	ES	Futures	1337.55	1338.3	1337.3	1338.05	5901.0
2011-05-04 23:00:00	ES	Futures	1338.05	1339.04	1337.55	1338.79	3902.0
2011-05-04 00:00:00	NQ	Futures	2736.39	2740.12	2735.52	2740.12	471.0
2011-05-04 01:00:00	NQ	Futures	2740.41	2745.29	2738.4	2738.97	2491.0
2011-05-04 02:00:00	NQ	Futures	2739.26	2745.29	2739.26	2740.12	4406.0
2011-05-04 03:00:00	NQ	Futures	2740.41	2742.13	2735.52	2740.12	3976.0
2011-05-04 04:00:00	NQ	Futures	2740.41	2749.03	2737.25	2748.74	1976.0
2011-05-04 05:00:00	NQ	Futures	2749.03	2749.32	2745.58	2747.3	601.0
2011-05-04 06:00:00	NQ	Futures	2747.59	2747.88	2737.25	2737.82	3497.0
2011-05-04 07:00:00	NQ	Futures	2737.82	2741.27	2737.82	2740.41	1268.0
2011-05-04 08:00:00	NQ	Futures	2740.41	2747.3	2738.97	2745.87	4193.0
2011-05-04 09:00:00	NQ	Futures	2745.87	2753.62	2742.42	2744.43	51313.0
2011-05-04 10:00:00	NQ	Futures	2744.43	2744.72	2729.78	2735.24	53639.0
2011-05-04 11:00:00	NQ	Futures	2734.95	2736.67	2721.16	2726.9	36471.0
2011-05-04 12:00:00	NQ	Futures	2726.9	2729.49	2717.71	2723.46	27980.0
2011-05-04 13:00:00	NQ	Futures	2723.46	2738.11	2722.88	2736.67	28021.0
2011-05-04 14:00:00	NQ	Futures	2736.67	2750.75	2733.51	2745.87	30775.0
2011-05-04 15:00:00	NQ	Futures	2745.87	2748.74	2738.11	2740.7	38498.0
2011-05-04 16:00:00	NQ	Futures	2740.7	2743.57	2736.1	2741.85	7608.0
2011-05-04 17:00:00	NQ	Futures	2742.13	2742.42	2740.98	2740.98	69.0
2011-05-04 18:00:00	NQ	Futures	2741.85	2744.43	2740.41	2742.71	260.0
2011-05-04 19:00:00	NQ	Futures	2742.71	2743.57	2740.7	2742.71	309.0
2011-05-04 20:00:00	NQ	Futures	2743.57	2745.29	2741.56	2745.29	315.0
2011-05-04 21:00:00	NQ	Futures	2745.01	2746.15	2743.28	2745.87	164.0
2011-05-04 22:00:00	NQ	Futures	2745.58	2746.73	2744.72	2746.15	280.0
2011-05-04 23:00:00	NQ	Futures	2745.58	2748.45	2745.01	2748.17	268.0
2011-05-04 00:00:00	YM	Futures	12245.0	12252.7	12239.2	12252.7	224.0
2011-05-04 01:00:00	YM	Futures	12252.7	12268.1	12248.9	12251.7	644.0

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

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