PREVIEW / etf_1hour / 2017-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-30.parquet
  size:    299 KB
  rows:    9,767

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-30 04:00:00	SPY	ETF	262.9	263.21	262.9	263.08	19713.0
2017-11-30 05:00:00	SPY	ETF	263.1	263.5	263.06	263.45	31374.0
2017-11-30 06:00:00	SPY	ETF	263.48	263.63	263.45	263.55	54490.0
2017-11-30 07:00:00	SPY	ETF	263.54	263.54	263.33	263.52	208825.0
2017-11-30 08:00:00	SPY	ETF	263.4	263.57	263.4	263.52	562238.0
2017-11-30 09:00:00	SPY	ETF	263.55	264.19	263.52	263.94	10666380.0
2017-11-30 10:00:00	SPY	ETF	263.945	264.41	263.77	264.37	11586824.0
2017-11-30 11:00:00	SPY	ETF	264.38	264.86	264.32	264.56	9996036.0
2017-11-30 12:00:00	SPY	ETF	264.57	266.05	264.565	265.56	17409358.0
2017-11-30 13:00:00	SPY	ETF	265.56	265.8782	264.8	265.05	11003968.0
2017-11-30 14:00:00	SPY	ETF	265.055	265.27	264.79	264.855	10701515.0
2017-11-30 15:00:00	SPY	ETF	264.855	265.33	264.35	264.88	28047920.0
2017-11-30 16:00:00	SPY	ETF	264.9	265.01	264.23	264.45	21807054.0
2017-11-30 17:00:00	SPY	ETF	264.44	265.01	264.3	264.36	1225040.0
2017-11-30 18:00:00	SPY	ETF	264.33	264.51	264.15	264.39	829427.0
2017-11-30 19:00:00	SPY	ETF	264.4	264.51	264.08	264.2	114362.0
2017-11-30 04:00:00	QQQ	ETF	153.82	154.01	153.79	153.86	5700.0
2017-11-30 05:00:00	QQQ	ETF	153.96	154.08	153.94	154.08	2300.0
2017-11-30 06:00:00	QQQ	ETF	154.16	154.22	154.11	154.18	4592.0
2017-11-30 07:00:00	QQQ	ETF	154.19	154.25	154.06	154.23	123367.0
2017-11-30 08:00:00	QQQ	ETF	154.19	154.3	154.07	154.25	444535.0
2017-11-30 09:00:00	QQQ	ETF	154.26	154.81	154.145	154.38	9838170.0
2017-11-30 10:00:00	QQQ	ETF	154.39	154.98	154.3	154.78	9735847.0
2017-11-30 11:00:00	QQQ	ETF	154.78	155.27	154.72	154.95	6316039.0
2017-11-30 12:00:00	QQQ	ETF	154.95	155.45	154.87	155.1136	6472779.0
2017-11-30 13:00:00	QQQ	ETF	155.11	155.33	154.96	155.22	3744509.0
2017-11-30 14:00:00	QQQ	ETF	155.22	155.28	154.95	155.0063	2411893.0
2017-11-30 15:00:00	QQQ	ETF	155.01	155.35	154.68	155.15	6929832.0
2017-11-30 16:00:00	QQQ	ETF	155.15	155.228	154.68	154.9	2316521.0
2017-11-30 17:00:00	QQQ	ETF	154.84	155.15	154.75	154.9	706334.0
2017-11-30 18:00:00	QQQ	ETF	154.79	155.03	154.79	154.88	19027.0
2017-11-30 19:00:00	QQQ	ETF	154.93	154.95	154.7	154.77	28997.0
2017-11-30 04:00:00	IWM	ETF	153.69	153.79	153.69	153.72	3626.0
2017-11-30 05:00:00	IWM	ETF	153.73	153.87	153.7	153.87	13922.0
2017-11-30 06:00:00	IWM	ETF	153.93	153.99	153.92	153.95	47080.0
2017-11-30 07:00:00	IWM	ETF	153.88	153.9	153.76	153.89	19517.0
2017-11-30 08:00:00	IWM	ETF	153.92	154.08	153.89	154.04	124207.0
2017-11-30 09:00:00	IWM	ETF	154.03	154.22	153.68	153.91	3326812.0
2017-11-30 10:00:00	IWM	ETF	153.91	154.19	153.4864	154.04	3521536.0
2017-11-30 11:00:00	IWM	ETF	154.06	154.55	153.85	153.95	2879477.0
2017-11-30 12:00:00	IWM	ETF	153.95	154.43	153.77	154.16	3093182.0
2017-11-30 13:00:00	IWM	ETF	154.17	154.32	153.61	153.749	2128083.0
2017-11-30 14:00:00	IWM	ETF	153.75	153.98	153.55	153.65	1769760.0
2017-11-30 15:00:00	IWM	ETF	153.65	154.03	153.281	153.59	5334235.0
2017-11-30 16:00:00	IWM	ETF	153.58	153.65	153.25	153.52	3849445.0
2017-11-30 17:00:00	IWM	ETF	153.52	153.65	153.4	153.4	73914.0
2017-11-30 18:00:00	IWM	ETF	153.47	153.51	153.32	153.44	10921.0
2017-11-30 19:00:00	IWM	ETF	153.46	153.51	153.15	153.2	21626.0
2017-11-30 04:00:00	DIA	ETF	239.92	239.92	239.92	239.92	200.0
2017-11-30 07:00:00	DIA	ETF	240.1	240.1	240.1	240.1	100.0

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

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