PREVIEW / etf_1hour / 2021-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-12.parquet
  size:    405 KB
  rows:    14,004

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-12 04:00:00	SPY	ETF	443.66	443.78	443.53	443.78	5003.0
2021-08-12 05:00:00	SPY	ETF	443.78	443.83	443.66	443.83	1862.0
2021-08-12 06:00:00	SPY	ETF	443.8	444.04	443.76	443.93	30463.0
2021-08-12 07:00:00	SPY	ETF	443.92	444.04	443.88	443.9	62472.0
2021-08-12 08:00:00	SPY	ETF	443.91	444.072	443.44	443.53	237995.0
2021-08-12 09:00:00	SPY	ETF	443.51	443.75	442.89	443.135	4246636.0
2021-08-12 10:00:00	SPY	ETF	443.14	443.77	442.66	443.75	5107871.0
2021-08-12 11:00:00	SPY	ETF	443.75	444.11	443.38	443.8858	3606778.0
2021-08-12 12:00:00	SPY	ETF	443.88	444.45	443.88	444.335	3177418.0
2021-08-12 13:00:00	SPY	ETF	444.33	444.5	444.12	444.358	1906673.0
2021-08-12 14:00:00	SPY	ETF	444.355	444.9	444.27	444.8518	2789867.0
2021-08-12 15:00:00	SPY	ETF	444.85	445.2572	444.78	445.07	7920934.0
2021-08-12 16:00:00	SPY	ETF	445.07	445.23	444.8429	445.2	2170288.0
2021-08-12 17:00:00	SPY	ETF	445.17	445.26	445.09	445.15	52155.0
2021-08-12 18:00:00	SPY	ETF	445.15	445.15	444.96	445.02	15567.0
2021-08-12 19:00:00	SPY	ETF	445.0	445.03	444.87	444.9	22925.0
2021-08-12 04:00:00	QQQ	ETF	365.6	365.96	365.56	365.83	10634.0
2021-08-12 05:00:00	QQQ	ETF	365.86	365.92	365.72	365.79	8606.0
2021-08-12 06:00:00	QQQ	ETF	365.95	366.49	365.87	366.38	27133.0
2021-08-12 07:00:00	QQQ	ETF	366.31	366.43	366.11	366.28	113518.0
2021-08-12 08:00:00	QQQ	ETF	366.34	366.484	365.38	365.44	326879.0
2021-08-12 09:00:00	QQQ	ETF	365.44	365.8	364.42	365.12	4018461.0
2021-08-12 10:00:00	QQQ	ETF	365.11	367.04	364.295	366.98	4607852.0
2021-08-12 11:00:00	QQQ	ETF	366.98	367.52	366.56	367.14	2787246.0
2021-08-12 12:00:00	QQQ	ETF	367.15	367.255	366.645	366.76	1782486.0
2021-08-12 13:00:00	QQQ	ETF	366.75	367.12	366.5413	366.99	1611368.0
2021-08-12 14:00:00	QQQ	ETF	367.0	367.64	366.93	367.56	1271859.0
2021-08-12 15:00:00	QQQ	ETF	367.56	367.9	367.39	367.58	3424972.0
2021-08-12 16:00:00	QQQ	ETF	367.58	367.85	367.45	367.61	1798339.0
2021-08-12 17:00:00	QQQ	ETF	367.7	367.7	367.53	367.7	25058.0
2021-08-12 18:00:00	QQQ	ETF	367.64	367.64	367.42	367.45	23257.0
2021-08-12 19:00:00	QQQ	ETF	367.45	367.49	367.34	367.35	17847.0
2021-08-12 04:00:00	IWM	ETF	223.75	223.75	223.71	223.71	2300.0
2021-08-12 05:00:00	IWM	ETF	223.84	223.84	223.84	223.84	700.0
2021-08-12 06:00:00	IWM	ETF	223.8	224.04	223.8	224.0	14830.0
2021-08-12 07:00:00	IWM	ETF	223.97	224.03	223.9	223.93	6786.0
2021-08-12 08:00:00	IWM	ETF	224.0382	224.07	223.68	223.9	95993.0
2021-08-12 09:00:00	IWM	ETF	223.85	223.98	222.17	223.0	3303152.0
2021-08-12 10:00:00	IWM	ETF	223.01	223.05	221.88	222.11	3163976.0
2021-08-12 11:00:00	IWM	ETF	222.115	222.55	221.71	222.5042	2481714.0
2021-08-12 12:00:00	IWM	ETF	222.5	222.94	222.5	222.68	1650837.0
2021-08-12 13:00:00	IWM	ETF	222.68	222.75	222.12	222.35	2430354.0
2021-08-12 14:00:00	IWM	ETF	222.34	223.14	222.19	222.985	1832239.0
2021-08-12 15:00:00	IWM	ETF	222.98	223.35	222.7611	223.11	2740810.0
2021-08-12 16:00:00	IWM	ETF	223.16	223.4	223.0	223.16	662448.0
2021-08-12 17:00:00	IWM	ETF	222.96	223.23	222.96	223.1	8543.0
2021-08-12 18:00:00	IWM	ETF	223.11	223.11	222.9	223.0	64255.0
2021-08-12 19:00:00	IWM	ETF	222.98	222.98	222.79	222.83	8599.0
2021-08-12 04:00:00	DIA	ETF	355.16	355.16	355.14	355.14	1300.0
2021-08-12 05:00:00	DIA	ETF	355.43	355.43	355.39	355.39	1300.0

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

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