PREVIEW / etf_1hour / 2023-03-29

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-29.parquet
  size:    463 KB
  rows:    17,001

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
2023-03-29 04:00:00	SPY	ETF	398.81	399.29	397.86	398.95	55963.0
2023-03-29 05:00:00	SPY	ETF	399.06	399.5	399.06	399.5	31751.0
2023-03-29 06:00:00	SPY	ETF	399.48	399.48	398.87	399.12	66410.0
2023-03-29 07:00:00	SPY	ETF	399.07	399.21	398.8	398.8	308929.0
2023-03-29 08:00:00	SPY	ETF	398.83	399.3804	397.54	399.09	356977.0
2023-03-29 09:00:00	SPY	ETF	399.07	400.125	399.07	399.8401	8080445.0
2023-03-29 10:00:00	SPY	ETF	399.85	400.27	398.68	398.82	8552860.0
2023-03-29 11:00:00	SPY	ETF	398.81	399.93	398.75	399.89	5094978.0
2023-03-29 12:00:00	SPY	ETF	399.9	400.12	399.48	399.66	4796523.0
2023-03-29 13:00:00	SPY	ETF	399.66	400.45	399.38	399.5589	4869561.0
2023-03-29 14:00:00	SPY	ETF	399.56	400.71	399.23	400.61	5585644.0
2023-03-29 15:00:00	SPY	ETF	400.63	401.6	400.1	401.34	17690838.0
2023-03-29 16:00:00	SPY	ETF	401.34	401.5	401.13	401.31	5201762.0
2023-03-29 17:00:00	SPY	ETF	401.31	401.4	401.28	401.37	29481.0
2023-03-29 18:00:00	SPY	ETF	401.33	401.44	401.06	401.14	68054.0
2023-03-29 19:00:00	SPY	ETF	401.21	401.22	400.86	400.9	53030.0
2023-03-29 04:00:00	QQQ	ETF	309.8	309.96	309.45	309.74	79720.0
2023-03-29 05:00:00	QQQ	ETF	309.73	310.1	309.73	310.01	25804.0
2023-03-29 06:00:00	QQQ	ETF	310.06	310.06	309.56	309.66	108826.0
2023-03-29 07:00:00	QQQ	ETF	309.65	310.01	309.5	309.67	298314.0
2023-03-29 08:00:00	QQQ	ETF	309.54	310.22	307.35	310.07	550926.0
2023-03-29 09:00:00	QQQ	ETF	310.06	311.83	310.05	311.52	6542032.0
2023-03-29 10:00:00	QQQ	ETF	311.52	311.94	310.05	310.2	6453970.0
2023-03-29 11:00:00	QQQ	ETF	310.19	311.59	310.17	311.57	4429718.0
2023-03-29 12:00:00	QQQ	ETF	311.57	311.89	310.94	311.1257	3030944.0
2023-03-29 13:00:00	QQQ	ETF	311.115	312.035	310.91	311.3399	3767133.0
2023-03-29 14:00:00	QQQ	ETF	311.34	312.44	311.02	312.34	3887977.0
2023-03-29 15:00:00	QQQ	ETF	312.34	313.35	311.88	312.81	9884503.0
2023-03-29 16:00:00	QQQ	ETF	312.8	312.8	312.5	312.58	1605009.0
2023-03-29 17:00:00	QQQ	ETF	312.58	312.756	312.58	312.7	50259.0
2023-03-29 18:00:00	QQQ	ETF	312.69	312.78	312.39	312.45	53185.0
2023-03-29 19:00:00	QQQ	ETF	312.53	312.5699	312.16	312.16	71080.0
2023-03-29 04:00:00	IWM	ETF	174.92	175.67	174.92	175.42	31960.0
2023-03-29 05:00:00	IWM	ETF	175.41	175.84	175.4	175.77	28203.0
2023-03-29 06:00:00	IWM	ETF	175.68	175.73	175.41	175.58	37500.0
2023-03-29 07:00:00	IWM	ETF	175.53	175.6	175.16	175.19	53575.0
2023-03-29 08:00:00	IWM	ETF	175.47	175.6796	174.8	175.15	113527.0
2023-03-29 09:00:00	IWM	ETF	175.11	175.48	174.24	175.27	3309788.0
2023-03-29 10:00:00	IWM	ETF	175.29	175.52	173.965	174.05	3251300.0
2023-03-29 11:00:00	IWM	ETF	174.04	174.76	174.02	174.734	2029355.0
2023-03-29 12:00:00	IWM	ETF	174.73	174.98	174.22	174.35	1104723.0
2023-03-29 13:00:00	IWM	ETF	174.35	174.795	174.2408	174.55	1268604.0
2023-03-29 14:00:00	IWM	ETF	174.55	175.16	174.36	175.015	1816617.0
2023-03-29 15:00:00	IWM	ETF	175.015	175.55	174.62	175.44	5029116.0
2023-03-29 16:00:00	IWM	ETF	175.42	175.5	175.3	175.46	1077089.0
2023-03-29 17:00:00	IWM	ETF	175.32	175.44	175.17	175.2	22795.0
2023-03-29 18:00:00	IWM	ETF	175.29	175.42	175.22	175.27	23287.0
2023-03-29 19:00:00	IWM	ETF	175.29	175.31	175.0	175.1	46330.0
2023-03-29 04:00:00	DIA	ETF	325.44	325.83	325.44	325.83	2200.0
2023-03-29 05:00:00	DIA	ETF	326.21	326.48	326.21	326.48	981.0

> showing 50 of 17,001 rows — these rows as CSV

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