PREVIEW / futures_1hour / 2011-04-29

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-29.parquet
  size:    38 KB
  rows:    1,094

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-04-29 00:00:00	ES	Futures	1346.49	1346.99	1345.0	1345.0	3128.0
2011-04-29 01:00:00	ES	Futures	1345.25	1347.24	1345.0	1345.75	4444.0
2011-04-29 02:00:00	ES	Futures	1346.0	1346.25	1344.51	1345.0	5362.0
2011-04-29 03:00:00	ES	Futures	1345.0	1345.5	1344.51	1345.5	6087.0
2011-04-29 04:00:00	ES	Futures	1345.5	1345.75	1344.26	1345.25	8854.0
2011-04-29 05:00:00	ES	Futures	1345.25	1347.49	1345.25	1345.75	10304.0
2011-04-29 06:00:00	ES	Futures	1346.0	1347.74	1345.75	1347.49	4804.0
2011-04-29 07:00:00	ES	Futures	1347.49	1349.97	1346.74	1348.98	22183.0
2011-04-29 08:00:00	ES	Futures	1349.23	1349.47	1347.74	1347.74	21421.0
2011-04-29 09:00:00	ES	Futures	1347.74	1350.22	1346.99	1346.99	163348.0
2011-04-29 10:00:00	ES	Futures	1346.99	1349.72	1346.74	1349.47	157875.0
2011-04-29 11:00:00	ES	Futures	1349.47	1351.21	1348.48	1350.22	177644.0
2011-04-29 12:00:00	ES	Futures	1350.22	1351.96	1349.97	1351.21	97574.0
2011-04-29 13:00:00	ES	Futures	1351.21	1352.21	1350.47	1350.72	75023.0
2011-04-29 14:00:00	ES	Futures	1350.72	1352.46	1350.22	1350.97	74973.0
2011-04-29 15:00:00	ES	Futures	1350.72	1351.71	1348.98	1351.46	244365.0
2011-04-29 16:00:00	ES	Futures	1351.46	1355.19	1350.97	1354.94	162152.0
2011-04-29 00:00:00	NQ	Futures	2758.22	2758.8	2755.64	2755.64	175.0
2011-04-29 01:00:00	NQ	Futures	2755.92	2760.23	2755.92	2758.22	352.0
2011-04-29 02:00:00	NQ	Futures	2758.51	2759.95	2757.07	2759.08	557.0
2011-04-29 03:00:00	NQ	Futures	2759.08	2761.1	2757.93	2761.1	759.0
2011-04-29 04:00:00	NQ	Futures	2761.1	2761.1	2758.51	2760.23	618.0
2011-04-29 05:00:00	NQ	Futures	2760.23	2763.97	2760.23	2761.1	858.0
2011-04-29 06:00:00	NQ	Futures	2760.81	2763.97	2760.52	2763.68	737.0
2011-04-29 07:00:00	NQ	Futures	2763.39	2763.97	2760.23	2763.11	2490.0
2011-04-29 08:00:00	NQ	Futures	2762.82	2763.68	2759.66	2759.95	2062.0
2011-04-29 09:00:00	NQ	Futures	2759.95	2768.85	2759.08	2759.08	31102.0
2011-04-29 10:00:00	NQ	Futures	2759.08	2765.69	2758.22	2764.54	21516.0
2011-04-29 11:00:00	NQ	Futures	2764.83	2767.42	2761.67	2765.12	19579.0
2011-04-29 12:00:00	NQ	Futures	2764.83	2768.57	2764.83	2767.99	11330.0
2011-04-29 13:00:00	NQ	Futures	2768.28	2771.15	2766.27	2766.84	12271.0
2011-04-29 14:00:00	NQ	Futures	2766.84	2772.59	2765.4	2766.84	10862.0
2011-04-29 15:00:00	NQ	Futures	2766.84	2769.43	2760.52	2764.54	36015.0
2011-04-29 16:00:00	NQ	Futures	2764.26	2769.14	2762.24	2766.55	9807.0
2011-04-29 00:00:00	YM	Futures	12237.3	12240.2	12227.7	12227.7	224.0
2011-04-29 01:00:00	YM	Futures	12228.6	12244.0	12228.6	12230.6	273.0
2011-04-29 02:00:00	YM	Futures	12229.6	12232.5	12222.9	12225.7	179.0
2011-04-29 03:00:00	YM	Futures	12225.7	12229.6	12220.9	12228.6	375.0
2011-04-29 04:00:00	YM	Futures	12229.6	12230.6	12221.9	12229.6	357.0
2011-04-29 05:00:00	YM	Futures	12229.6	12246.0	12229.6	12236.3	398.0
2011-04-29 06:00:00	YM	Futures	12235.4	12249.8	12235.4	12247.9	265.0
2011-04-29 07:00:00	YM	Futures	12247.9	12271.0	12247.9	12268.1	1109.0
2011-04-29 08:00:00	YM	Futures	12268.1	12270.0	12254.6	12254.6	1584.0
2011-04-29 09:00:00	YM	Futures	12254.6	12285.5	12252.7	12260.4	9412.0
2011-04-29 10:00:00	YM	Futures	12259.5	12287.4	12257.5	12286.4	12086.0
2011-04-29 11:00:00	YM	Futures	12286.4	12310.5	12283.5	12301.8	11716.0
2011-04-29 12:00:00	YM	Futures	12301.8	12313.4	12298.0	12303.8	6957.0
2011-04-29 13:00:00	YM	Futures	12303.8	12308.6	12291.2	12292.2	7021.0
2011-04-29 14:00:00	YM	Futures	12291.2	12304.7	12287.4	12291.2	5580.0
2011-04-29 15:00:00	YM	Futures	12291.2	12294.1	12275.8	12293.2	14548.0

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

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