PREVIEW / etf_1hour / 2017-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-13.parquet
  size:    288 KB
  rows:    9,467

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-13 04:00:00	SPY	ETF	258.01	258.09	257.86	257.9	7000.0
2017-11-13 05:00:00	SPY	ETF	257.9	257.9	257.8	257.81	17821.0
2017-11-13 06:00:00	SPY	ETF	257.77	257.8	257.58	257.65	38083.0
2017-11-13 07:00:00	SPY	ETF	257.61	257.67	257.2	257.39	186310.0
2017-11-13 08:00:00	SPY	ETF	257.4	257.5	257.19	257.19	270514.0
2017-11-13 09:00:00	SPY	ETF	257.21	257.85	257.08	257.83	6288322.0
2017-11-13 10:00:00	SPY	ETF	257.82	258.255	257.815	258.07	7292276.0
2017-11-13 11:00:00	SPY	ETF	258.0677	258.31	258.0	258.28	3716187.0
2017-11-13 12:00:00	SPY	ETF	258.28	258.36	258.17	258.25	3666714.0
2017-11-13 13:00:00	SPY	ETF	258.26	258.38	258.1	258.34	2816455.0
2017-11-13 14:00:00	SPY	ETF	258.34	258.43	258.29	258.34	6565235.0
2017-11-13 15:00:00	SPY	ETF	258.34	258.59	258.13	258.34	10949214.0
2017-11-13 16:00:00	SPY	ETF	258.35	258.35	257.5487	258.12	7356978.0
2017-11-13 17:00:00	SPY	ETF	258.1	258.11	258.02	258.03	149873.0
2017-11-13 18:00:00	SPY	ETF	258.05	258.13	257.96	257.97	63955.0
2017-11-13 19:00:00	SPY	ETF	257.95	258.3165	257.9	258.15	169325.0
2017-11-13 04:00:00	QQQ	ETF	153.68	153.72	153.68	153.71	73428.0
2017-11-13 05:00:00	QQQ	ETF	153.68	153.68	153.61	153.61	12996.0
2017-11-13 06:00:00	QQQ	ETF	153.61	153.61	153.5	153.5	13093.0
2017-11-13 07:00:00	QQQ	ETF	153.52	153.52	153.2	153.24	72353.0
2017-11-13 08:00:00	QQQ	ETF	153.4	153.4	153.01	153.07	106136.0
2017-11-13 09:00:00	QQQ	ETF	153.06	153.58	153.01	153.55	1835829.0
2017-11-13 10:00:00	QQQ	ETF	153.55	153.89	153.55	153.78	2043345.0
2017-11-13 11:00:00	QQQ	ETF	153.79	153.96	153.7	153.863	998644.0
2017-11-13 12:00:00	QQQ	ETF	153.87	153.9	153.78	153.85	496420.0
2017-11-13 13:00:00	QQQ	ETF	153.85	153.89	153.73	153.87	669042.0
2017-11-13 14:00:00	QQQ	ETF	153.88	153.95	153.85	153.91	614677.0
2017-11-13 15:00:00	QQQ	ETF	153.91	154.0693	153.68	153.87	3063108.0
2017-11-13 16:00:00	QQQ	ETF	153.87	153.87	153.73	153.75	395081.0
2017-11-13 17:00:00	QQQ	ETF	153.72	153.78	153.72	153.72	5741.0
2017-11-13 18:00:00	QQQ	ETF	153.73	153.76	153.65	153.65	11388.0
2017-11-13 19:00:00	QQQ	ETF	153.64	153.82	153.62	153.8	37959.0
2017-11-13 04:00:00	IWM	ETF	146.5	146.5	146.5	146.5	200.0
2017-11-13 05:00:00	IWM	ETF	146.38	146.43	146.37	146.43	2045.0
2017-11-13 06:00:00	IWM	ETF	146.35	146.35	146.17	146.21	6361.0
2017-11-13 07:00:00	IWM	ETF	146.1	146.15	145.96	146.01	27614.0
2017-11-13 08:00:00	IWM	ETF	146.05	146.05	145.78	145.91	14995.0
2017-11-13 09:00:00	IWM	ETF	145.81	146.18	145.5	146.17	2968258.0
2017-11-13 10:00:00	IWM	ETF	146.16	146.44	145.93	146.2	2963652.0
2017-11-13 11:00:00	IWM	ETF	146.2	146.58	146.09	146.575	1341343.0
2017-11-13 12:00:00	IWM	ETF	146.57	146.66	146.33	146.395	1002630.0
2017-11-13 13:00:00	IWM	ETF	146.4	146.73	146.15	146.72	963191.0
2017-11-13 14:00:00	IWM	ETF	146.71	146.72	146.52	146.565	658341.0
2017-11-13 15:00:00	IWM	ETF	146.56	146.825	146.54	146.62	2772702.0
2017-11-13 16:00:00	IWM	ETF	146.63	146.63	146.4	146.41	619912.0
2017-11-13 18:00:00	IWM	ETF	146.42	146.43	146.31	146.34	2383.0
2017-11-13 19:00:00	IWM	ETF	146.25	146.41	146.25	146.41	1214.0
2017-11-13 06:00:00	DIA	ETF	233.98	233.98	233.98	233.98	100.0
2017-11-13 07:00:00	DIA	ETF	234.06	234.06	233.6	233.6	1552.0
2017-11-13 08:00:00	DIA	ETF	233.73	233.99	233.6	233.6	2169.0

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

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