PREVIEW / etf_1hour / 2020-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-11.parquet
  size:    393 KB
  rows:    13,353

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
2020-12-11 04:00:00	SPY	ETF	364.75	365.36	364.5	364.61	59895.0
2020-12-11 05:00:00	SPY	ETF	364.5	365.04	363.41	363.5	71766.0
2020-12-11 06:00:00	SPY	ETF	363.41	363.9	362.86	363.86	154382.0
2020-12-11 07:00:00	SPY	ETF	363.86	364.43	363.83	364.4	206724.0
2020-12-11 08:00:00	SPY	ETF	364.36	367.02	363.4204	364.57	238094.0
2020-12-11 09:00:00	SPY	ETF	364.56	365.34	364.28	365.05	5923277.0
2020-12-11 10:00:00	SPY	ETF	365.06	365.92	364.655	364.99	5172870.0
2020-12-11 11:00:00	SPY	ETF	364.992	365.33	363.76	364.33	7256920.0
2020-12-11 12:00:00	SPY	ETF	364.35	366.7402	363.26	364.24	6904630.0
2020-12-11 13:00:00	SPY	ETF	364.23	365.9535	364.1401	365.676	6582423.0
2020-12-11 14:00:00	SPY	ETF	365.69	366.21	365.39	365.6779	4342223.0
2020-12-11 15:00:00	SPY	ETF	365.69	366.58	365.46	366.28	11875882.0
2020-12-11 16:00:00	SPY	ETF	366.28	366.7402	365.69	366.11	7614135.0
2020-12-11 17:00:00	SPY	ETF	366.1	366.3	365.92	366.01	114230.0
2020-12-11 18:00:00	SPY	ETF	366.09	366.25	365.92	366.08	36339.0
2020-12-11 19:00:00	SPY	ETF	366.08	366.14	366.02	366.1	22684.0
2020-12-11 04:00:00	QQQ	ETF	300.98	301.25	300.63	300.63	26536.0
2020-12-11 05:00:00	QQQ	ETF	300.54	300.93	299.75	299.75	40184.0
2020-12-11 06:00:00	QQQ	ETF	300.02	300.06	299.22	300.0	36335.0
2020-12-11 07:00:00	QQQ	ETF	300.09	300.52	299.98	300.5	98463.0
2020-12-11 08:00:00	QQQ	ETF	300.25	302.52	299.9096	300.75	118253.0
2020-12-11 09:00:00	QQQ	ETF	300.73	301.4	299.45	300.43	3032807.0
2020-12-11 10:00:00	QQQ	ETF	300.43	301.5	300.03	300.38	2602132.0
2020-12-11 11:00:00	QQQ	ETF	300.41	300.8	299.01	299.56	2684105.0
2020-12-11 12:00:00	QQQ	ETF	299.57	299.9319	298.47	299.42	2909515.0
2020-12-11 13:00:00	QQQ	ETF	299.41	301.15	299.37	300.8084	2262269.0
2020-12-11 14:00:00	QQQ	ETF	300.83	301.61	300.61	301.17	2017967.0
2020-12-11 15:00:00	QQQ	ETF	301.17	301.98	300.805	301.93	4256880.0
2020-12-11 16:00:00	QQQ	ETF	301.93	302.0	301.3433	301.85	933632.0
2020-12-11 17:00:00	QQQ	ETF	301.59	301.92	301.59	301.65	17530.0
2020-12-11 18:00:00	QQQ	ETF	301.75	301.86	301.75	301.85	4160.0
2020-12-11 19:00:00	QQQ	ETF	301.79	301.79	301.6	301.71	5370.0
2020-12-11 04:00:00	IWM	ETF	189.82	190.26	189.67	189.76	36398.0
2020-12-11 05:00:00	IWM	ETF	189.7	190.2	189.04	189.04	42268.0
2020-12-11 06:00:00	IWM	ETF	189.0	189.36	188.51	189.16	65201.0
2020-12-11 07:00:00	IWM	ETF	189.23	189.46	189.05	189.34	175005.0
2020-12-11 08:00:00	IWM	ETF	189.3699	191.24	188.9196	189.62	192481.0
2020-12-11 09:00:00	IWM	ETF	189.62	191.08	189.57	190.91	3238036.0
2020-12-11 10:00:00	IWM	ETF	190.905	191.72	190.41	190.62	2541689.0
2020-12-11 11:00:00	IWM	ETF	190.63	190.9	189.115	189.75	2200318.0
2020-12-11 12:00:00	IWM	ETF	189.75	189.9	188.3	189.325	3427027.0
2020-12-11 13:00:00	IWM	ETF	189.31	190.35	189.135	190.26	1436898.0
2020-12-11 14:00:00	IWM	ETF	190.26	190.4	189.8911	189.99	1438448.0
2020-12-11 15:00:00	IWM	ETF	189.99	190.51	189.78	190.3	3214355.0
2020-12-11 16:00:00	IWM	ETF	190.3	190.53	190.04	190.3	4134704.0
2020-12-11 17:00:00	IWM	ETF	189.7	190.29	189.7	190.16	13102.0
2020-12-11 18:00:00	IWM	ETF	190.23	190.24	190.16	190.2	3566.0
2020-12-11 19:00:00	IWM	ETF	190.2	190.3	190.2	190.2	1812.0
2020-12-11 04:00:00	DIA	ETF	299.46	299.68	299.08	299.08	3000.0
2020-12-11 05:00:00	DIA	ETF	299.0	299.37	298.71	298.71	1700.0

> showing 50 of 13,353 rows — these rows as CSV

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