PREVIEW / futures_1hour / 2014-12-24

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-24.parquet
  size:    30 KB
  rows:    828

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
2014-12-24 00:00:00	ES	Futures	2191.0	2192.05	2191.0	2191.27	1088.0
2014-12-24 01:00:00	ES	Futures	2191.53	2192.05	2189.16	2189.16	1708.0
2014-12-24 02:00:00	ES	Futures	2189.42	2189.95	2189.16	2189.16	855.0
2014-12-24 03:00:00	ES	Futures	2189.16	2189.69	2188.63	2188.9	1394.0
2014-12-24 04:00:00	ES	Futures	2188.9	2189.95	2188.9	2189.69	749.0
2014-12-24 05:00:00	ES	Futures	2189.69	2190.21	2189.16	2190.21	1180.0
2014-12-24 06:00:00	ES	Futures	2190.21	2190.21	2188.9	2189.16	2366.0
2014-12-24 07:00:00	ES	Futures	2189.42	2190.48	2189.16	2189.95	1769.0
2014-12-24 08:00:00	ES	Futures	2189.95	2191.27	2189.95	2190.21	3270.0
2014-12-24 09:00:00	ES	Futures	2190.21	2191.27	2188.37	2190.21	49007.0
2014-12-24 10:00:00	ES	Futures	2190.21	2192.05	2189.42	2191.27	43535.0
2014-12-24 11:00:00	ES	Futures	2191.27	2193.11	2191.27	2191.53	30365.0
2014-12-24 12:00:00	ES	Futures	2191.79	2193.11	2186.27	2187.06	58077.0
2014-12-24 13:00:00	ES	Futures	2187.06	2190.74	2186.27	2187.32	30297.0
2014-12-24 00:00:00	NQ	Futures	5032.35	5035.58	5032.35	5034.7	298.0
2014-12-24 01:00:00	NQ	Futures	5034.7	5035.58	5029.12	5029.12	439.0
2014-12-24 02:00:00	NQ	Futures	5029.41	5030.88	5027.06	5027.36	305.0
2014-12-24 03:00:00	NQ	Futures	5027.65	5028.24	5026.48	5027.36	214.0
2014-12-24 04:00:00	NQ	Futures	5028.24	5030.0	5027.65	5029.71	118.0
2014-12-24 05:00:00	NQ	Futures	5030.29	5032.35	5030.29	5032.06	94.0
2014-12-24 06:00:00	NQ	Futures	5032.35	5032.64	5029.41	5029.71	401.0
2014-12-24 07:00:00	NQ	Futures	5029.71	5032.64	5029.41	5031.47	494.0
2014-12-24 08:00:00	NQ	Futures	5031.18	5034.41	5030.59	5030.88	632.0
2014-12-24 09:00:00	NQ	Futures	5031.18	5045.57	5028.53	5043.22	15457.0
2014-12-24 10:00:00	NQ	Futures	5043.22	5045.57	5034.7	5044.1	7635.0
2014-12-24 11:00:00	NQ	Futures	5044.1	5049.68	5041.46	5042.34	6318.0
2014-12-24 12:00:00	NQ	Futures	5042.34	5047.04	5029.71	5030.88	8437.0
2014-12-24 13:00:00	NQ	Futures	5030.59	5037.34	5029.12	5029.71	3585.0
2014-12-24 00:00:00	YM	Futures	18792.9	18800.2	18792.9	18799.2	209.0
2014-12-24 01:00:00	YM	Futures	18798.1	18800.2	18778.3	18778.3	353.0
2014-12-24 02:00:00	YM	Futures	18779.4	18783.5	18775.2	18777.3	238.0
2014-12-24 03:00:00	YM	Futures	18777.3	18780.4	18771.0	18774.1	176.0
2014-12-24 04:00:00	YM	Futures	18774.1	18780.4	18770.0	18779.4	148.0
2014-12-24 05:00:00	YM	Futures	18780.4	18785.6	18777.3	18782.5	246.0
2014-12-24 06:00:00	YM	Futures	18783.5	18784.6	18776.2	18777.3	231.0
2014-12-24 07:00:00	YM	Futures	18778.3	18788.7	18777.3	18781.4	210.0
2014-12-24 08:00:00	YM	Futures	18782.5	18790.8	18782.5	18788.7	366.0
2014-12-24 09:00:00	YM	Futures	18786.7	18809.6	18779.4	18807.5	5225.0
2014-12-24 10:00:00	YM	Futures	18806.5	18818.0	18792.9	18810.7	3450.0
2014-12-24 11:00:00	YM	Futures	18809.6	18822.2	18801.3	18811.7	2604.0
2014-12-24 12:00:00	YM	Futures	18811.7	18819.0	18759.5	18766.8	3960.0
2014-12-24 13:00:00	YM	Futures	18767.9	18784.6	18762.7	18775.2	1307.0
2014-12-24 00:00:00	CL	Futures	96.67	96.74	96.24	96.28	2285.0
2014-12-24 01:00:00	CL	Futures	96.28	96.96	96.26	96.6	2849.0
2014-12-24 02:00:00	CL	Futures	96.6	96.99	96.48	96.6	1669.0
2014-12-24 03:00:00	CL	Futures	96.6	96.74	96.04	96.21	2072.0
2014-12-24 04:00:00	CL	Futures	96.18	96.23	95.56	95.6	4202.0
2014-12-24 05:00:00	CL	Futures	95.58	95.92	95.41	95.63	2242.0
2014-12-24 06:00:00	CL	Futures	95.61	95.8	95.36	95.65	2908.0
2014-12-24 07:00:00	CL	Futures	95.65	95.67	94.68	94.97	8315.0

> showing 50 of 828 rows — these rows as CSV

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