PREVIEW / etf_1hour / 2016-02-19

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-19.parquet
  size:    242 KB
  rows:    7,764

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
2016-02-19 04:00:00	SPY	ETF	192.78	192.78	192.44	192.58	19356.0
2016-02-19 05:00:00	SPY	ETF	192.61	192.61	192.0	192.0	15406.0
2016-02-19 06:00:00	SPY	ETF	192.07	192.07	191.22	191.47	97919.0
2016-02-19 07:00:00	SPY	ETF	191.39	191.92	191.34	191.87	569763.0
2016-02-19 08:00:00	SPY	ETF	191.4936	192.2042	191.02	191.15	3115961.0
2016-02-19 09:00:00	SPY	ETF	191.14	191.46	190.48	190.96	19191808.0
2016-02-19 10:00:00	SPY	ETF	190.96	191.79	190.45	191.34	23800884.0
2016-02-19 11:00:00	SPY	ETF	191.33	192.18	191.01	191.7	15132127.0
2016-02-19 12:00:00	SPY	ETF	191.7	191.94	191.53	191.7	10681216.0
2016-02-19 13:00:00	SPY	ETF	191.7	191.89	191.55	191.81	6063453.0
2016-02-19 14:00:00	SPY	ETF	191.81	192.06	191.4	191.45	9052237.0
2016-02-19 15:00:00	SPY	ETF	191.45	192.11	191.42	192.02	19952551.0
2016-02-19 16:00:00	SPY	ETF	192.02	192.08	191.92	192.01	6179057.0
2016-02-19 17:00:00	SPY	ETF	191.99	192.04	191.96	191.97	200564.0
2016-02-19 18:00:00	SPY	ETF	191.96	192.07	191.95	192.0	59034.0
2016-02-19 19:00:00	SPY	ETF	192.02	192.12	192.02	192.08	31886.0
2016-02-19 04:00:00	QQQ	ETF	101.75	101.75	101.75	101.75	183.0
2016-02-19 05:00:00	QQQ	ETF	101.58	101.58	101.37	101.37	1700.0
2016-02-19 06:00:00	QQQ	ETF	101.29	101.29	100.9	100.9	3934.0
2016-02-19 07:00:00	QQQ	ETF	100.96	101.25	100.93	101.23	53837.0
2016-02-19 08:00:00	QQQ	ETF	101.23	101.27	100.83	100.85	189658.0
2016-02-19 09:00:00	QQQ	ETF	100.84	101.29	100.615	101.08	5492739.0
2016-02-19 10:00:00	QQQ	ETF	101.08	101.75	100.75	101.38	5130379.0
2016-02-19 11:00:00	QQQ	ETF	101.37	101.94	101.16	101.59	4783454.0
2016-02-19 12:00:00	QQQ	ETF	101.58	101.79	101.54	101.63	1662670.0
2016-02-19 13:00:00	QQQ	ETF	101.63	101.74	101.48	101.625	1291833.0
2016-02-19 14:00:00	QQQ	ETF	101.62	101.7199	101.24	101.26	2108979.0
2016-02-19 15:00:00	QQQ	ETF	101.27	101.7598	101.25	101.65	3629238.0
2016-02-19 16:00:00	QQQ	ETF	101.67	101.67	101.53	101.6	881973.0
2016-02-19 17:00:00	QQQ	ETF	101.55	101.62	101.53	101.58	13178.0
2016-02-19 18:00:00	QQQ	ETF	101.58	101.58	101.56	101.58	4056.0
2016-02-19 19:00:00	QQQ	ETF	101.58	101.59	101.55	101.59	5873.0
2016-02-19 06:00:00	IWM	ETF	99.95	99.95	99.6	99.6	2520.0
2016-02-19 07:00:00	IWM	ETF	99.6	100.05	99.6	99.91	21716.0
2016-02-19 08:00:00	IWM	ETF	99.92	99.95	99.42	99.42	106495.0
2016-02-19 09:00:00	IWM	ETF	99.36	99.82	99.25	99.48	5491931.0
2016-02-19 10:00:00	IWM	ETF	99.48	100.2155	99.11	99.87	5143241.0
2016-02-19 11:00:00	IWM	ETF	99.86	100.56	99.7	100.22	3764089.0
2016-02-19 12:00:00	IWM	ETF	100.21	100.485	100.15	100.31	1778869.0
2016-02-19 13:00:00	IWM	ETF	100.3	100.41	100.16	100.36	989574.0
2016-02-19 14:00:00	IWM	ETF	100.36	100.54	100.13	100.21	1878795.0
2016-02-19 15:00:00	IWM	ETF	100.22	100.46	100.18	100.43	4777752.0
2016-02-19 16:00:00	IWM	ETF	100.43	100.54	99.3	100.49	1217016.0
2016-02-19 17:00:00	IWM	ETF	100.49	100.51	100.41	100.41	27053.0
2016-02-19 18:00:00	IWM	ETF	100.5	100.59	100.5	100.5	1434.0
2016-02-19 19:00:00	IWM	ETF	100.5	100.5	100.34	100.34	4726.0
2016-02-19 06:00:00	DIA	ETF	163.75	163.75	163.75	163.75	100.0
2016-02-19 07:00:00	DIA	ETF	163.5	163.62	163.39	163.62	400.0
2016-02-19 08:00:00	DIA	ETF	163.71	163.73	163.09	163.14	7900.0
2016-02-19 09:00:00	DIA	ETF	163.1	163.61	162.67	163.0299	805575.0

> showing 50 of 7,764 rows — these rows as CSV

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