PREVIEW / etf_1hour / 2016-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-25.parquet
  size:    247 KB
  rows:    7,943

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-04-25 04:00:00	SPY	ETF	208.15	208.18	207.83	208.15	14853.0
2016-04-25 05:00:00	SPY	ETF	208.05	208.86	208.05	208.86	19718.0
2016-04-25 06:00:00	SPY	ETF	208.89	208.93	208.73	208.81	34856.0
2016-04-25 07:00:00	SPY	ETF	208.78	208.85	208.56	208.63	123103.0
2016-04-25 08:00:00	SPY	ETF	208.68	208.86	208.3	208.46	478003.0
2016-04-25 09:00:00	SPY	ETF	208.52	208.61	207.96	208.13	8935933.0
2016-04-25 10:00:00	SPY	ETF	208.13	208.29	207.64	207.7	10115196.0
2016-04-25 11:00:00	SPY	ETF	207.71	208.035	207.54	207.78	6897845.0
2016-04-25 12:00:00	SPY	ETF	207.79	208.419	207.715	208.31	6869510.0
2016-04-25 13:00:00	SPY	ETF	208.31	208.49	208.16	208.23	4121377.0
2016-04-25 14:00:00	SPY	ETF	208.23	208.37	207.9525	208.26	7329817.0
2016-04-25 15:00:00	SPY	ETF	208.269	208.62	207.96	208.61	11282057.0
2016-04-25 16:00:00	SPY	ETF	208.62	208.9549	208.55	208.81	7833375.0
2016-04-25 17:00:00	SPY	ETF	208.79	208.83	208.79	208.79	80215.0
2016-04-25 18:00:00	SPY	ETF	208.79	208.85	208.75	208.75	40764.0
2016-04-25 19:00:00	SPY	ETF	208.74	208.83	208.74	208.75	144109.0
2016-04-25 04:00:00	QQQ	ETF	108.54	108.54	108.27	108.31	850.0
2016-04-25 05:00:00	QQQ	ETF	108.5	108.85	108.5	108.85	499.0
2016-04-25 06:00:00	QQQ	ETF	108.86	108.89	108.86	108.89	600.0
2016-04-25 07:00:00	QQQ	ETF	108.85	108.85	108.67	108.68	39214.0
2016-04-25 08:00:00	QQQ	ETF	108.77	108.78	108.55	108.66	351372.0
2016-04-25 09:00:00	QQQ	ETF	108.73	108.981	108.54	108.7563	2126926.0
2016-04-25 10:00:00	QQQ	ETF	108.75	108.91	108.461	108.52	2328603.0
2016-04-25 11:00:00	QQQ	ETF	108.5199	108.71	108.45	108.568	1568675.0
2016-04-25 12:00:00	QQQ	ETF	108.56	108.95	108.55	108.84	1283812.0
2016-04-25 13:00:00	QQQ	ETF	108.85	108.95	108.76	108.8699	999407.0
2016-04-25 14:00:00	QQQ	ETF	108.86	108.94	108.65	108.8964	1185249.0
2016-04-25 15:00:00	QQQ	ETF	108.9	108.99	108.65	108.97	3045883.0
2016-04-25 16:00:00	QQQ	ETF	108.98	109.16	108.96	109.13	280255.0
2016-04-25 17:00:00	QQQ	ETF	109.05	109.18	109.05	109.07	11080.0
2016-04-25 18:00:00	QQQ	ETF	109.12	109.16	109.12	109.12	5715.0
2016-04-25 19:00:00	QQQ	ETF	109.13	109.17	109.11	109.12	13318.0
2016-04-25 04:00:00	IWM	ETF	113.8	113.8	113.52	113.62	3900.0
2016-04-25 05:00:00	IWM	ETF	113.64	113.84	113.64	113.84	1600.0
2016-04-25 06:00:00	IWM	ETF	114.02	114.02	113.93	113.93	1200.0
2016-04-25 07:00:00	IWM	ETF	113.98	114.0	113.89	113.91	12259.0
2016-04-25 08:00:00	IWM	ETF	113.87	113.98	113.73	113.83	29619.0
2016-04-25 09:00:00	IWM	ETF	113.92	113.92	113.36	113.53	1948332.0
2016-04-25 10:00:00	IWM	ETF	113.52	113.61	113.06	113.21	2723389.0
2016-04-25 11:00:00	IWM	ETF	113.205	113.37	113.01	113.09	2049068.0
2016-04-25 12:00:00	IWM	ETF	113.09	113.19	112.82	113.17	1451620.0
2016-04-25 13:00:00	IWM	ETF	113.17	113.2599	112.97	112.97	1019076.0
2016-04-25 14:00:00	IWM	ETF	112.98	113.09	112.81	113.06	1181131.0
2016-04-25 15:00:00	IWM	ETF	113.06	113.26	112.83	113.25	3892822.0
2016-04-25 16:00:00	IWM	ETF	113.28	113.4	112.9218	113.33	688009.0
2016-04-25 17:00:00	IWM	ETF	113.31	113.34	113.28	113.3	11943.0
2016-04-25 19:00:00	IWM	ETF	113.3	113.38	113.3	113.38	2500.0
2016-04-25 08:00:00	DIA	ETF	179.37	179.37	179.37	179.37	500.0
2016-04-25 09:00:00	DIA	ETF	179.22	179.4	178.9	178.9978	397077.0
2016-04-25 10:00:00	DIA	ETF	178.98	179.06	178.41	178.49	488349.0

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

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