PREVIEW / etf_1hour / 2017-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-16.parquet
  size:    289 KB
  rows:    9,452

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-16 04:00:00	SPY	ETF	257.15	257.57	257.1	257.45	44869.0
2017-11-16 05:00:00	SPY	ETF	257.48	257.62	257.41	257.48	17910.0
2017-11-16 06:00:00	SPY	ETF	257.46	257.5	257.35	257.36	19709.0
2017-11-16 07:00:00	SPY	ETF	257.39	257.55	257.34	257.48	282419.0
2017-11-16 08:00:00	SPY	ETF	257.42	257.59	257.32	257.43	504654.0
2017-11-16 09:00:00	SPY	ETF	257.44	257.85	257.43	257.645	6416361.0
2017-11-16 10:00:00	SPY	ETF	257.64	258.4758	257.64	258.35	9904119.0
2017-11-16 11:00:00	SPY	ETF	258.35	258.53	258.22	258.5	6005303.0
2017-11-16 12:00:00	SPY	ETF	258.49	258.825	258.49	258.74	4661655.0
2017-11-16 13:00:00	SPY	ETF	258.735	258.89	258.65	258.79	6191859.0
2017-11-16 14:00:00	SPY	ETF	258.79	259.04	258.73	258.76	7601354.0
2017-11-16 15:00:00	SPY	ETF	258.76	258.79	258.52	258.609	18530041.0
2017-11-16 16:00:00	SPY	ETF	258.58	258.63	256.4856	258.59	4084393.0
2017-11-16 17:00:00	SPY	ETF	258.57	258.63	258.55	258.57	169353.0
2017-11-16 18:00:00	SPY	ETF	258.57	258.7	258.45	258.64	143329.0
2017-11-16 19:00:00	SPY	ETF	258.62	258.65	258.4	258.65	130824.0
2017-11-16 04:00:00	QQQ	ETF	153.0	153.3	152.93	153.24	4056.0
2017-11-16 05:00:00	QQQ	ETF	153.37	153.5	153.26	153.34	36735.0
2017-11-16 06:00:00	QQQ	ETF	153.26	153.3	153.2	153.26	15234.0
2017-11-16 07:00:00	QQQ	ETF	153.27	153.42	153.24	153.39	39520.0
2017-11-16 08:00:00	QQQ	ETF	153.38	153.44	153.23	153.37	306480.0
2017-11-16 09:00:00	QQQ	ETF	153.38	153.79	153.33	153.7492	2971332.0
2017-11-16 10:00:00	QQQ	ETF	153.745	154.32	153.74	154.26	4658061.0
2017-11-16 11:00:00	QQQ	ETF	154.26	154.49	154.25	154.425	2155392.0
2017-11-16 12:00:00	QQQ	ETF	154.425	154.75	154.42	154.69	2498081.0
2017-11-16 13:00:00	QQQ	ETF	154.6942	154.7973	154.62	154.74	2269116.0
2017-11-16 14:00:00	QQQ	ETF	154.749	154.89	154.69	154.7	2827437.0
2017-11-16 15:00:00	QQQ	ETF	154.7	154.77	154.52	154.54	5953701.0
2017-11-16 16:00:00	QQQ	ETF	154.54	154.58	154.38	154.58	3068529.0
2017-11-16 17:00:00	QQQ	ETF	154.59	154.63	153.6977	154.63	48113.0
2017-11-16 18:00:00	QQQ	ETF	154.54	154.6	154.54	154.6	5996.0
2017-11-16 19:00:00	QQQ	ETF	154.6	154.7	154.54	154.7	16738.0
2017-11-16 04:00:00	IWM	ETF	146.22	146.22	146.0	146.1	10512.0
2017-11-16 05:00:00	IWM	ETF	146.22	146.24	146.21	146.24	10512.0
2017-11-16 06:00:00	IWM	ETF	146.1	146.1	146.02	146.02	8124.0
2017-11-16 07:00:00	IWM	ETF	146.06	146.2	146.04	146.18	63403.0
2017-11-16 08:00:00	IWM	ETF	146.18	146.27	146.13	146.21	50663.0
2017-11-16 09:00:00	IWM	ETF	146.25	146.93	146.19	146.84	2807006.0
2017-11-16 10:00:00	IWM	ETF	146.86	147.85	146.855	147.615	3883321.0
2017-11-16 11:00:00	IWM	ETF	147.61	148.04	147.59	147.68	2278406.0
2017-11-16 12:00:00	IWM	ETF	147.68	148.23	147.59	148.17	2179362.0
2017-11-16 13:00:00	IWM	ETF	148.17	148.4	147.99	148.11	2081826.0
2017-11-16 14:00:00	IWM	ETF	148.1	148.28	147.73	147.76	2242906.0
2017-11-16 15:00:00	IWM	ETF	147.77	148.06	147.74	147.79	3547786.0
2017-11-16 16:00:00	IWM	ETF	147.78	147.8756	147.65	147.72	1949916.0
2017-11-16 17:00:00	IWM	ETF	147.71	147.8842	147.67	147.77	234822.0
2017-11-16 18:00:00	IWM	ETF	147.7	147.79	147.62	147.79	4956.0
2017-11-16 19:00:00	IWM	ETF	147.7	147.78	147.59	147.78	4602.0
2017-11-16 04:00:00	DIA	ETF	233.76	233.76	233.76	233.76	200.0
2017-11-16 07:00:00	DIA	ETF	233.6	234.0	233.6	234.0	3155.0

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

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