PREVIEW / futures_1hour / 2011-05-03

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-03.parquet
  size:    49 KB
  rows:    1,493

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-03 00:00:00	ES	Futures	1345.5	1346.25	1344.51	1345.75	4027.0
2011-05-03 01:00:00	ES	Futures	1346.0	1346.99	1345.25	1346.49	4398.0
2011-05-03 02:00:00	ES	Futures	1346.74	1348.48	1346.25	1347.98	8412.0
2011-05-03 03:00:00	ES	Futures	1347.98	1348.73	1344.26	1345.75	22906.0
2011-05-03 04:00:00	ES	Futures	1345.75	1347.74	1345.0	1345.75	22419.0
2011-05-03 05:00:00	ES	Futures	1345.75	1346.49	1343.02	1343.76	18997.0
2011-05-03 06:00:00	ES	Futures	1344.01	1344.01	1341.77	1342.02	25335.0
2011-05-03 07:00:00	ES	Futures	1341.77	1344.01	1341.52	1342.27	24102.0
2011-05-03 08:00:00	ES	Futures	1342.52	1345.75	1342.27	1345.25	29670.0
2011-05-03 09:00:00	ES	Futures	1345.5	1348.48	1343.51	1347.49	224808.0
2011-05-03 10:00:00	ES	Futures	1347.49	1348.73	1342.77	1344.01	277333.0
2011-05-03 11:00:00	ES	Futures	1343.76	1348.48	1343.51	1347.24	132174.0
2011-05-03 12:00:00	ES	Futures	1347.49	1348.23	1344.01	1344.01	99654.0
2011-05-03 13:00:00	ES	Futures	1344.26	1345.0	1340.03	1341.77	163081.0
2011-05-03 14:00:00	ES	Futures	1341.52	1341.77	1337.3	1338.3	184893.0
2011-05-03 15:00:00	ES	Futures	1338.3	1345.0	1338.3	1344.26	297333.0
2011-05-03 16:00:00	ES	Futures	1344.26	1344.51	1341.77	1342.02	85482.0
2011-05-03 17:00:00	ES	Futures	1342.27	1342.52	1341.28	1341.52	2627.0
2011-05-03 18:00:00	ES	Futures	1341.77	1342.27	1340.28	1340.78	4262.0
2011-05-03 19:00:00	ES	Futures	1340.78	1343.51	1340.03	1343.02	4449.0
2011-05-03 20:00:00	ES	Futures	1343.26	1344.26	1342.77	1342.77	5794.0
2011-05-03 21:00:00	ES	Futures	1342.77	1343.51	1338.05	1338.54	9283.0
2011-05-03 22:00:00	ES	Futures	1338.54	1340.28	1338.05	1338.54	5838.0
2011-05-03 23:00:00	ES	Futures	1338.54	1339.79	1338.05	1338.79	3834.0
2011-05-03 00:00:00	NQ	Futures	2753.05	2755.35	2751.61	2754.77	285.0
2011-05-03 01:00:00	NQ	Futures	2754.77	2756.79	2754.2	2756.5	436.0
2011-05-03 02:00:00	NQ	Futures	2756.5	2760.81	2755.92	2759.66	630.0
2011-05-03 03:00:00	NQ	Futures	2759.95	2761.67	2751.9	2754.77	1866.0
2011-05-03 04:00:00	NQ	Futures	2755.06	2759.08	2754.2	2755.35	1798.0
2011-05-03 05:00:00	NQ	Futures	2755.35	2757.07	2750.75	2752.19	2290.0
2011-05-03 06:00:00	NQ	Futures	2752.48	2752.48	2747.88	2748.17	2345.0
2011-05-03 07:00:00	NQ	Futures	2747.88	2751.61	2747.3	2749.32	1893.0
2011-05-03 08:00:00	NQ	Futures	2749.32	2755.92	2749.03	2755.64	3557.0
2011-05-03 09:00:00	NQ	Futures	2755.64	2759.95	2748.17	2755.92	45450.0
2011-05-03 10:00:00	NQ	Futures	2756.21	2758.8	2744.43	2748.17	66776.0
2011-05-03 11:00:00	NQ	Futures	2748.45	2754.77	2746.73	2752.19	33500.0
2011-05-03 12:00:00	NQ	Futures	2751.9	2753.05	2738.11	2738.68	27439.0
2011-05-03 13:00:00	NQ	Futures	2738.68	2742.71	2729.2	2734.95	35563.0
2011-05-03 14:00:00	NQ	Futures	2735.24	2736.39	2728.34	2734.09	20263.0
2011-05-03 15:00:00	NQ	Futures	2734.09	2747.59	2733.8	2745.58	32406.0
2011-05-03 16:00:00	NQ	Futures	2745.58	2747.88	2742.13	2743.28	7793.0
2011-05-03 17:00:00	NQ	Futures	2743.28	2744.72	2742.42	2743.28	217.0
2011-05-03 18:00:00	NQ	Futures	2744.14	2744.14	2739.83	2740.7	351.0
2011-05-03 19:00:00	NQ	Futures	2740.7	2746.44	2739.55	2746.15	496.0
2011-05-03 20:00:00	NQ	Futures	2746.44	2748.45	2743.86	2743.86	806.0
2011-05-03 21:00:00	NQ	Futures	2744.14	2745.29	2735.52	2736.1	752.0
2011-05-03 22:00:00	NQ	Futures	2736.1	2740.7	2735.24	2735.52	411.0
2011-05-03 23:00:00	NQ	Futures	2735.81	2737.82	2735.24	2736.1	263.0
2011-05-03 00:00:00	YM	Futures	12265.2	12269.1	12259.5	12269.1	159.0
2011-05-03 01:00:00	YM	Futures	12269.1	12277.8	12264.3	12277.8	308.0

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

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