PREVIEW / etf_1hour / 2021-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-02.parquet
  size:    422 KB
  rows:    14,854

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-08-02 04:00:00	SPY	ETF	440.6	441.3	440.6	441.1	24989.0
2021-08-02 05:00:00	SPY	ETF	441.08	441.27	440.99	441.21	2768.0
2021-08-02 06:00:00	SPY	ETF	441.02	441.09	440.01	440.03	61680.0
2021-08-02 07:00:00	SPY	ETF	439.99	440.51	439.75	440.48	178663.0
2021-08-02 08:00:00	SPY	ETF	440.03	441.35	439.86	440.19	175346.0
2021-08-02 09:00:00	SPY	ETF	440.2	440.93	439.96	440.23	6240561.0
2021-08-02 10:00:00	SPY	ETF	440.22	440.76	439.68	439.98	6836774.0
2021-08-02 11:00:00	SPY	ETF	439.985	440.4	438.77	438.8411	4616858.0
2021-08-02 12:00:00	SPY	ETF	438.84	439.16	438.19	438.815	6337822.0
2021-08-02 13:00:00	SPY	ETF	438.82	439.22	438.16	438.56	4431084.0
2021-08-02 14:00:00	SPY	ETF	438.56	438.97	438.4	438.7799	3868960.0
2021-08-02 15:00:00	SPY	ETF	438.78	438.9	437.21	437.58	11719729.0
2021-08-02 16:00:00	SPY	ETF	437.59	437.97	437.53	437.94	2043448.0
2021-08-02 17:00:00	SPY	ETF	437.94	437.97	437.83	437.91	85437.0
2021-08-02 18:00:00	SPY	ETF	437.91	438.34	437.59	438.24	88835.0
2021-08-02 19:00:00	SPY	ETF	438.24	438.27	437.94	438.17	42698.0
2021-08-02 04:00:00	QQQ	ETF	366.02	366.64	366.02	366.59	79073.0
2021-08-02 05:00:00	QQQ	ETF	366.61	366.72	366.41	366.66	46399.0
2021-08-02 06:00:00	QQQ	ETF	366.65	366.65	365.66	365.77	86663.0
2021-08-02 07:00:00	QQQ	ETF	365.72	366.41	365.66	366.34	153630.0
2021-08-02 08:00:00	QQQ	ETF	366.0096	366.75	364.843	366.14	227940.0
2021-08-02 09:00:00	QQQ	ETF	366.17	366.71	364.11	365.09	3948703.0
2021-08-02 10:00:00	QQQ	ETF	365.07	366.389	364.27	366.2602	3734307.0
2021-08-02 11:00:00	QQQ	ETF	366.27	366.88	365.57	365.65	2601239.0
2021-08-02 12:00:00	QQQ	ETF	365.66	365.77	364.69	365.38	2480781.0
2021-08-02 13:00:00	QQQ	ETF	365.4	365.98	364.98	365.3082	1848996.0
2021-08-02 14:00:00	QQQ	ETF	365.3	365.6399	365.121	365.42	1484741.0
2021-08-02 15:00:00	QQQ	ETF	365.44	365.62	363.87	364.52	3728344.0
2021-08-02 16:00:00	QQQ	ETF	364.55	364.83	364.52	364.67	983504.0
2021-08-02 17:00:00	QQQ	ETF	364.68	364.71	364.46	364.58	48930.0
2021-08-02 18:00:00	QQQ	ETF	364.61	364.95	364.57	364.87	51237.0
2021-08-02 19:00:00	QQQ	ETF	364.85	364.86	364.48	364.69	61361.0
2021-08-02 04:00:00	IWM	ETF	222.16	223.65	222.16	223.41	29374.0
2021-08-02 05:00:00	IWM	ETF	223.43	223.53	223.38	223.4	31407.0
2021-08-02 06:00:00	IWM	ETF	223.3	223.42	222.4	222.4	104158.0
2021-08-02 07:00:00	IWM	ETF	222.44	223.02	222.29	222.93	157478.0
2021-08-02 08:00:00	IWM	ETF	222.9299	223.06	222.36	222.5	178691.0
2021-08-02 09:00:00	IWM	ETF	222.62	224.55	222.01	224.0	3369143.0
2021-08-02 10:00:00	IWM	ETF	223.99	224.35	222.01	222.08	3626306.0
2021-08-02 11:00:00	IWM	ETF	222.08	222.58	221.02	221.06	2038559.0
2021-08-02 12:00:00	IWM	ETF	221.08	221.83	220.5	221.38	2602669.0
2021-08-02 13:00:00	IWM	ETF	221.39	221.72	221.2	221.44	1500553.0
2021-08-02 14:00:00	IWM	ETF	221.45	222.23	221.28	221.5	2022860.0
2021-08-02 15:00:00	IWM	ETF	221.51	221.67	219.64	219.92	4276217.0
2021-08-02 16:00:00	IWM	ETF	219.95	220.19	219.92	220.17	646888.0
2021-08-02 17:00:00	IWM	ETF	220.07	220.18	220.01	220.12	20383.0
2021-08-02 18:00:00	IWM	ETF	220.11	220.58	220.11	220.5	36006.0
2021-08-02 19:00:00	IWM	ETF	220.3	220.51	220.16	220.34	45425.0
2021-08-02 04:00:00	DIA	ETF	351.33	351.33	351.01	351.01	1700.0
2021-08-02 05:00:00	DIA	ETF	351.2	351.33	351.17	351.33	800.0

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

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