PREVIEW / etf_1hour / 2021-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-26.parquet
  size:    415 KB
  rows:    14,673

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-07-26 04:00:00	SPY	ETF	438.65	438.65	437.08	437.99	25542.0
2021-07-26 05:00:00	SPY	ETF	438.27	438.93	438.21	438.79	13218.0
2021-07-26 06:00:00	SPY	ETF	438.9	439.13	438.55	438.55	27653.0
2021-07-26 07:00:00	SPY	ETF	438.55	439.34	438.55	439.11	218437.0
2021-07-26 08:00:00	SPY	ETF	438.6801	439.27	438.0	438.71	204891.0
2021-07-26 09:00:00	SPY	ETF	438.7	440.24	438.6	439.98	4618595.0
2021-07-26 10:00:00	SPY	ETF	439.97	440.07	439.26	439.65	5009151.0
2021-07-26 11:00:00	SPY	ETF	439.65	440.75	439.405	440.705	3761937.0
2021-07-26 12:00:00	SPY	ETF	440.71	440.83	439.94	440.18	2828233.0
2021-07-26 13:00:00	SPY	ETF	440.1899	440.695	440.18	440.33	2118678.0
2021-07-26 14:00:00	SPY	ETF	440.33	440.68	440.18	440.6143	3137377.0
2021-07-26 15:00:00	SPY	ETF	440.61	441.03	440.45	440.99	7624533.0
2021-07-26 16:00:00	SPY	ETF	440.98	441.16	440.94	441.04	1697123.0
2021-07-26 17:00:00	SPY	ETF	441.01	441.15	440.96	441.15	27499.0
2021-07-26 18:00:00	SPY	ETF	441.11	441.12	440.85	440.9	49395.0
2021-07-26 19:00:00	SPY	ETF	440.9	440.99	440.69	440.73	39527.0
2021-07-26 04:00:00	QQQ	ETF	368.0	368.0	366.6	367.18	37845.0
2021-07-26 05:00:00	QQQ	ETF	367.15	367.83	367.15	367.64	31718.0
2021-07-26 06:00:00	QQQ	ETF	367.76	367.82	367.2	367.2	29974.0
2021-07-26 07:00:00	QQQ	ETF	367.17	367.98	367.16	367.65	145810.0
2021-07-26 08:00:00	QQQ	ETF	367.64	368.476	367.05	367.201	172065.0
2021-07-26 09:00:00	QQQ	ETF	367.19	368.1	366.601	368.05	4489031.0
2021-07-26 10:00:00	QQQ	ETF	368.05	368.5812	367.63	367.86	3916014.0
2021-07-26 11:00:00	QQQ	ETF	367.85	368.76	367.66	368.7115	2435008.0
2021-07-26 12:00:00	QQQ	ETF	368.73	368.89	367.67	367.99	2306214.0
2021-07-26 13:00:00	QQQ	ETF	367.985	368.57	367.96	368.19	1820493.0
2021-07-26 14:00:00	QQQ	ETF	368.18	368.58	367.88	368.498	2174206.0
2021-07-26 15:00:00	QQQ	ETF	368.5	368.65	367.97	368.47	4035246.0
2021-07-26 16:00:00	QQQ	ETF	368.47	368.73	368.35	368.621	1907714.0
2021-07-26 17:00:00	QQQ	ETF	368.7	368.76	368.54	368.65	24301.0
2021-07-26 18:00:00	QQQ	ETF	368.65	368.65	368.41	368.55	40790.0
2021-07-26 19:00:00	QQQ	ETF	368.59	368.599	368.34	368.35	25613.0
2021-07-26 04:00:00	IWM	ETF	217.63	217.75	216.62	217.66	26328.0
2021-07-26 05:00:00	IWM	ETF	217.64	218.92	217.64	218.75	26468.0
2021-07-26 06:00:00	IWM	ETF	218.88	219.24	218.78	218.86	102509.0
2021-07-26 07:00:00	IWM	ETF	218.67	219.78	218.61	219.63	211759.0
2021-07-26 08:00:00	IWM	ETF	219.63	220.0	217.6	219.33	223418.0
2021-07-26 09:00:00	IWM	ETF	219.26	222.05	219.19	221.18	3996266.0
2021-07-26 10:00:00	IWM	ETF	221.19	222.02	220.28	220.39	3971082.0
2021-07-26 11:00:00	IWM	ETF	220.41	220.82	219.85	219.93	2002703.0
2021-07-26 12:00:00	IWM	ETF	219.92	219.94	219.2	219.42	2282995.0
2021-07-26 13:00:00	IWM	ETF	219.435	219.86	219.15	219.66	1421761.0
2021-07-26 14:00:00	IWM	ETF	219.65	220.02	219.25	219.705	1366511.0
2021-07-26 15:00:00	IWM	ETF	219.715	220.33	219.62	220.2	2243027.0
2021-07-26 16:00:00	IWM	ETF	220.19	220.31	220.05	220.1	653231.0
2021-07-26 17:00:00	IWM	ETF	220.11	220.2	220.02	220.2	40992.0
2021-07-26 18:00:00	IWM	ETF	220.2	220.2	220.07	220.14	13519.0
2021-07-26 19:00:00	IWM	ETF	220.03	220.06	219.83	219.83	37629.0
2021-07-26 04:00:00	DIA	ETF	348.0	348.35	347.99	348.35	1200.0
2021-07-26 05:00:00	DIA	ETF	348.79	348.94	348.78	348.94	900.0

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

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