PREVIEW / futures_1hour / 2013-04-24

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-24.parquet
  size:    49 KB
  rows:    1,535

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
2013-04-24 00:00:00	ES	Futures	1623.04	1623.3	1622.27	1623.3	2342.0
2013-04-24 01:00:00	ES	Futures	1623.3	1625.61	1622.01	1624.84	8950.0
2013-04-24 02:00:00	ES	Futures	1624.84	1625.1	1623.81	1623.81	9085.0
2013-04-24 03:00:00	ES	Futures	1624.07	1626.9	1623.55	1626.65	26877.0
2013-04-24 04:00:00	ES	Futures	1626.39	1626.9	1623.81	1624.58	32427.0
2013-04-24 05:00:00	ES	Futures	1624.58	1626.13	1624.07	1626.13	17390.0
2013-04-24 06:00:00	ES	Futures	1625.87	1626.39	1623.04	1623.55	20288.0
2013-04-24 07:00:00	ES	Futures	1623.55	1625.1	1623.04	1623.55	24057.0
2013-04-24 08:00:00	ES	Futures	1623.55	1623.55	1619.69	1620.46	77257.0
2013-04-24 09:00:00	ES	Futures	1620.72	1624.84	1620.21	1622.78	233213.0
2013-04-24 10:00:00	ES	Futures	1623.04	1624.58	1618.4	1623.04	297434.0
2013-04-24 11:00:00	ES	Futures	1623.04	1624.07	1619.95	1622.78	151623.0
2013-04-24 12:00:00	ES	Futures	1622.52	1623.55	1619.69	1621.24	85796.0
2013-04-24 13:00:00	ES	Futures	1621.24	1624.07	1620.98	1623.04	71247.0
2013-04-24 14:00:00	ES	Futures	1622.78	1626.39	1622.52	1626.39	103771.0
2013-04-24 15:00:00	ES	Futures	1626.13	1626.39	1620.72	1622.01	157595.0
2013-04-24 16:00:00	ES	Futures	1622.01	1623.55	1620.72	1622.01	62694.0
2013-04-24 17:00:00	ES	Futures	1622.01	1622.01	1621.24	1621.49	1171.0
2013-04-24 18:00:00	ES	Futures	1620.72	1621.24	1619.69	1620.72	3269.0
2013-04-24 19:00:00	ES	Futures	1620.72	1621.24	1620.46	1620.72	1193.0
2013-04-24 20:00:00	ES	Futures	1620.46	1620.98	1618.4	1618.92	6356.0
2013-04-24 21:00:00	ES	Futures	1618.92	1622.78	1618.66	1621.49	8475.0
2013-04-24 22:00:00	ES	Futures	1621.75	1623.81	1620.72	1623.3	5897.0
2013-04-24 23:00:00	ES	Futures	1623.55	1624.33	1622.52	1624.07	4422.0
2013-04-24 00:00:00	NQ	Futures	3296.43	3296.72	3294.68	3295.56	660.0
2013-04-24 01:00:00	NQ	Futures	3295.85	3299.93	3293.22	3299.06	1015.0
2013-04-24 02:00:00	NQ	Futures	3299.06	3299.93	3297.31	3298.47	978.0
2013-04-24 03:00:00	NQ	Futures	3298.47	3306.35	3297.01	3306.06	3156.0
2013-04-24 04:00:00	NQ	Futures	3305.77	3306.35	3299.06	3299.64	3372.0
2013-04-24 05:00:00	NQ	Futures	3299.93	3304.6	3299.64	3303.43	1924.0
2013-04-24 06:00:00	NQ	Futures	3303.72	3304.89	3298.47	3299.06	2442.0
2013-04-24 07:00:00	NQ	Futures	3299.35	3302.26	3294.1	3294.39	4266.0
2013-04-24 08:00:00	NQ	Futures	3294.68	3295.26	3288.26	3289.72	11502.0
2013-04-24 09:00:00	NQ	Futures	3289.72	3311.31	3288.26	3301.39	52932.0
2013-04-24 10:00:00	NQ	Futures	3301.1	3305.18	3285.35	3295.26	55400.0
2013-04-24 11:00:00	NQ	Futures	3295.56	3298.18	3287.97	3294.97	25590.0
2013-04-24 12:00:00	NQ	Futures	3294.68	3298.18	3288.85	3291.18	15022.0
2013-04-24 13:00:00	NQ	Futures	3291.18	3304.31	3290.89	3300.22	13480.0
2013-04-24 14:00:00	NQ	Futures	3299.93	3311.31	3299.93	3311.31	15883.0
2013-04-24 15:00:00	NQ	Futures	3311.02	3311.31	3297.31	3299.64	28055.0
2013-04-24 16:00:00	NQ	Futures	3299.64	3301.39	3293.22	3294.1	9560.0
2013-04-24 17:00:00	NQ	Futures	3294.1	3294.97	3291.76	3292.93	472.0
2013-04-24 18:00:00	NQ	Futures	3292.06	3292.06	3283.01	3290.01	1049.0
2013-04-24 19:00:00	NQ	Futures	3289.72	3291.47	3289.14	3291.18	265.0
2013-04-24 20:00:00	NQ	Futures	3291.18	3292.06	3288.85	3289.14	550.0
2013-04-24 21:00:00	NQ	Futures	3289.14	3297.6	3289.14	3295.56	915.0
2013-04-24 22:00:00	NQ	Futures	3295.85	3299.06	3293.81	3298.47	415.0
2013-04-24 23:00:00	NQ	Futures	3298.76	3301.68	3297.89	3300.22	537.0
2013-04-24 00:00:00	YM	Futures	14824.5	14826.5	14820.5	14825.5	332.0
2013-04-24 01:00:00	YM	Futures	14826.5	14843.7	14820.5	14840.7	1222.0

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

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