PREVIEW / etf_1hour / 2021-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-22.parquet
  size:    407 KB
  rows:    14,234

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
2021-06-22 04:00:00	SPY	ETF	420.74	420.74	420.07	420.2	18855.0
2021-06-22 05:00:00	SPY	ETF	420.35	420.7	420.17	420.36	30245.0
2021-06-22 06:00:00	SPY	ETF	420.4	421.0	420.4	420.85	22118.0
2021-06-22 07:00:00	SPY	ETF	420.89	421.57	420.83	421.5	106815.0
2021-06-22 08:00:00	SPY	ETF	421.29	421.65	420.5	420.78	202844.0
2021-06-22 09:00:00	SPY	ETF	420.78	421.22	420.16	420.4	5288232.0
2021-06-22 10:00:00	SPY	ETF	420.42	421.89	420.08	421.87	6635503.0
2021-06-22 11:00:00	SPY	ETF	421.88	422.63	421.76	422.03	4654216.0
2021-06-22 12:00:00	SPY	ETF	422.05	422.48	422.05	422.3	2730626.0
2021-06-22 13:00:00	SPY	ETF	422.28	422.535	422.13	422.4101	2571227.0
2021-06-22 14:00:00	SPY	ETF	422.41	423.02	422.23	422.92	5311539.0
2021-06-22 15:00:00	SPY	ETF	422.93	424.0	422.91	423.04	13674893.0
2021-06-22 16:00:00	SPY	ETF	423.05	423.43	422.83	423.14	3751569.0
2021-06-22 17:00:00	SPY	ETF	423.13	423.44	423.07	423.33	140614.0
2021-06-22 18:00:00	SPY	ETF	423.32	423.32	423.03	423.13	114942.0
2021-06-22 19:00:00	SPY	ETF	423.19	423.33	423.16	423.23	35975.0
2021-06-22 04:00:00	QQQ	ETF	343.86	343.86	343.06	343.28	18198.0
2021-06-22 05:00:00	QQQ	ETF	343.46	343.94	343.45	343.84	20727.0
2021-06-22 06:00:00	QQQ	ETF	344.0	344.71	343.98	344.58	35833.0
2021-06-22 07:00:00	QQQ	ETF	344.58	345.5	344.58	345.36	101816.0
2021-06-22 08:00:00	QQQ	ETF	344.58	345.5	343.02	344.33	335859.0
2021-06-22 09:00:00	QQQ	ETF	344.3	345.53	343.84	344.69	4354583.0
2021-06-22 10:00:00	QQQ	ETF	344.73	345.73	344.19	345.38	3870363.0
2021-06-22 11:00:00	QQQ	ETF	345.39	346.475	345.32	346.0818	2639325.0
2021-06-22 12:00:00	QQQ	ETF	346.13	346.9201	346.13	346.64	1785591.0
2021-06-22 13:00:00	QQQ	ETF	346.64	346.76	346.2099	346.63	1387248.0
2021-06-22 14:00:00	QQQ	ETF	346.64	347.08	346.3399	347.025	2002195.0
2021-06-22 15:00:00	QQQ	ETF	347.025	348.03	346.98	347.52	5953489.0
2021-06-22 16:00:00	QQQ	ETF	347.51	348.01	347.45	347.81	745693.0
2021-06-22 17:00:00	QQQ	ETF	347.72	347.99	347.72	347.92	55859.0
2021-06-22 18:00:00	QQQ	ETF	347.86	347.89	347.7	347.79	33396.0
2021-06-22 19:00:00	QQQ	ETF	347.84	348.04	347.84	347.9	70400.0
2021-06-22 04:00:00	IWM	ETF	226.43	226.43	226.0	226.1	6653.0
2021-06-22 05:00:00	IWM	ETF	226.29	226.35	225.95	226.13	14152.0
2021-06-22 06:00:00	IWM	ETF	226.45	226.5	226.2	226.3	7800.0
2021-06-22 07:00:00	IWM	ETF	226.34	226.79	226.34	226.76	44401.0
2021-06-22 08:00:00	IWM	ETF	226.6899	227.0	226.11	226.27	387632.0
2021-06-22 09:00:00	IWM	ETF	226.19	226.58	224.91	225.04	2606619.0
2021-06-22 10:00:00	IWM	ETF	225.065	226.19	224.72	226.19	2946603.0
2021-06-22 11:00:00	IWM	ETF	226.195	227.2676	225.905	226.06	2622155.0
2021-06-22 12:00:00	IWM	ETF	226.06	226.76	226.05	226.115	1337187.0
2021-06-22 13:00:00	IWM	ETF	226.11	226.8657	226.09	226.78	1191402.0
2021-06-22 14:00:00	IWM	ETF	226.78	227.21	226.62	227.07	1779845.0
2021-06-22 15:00:00	IWM	ETF	227.06	228.41	227.06	228.04	4376533.0
2021-06-22 16:00:00	IWM	ETF	227.91	228.11	227.0687	228.01	725753.0
2021-06-22 17:00:00	IWM	ETF	228.01	228.1	227.91	228.09	50564.0
2021-06-22 18:00:00	IWM	ETF	228.03	228.06	227.88	227.93	23606.0
2021-06-22 19:00:00	IWM	ETF	228.05	228.24	228.04	228.23	46398.0
2021-06-22 04:00:00	DIA	ETF	338.67	338.81	338.29	338.39	5100.0
2021-06-22 05:00:00	DIA	ETF	338.76	338.77	338.41	338.44	1400.0

> showing 50 of 14,234 rows — these rows as CSV

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