PREVIEW / etf_1hour / 2017-01-19

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-19.parquet
  size:    273 KB
  rows:    8,819

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-01-19 04:00:00	SPY	ETF	226.58	226.58	226.39	226.41	1501.0
2017-01-19 05:00:00	SPY	ETF	226.33	226.36	226.25	226.36	5317.0
2017-01-19 06:00:00	SPY	ETF	226.35	226.56	226.35	226.53	29258.0
2017-01-19 07:00:00	SPY	ETF	226.58	226.59	226.45	226.52	62800.0
2017-01-19 08:00:00	SPY	ETF	226.51	226.75	226.44	226.65	365764.0
2017-01-19 09:00:00	SPY	ETF	226.65	227.0	226.61	226.79	5327799.0
2017-01-19 10:00:00	SPY	ETF	226.78	226.83	226.3035	226.43	6720945.0
2017-01-19 11:00:00	SPY	ETF	226.42	226.57	226.06	226.41	7916126.0
2017-01-19 12:00:00	SPY	ETF	226.42	226.47	226.21	226.34	4242762.0
2017-01-19 13:00:00	SPY	ETF	226.35	226.43	226.09	226.1141	6947996.0
2017-01-19 14:00:00	SPY	ETF	226.11	226.18	225.41	225.7461	12115056.0
2017-01-19 15:00:00	SPY	ETF	225.75	226.1	225.63	225.95	15707280.0
2017-01-19 16:00:00	SPY	ETF	225.96	226.29	225.91	226.2	5716533.0
2017-01-19 17:00:00	SPY	ETF	226.18	226.19	225.91	226.15	157339.0
2017-01-19 18:00:00	SPY	ETF	226.14	226.34	226.14	226.31	154539.0
2017-01-19 19:00:00	SPY	ETF	226.31	226.54	226.31	226.44	187056.0
2017-01-19 04:00:00	QQQ	ETF	123.08	123.08	123.02	123.02	600.0
2017-01-19 06:00:00	QQQ	ETF	122.94	123.03	122.94	123.03	1099.0
2017-01-19 07:00:00	QQQ	ETF	123.1	123.11	123.06	123.06	6668.0
2017-01-19 08:00:00	QQQ	ETF	123.11	123.17	123.03	123.15	89550.0
2017-01-19 09:00:00	QQQ	ETF	123.1	123.65	123.08	123.62	2350860.0
2017-01-19 10:00:00	QQQ	ETF	123.6153	123.619	123.07	123.14	1906209.0
2017-01-19 11:00:00	QQQ	ETF	123.13	123.3454	122.96	123.25	1339487.0
2017-01-19 12:00:00	QQQ	ETF	123.25	123.33	123.1627	123.2259	877306.0
2017-01-19 13:00:00	QQQ	ETF	123.2105	123.26	123.07	123.0725	998792.0
2017-01-19 14:00:00	QQQ	ETF	123.072	123.11	122.72	122.8834	1711165.0
2017-01-19 15:00:00	QQQ	ETF	122.89	123.06	122.8375	122.96	1865818.0
2017-01-19 16:00:00	QQQ	ETF	122.97	123.18	122.97	123.18	594814.0
2017-01-19 17:00:00	QQQ	ETF	123.16	123.16	123.12	123.13	1852.0
2017-01-19 18:00:00	QQQ	ETF	123.14	123.22	123.14	123.21	24118.0
2017-01-19 19:00:00	QQQ	ETF	123.24	123.36	123.24	123.31	24058.0
2017-01-19 07:00:00	IWM	ETF	134.77	134.81	134.69	134.73	46410.0
2017-01-19 08:00:00	IWM	ETF	134.74	135.05	134.7	134.98	101855.0
2017-01-19 09:00:00	IWM	ETF	134.93	135.44	134.63	134.7383	2177574.0
2017-01-19 10:00:00	IWM	ETF	134.74	134.79	134.1	134.19	3377408.0
2017-01-19 11:00:00	IWM	ETF	134.19	134.19	133.61	133.89	4269789.0
2017-01-19 12:00:00	IWM	ETF	133.89	133.92	133.6	133.89	2237882.0
2017-01-19 13:00:00	IWM	ETF	133.885	133.9315	133.62	133.765	1428855.0
2017-01-19 14:00:00	IWM	ETF	133.77	133.78	133.17	133.57	4015752.0
2017-01-19 15:00:00	IWM	ETF	133.58	133.9	133.485	133.71	5264763.0
2017-01-19 16:00:00	IWM	ETF	133.72	133.87	133.68	133.73	3319020.0
2017-01-19 17:00:00	IWM	ETF	133.75	133.78	133.71	133.73	10539.0
2017-01-19 18:00:00	IWM	ETF	133.75	133.83	133.75	133.83	1380.0
2017-01-19 19:00:00	IWM	ETF	133.82	133.95	133.82	133.92	7405.0
2017-01-19 08:00:00	DIA	ETF	197.85	197.85	197.85	197.85	200.0
2017-01-19 09:00:00	DIA	ETF	197.85	198.16	197.77	197.9	530591.0
2017-01-19 10:00:00	DIA	ETF	197.9043	197.92	197.59	197.65	341704.0
2017-01-19 11:00:00	DIA	ETF	197.63	197.8	197.31	197.675	298923.0
2017-01-19 12:00:00	DIA	ETF	197.67	197.68	197.5	197.64	153837.0
2017-01-19 13:00:00	DIA	ETF	197.63	197.6699	197.375	197.4	266208.0

> showing 50 of 8,819 rows — these rows as CSV

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