PREVIEW / etf_1hour / 2017-11-28

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-28.parquet
  size:    290 KB
  rows:    9,519

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
2017-11-28 04:00:00	SPY	ETF	260.35	260.53	260.35	260.53	7629.0
2017-11-28 05:00:00	SPY	ETF	260.53	260.63	260.51	260.61	4500.0
2017-11-28 06:00:00	SPY	ETF	260.62	260.7	260.56	260.7	15033.0
2017-11-28 07:00:00	SPY	ETF	260.65	260.71	260.62	260.63	249803.0
2017-11-28 08:00:00	SPY	ETF	260.62	260.77	260.61	260.74	212000.0
2017-11-28 09:00:00	SPY	ETF	260.74	260.97	260.655	260.785	5408411.0
2017-11-28 10:00:00	SPY	ETF	260.79	261.18	260.7899	261.09	7782836.0
2017-11-28 11:00:00	SPY	ETF	261.09	261.57	261.05	261.55	5850712.0
2017-11-28 12:00:00	SPY	ETF	261.55	262.0299	261.54	261.97	10208559.0
2017-11-28 13:00:00	SPY	ETF	261.975	262.26	261.37	261.42	13578270.0
2017-11-28 14:00:00	SPY	ETF	261.42	262.49	261.17	262.42	14505446.0
2017-11-28 15:00:00	SPY	ETF	262.42	262.9	262.34	262.85	24267662.0
2017-11-28 16:00:00	SPY	ETF	262.84	262.87	260.7594	262.76	14247046.0
2017-11-28 17:00:00	SPY	ETF	262.76	262.79	262.7	262.76	831096.0
2017-11-28 18:00:00	SPY	ETF	262.77	262.78	262.62	262.7	168094.0
2017-11-28 19:00:00	SPY	ETF	262.69	262.78	262.62	262.7	108382.0
2017-11-28 04:00:00	QQQ	ETF	156.31	156.31	156.23	156.27	11230.0
2017-11-28 05:00:00	QQQ	ETF	156.29	156.37	156.29	156.37	4300.0
2017-11-28 06:00:00	QQQ	ETF	156.38	156.41	156.37	156.4	16100.0
2017-11-28 07:00:00	QQQ	ETF	156.39	156.45	156.39	156.42	13500.0
2017-11-28 08:00:00	QQQ	ETF	156.4	156.5	156.4	156.48	35107.0
2017-11-28 09:00:00	QQQ	ETF	156.48	156.59	156.22	156.28	1751279.0
2017-11-28 10:00:00	QQQ	ETF	156.28	156.48	156.19	156.25	2127124.0
2017-11-28 11:00:00	QQQ	ETF	156.25	156.56	156.25	156.47	1654974.0
2017-11-28 12:00:00	QQQ	ETF	156.48	156.639	156.4	156.48	1149097.0
2017-11-28 13:00:00	QQQ	ETF	156.48	156.64	155.91	155.9336	2798315.0
2017-11-28 14:00:00	QQQ	ETF	155.93	156.63	155.7	156.495	3964424.0
2017-11-28 15:00:00	QQQ	ETF	156.5	156.69	156.37	156.61	4052779.0
2017-11-28 16:00:00	QQQ	ETF	156.6	156.61	156.43	156.52	1579059.0
2017-11-28 17:00:00	QQQ	ETF	156.53	156.58	156.51	156.55	20983.0
2017-11-28 18:00:00	QQQ	ETF	156.52	156.52	156.38	156.45	21457.0
2017-11-28 19:00:00	QQQ	ETF	156.53	156.53	156.42	156.45	37259.0
2017-11-28 04:00:00	IWM	ETF	150.75	150.75	150.7	150.7	4800.0
2017-11-28 05:00:00	IWM	ETF	150.75	150.75	150.72	150.72	2600.0
2017-11-28 06:00:00	IWM	ETF	150.81	150.87	150.81	150.87	9085.0
2017-11-28 07:00:00	IWM	ETF	150.91	150.97	150.91	150.92	14973.0
2017-11-28 08:00:00	IWM	ETF	150.92	151.02	150.9	151.01	22716.0
2017-11-28 09:00:00	IWM	ETF	151.02	151.17	150.66	151.12	1755629.0
2017-11-28 10:00:00	IWM	ETF	151.14	151.4201	150.92	151.38	2210219.0
2017-11-28 11:00:00	IWM	ETF	151.38	151.68	151.31	151.61	2238514.0
2017-11-28 12:00:00	IWM	ETF	151.61	151.7	151.42	151.44	1482678.0
2017-11-28 13:00:00	IWM	ETF	151.45	151.77	151.18	151.23	1712073.0
2017-11-28 14:00:00	IWM	ETF	151.23	152.19	150.94	152.06	3071591.0
2017-11-28 15:00:00	IWM	ETF	152.05	152.97	151.93	152.88	10627770.0
2017-11-28 16:00:00	IWM	ETF	152.86	152.92	152.6749	152.8717	4155526.0
2017-11-28 17:00:00	IWM	ETF	152.77	152.84	152.76	152.84	7056.0
2017-11-28 18:00:00	IWM	ETF	152.77	152.77	152.64	152.69	6328.0
2017-11-28 19:00:00	IWM	ETF	152.7	152.79	152.68	152.68	8300.0
2017-11-28 08:00:00	DIA	ETF	236.14	236.42	236.1	236.33	12837.0
2017-11-28 09:00:00	DIA	ETF	236.33	236.67	236.23	236.44	403363.0

> showing 50 of 9,519 rows — these rows as CSV

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