PREVIEW / etf_1hour / 2023-03-21

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-21.parquet
  size:    461 KB
  rows:    17,158

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-21 04:00:00	SPY	ETF	394.78	395.12	394.25	395.0	45542.0
2023-03-21 05:00:00	SPY	ETF	394.96	395.85	394.72	395.84	67876.0
2023-03-21 06:00:00	SPY	ETF	395.92	396.68	395.65	396.07	137177.0
2023-03-21 07:00:00	SPY	ETF	396.05	397.16	395.88	396.97	709624.0
2023-03-21 08:00:00	SPY	ETF	396.3001	397.17	393.99	396.92	486398.0
2023-03-21 09:00:00	SPY	ETF	396.92	397.99	396.8	397.88	7060057.0
2023-03-21 10:00:00	SPY	ETF	397.87	398.3393	395.83	396.24	11161454.0
2023-03-21 11:00:00	SPY	ETF	396.25	397.305	395.58	395.885	6942151.0
2023-03-21 12:00:00	SPY	ETF	395.9	396.88	395.66	396.41	5331205.0
2023-03-21 13:00:00	SPY	ETF	396.42	397.419	396.15	396.275	5216361.0
2023-03-21 14:00:00	SPY	ETF	396.27	397.93	396.24	397.66	5894124.0
2023-03-21 15:00:00	SPY	ETF	397.65	399.41	397.6	398.87	18497380.0
2023-03-21 16:00:00	SPY	ETF	398.87	399.21	397.4136	398.96	4791630.0
2023-03-21 17:00:00	SPY	ETF	398.99	399.01	398.85	398.88	56915.0
2023-03-21 18:00:00	SPY	ETF	398.91	398.91	398.62	398.85	76416.0
2023-03-21 19:00:00	SPY	ETF	398.83	398.96	398.71	398.89	120136.0
2023-03-21 04:00:00	QQQ	ETF	306.67	306.94	306.35	306.59	35105.0
2023-03-21 05:00:00	QQQ	ETF	306.35	306.52	306.08	306.52	38132.0
2023-03-21 06:00:00	QQQ	ETF	306.69	307.29	306.43	306.77	63007.0
2023-03-21 07:00:00	QQQ	ETF	306.76	308.32	306.75	308.13	214134.0
2023-03-21 08:00:00	QQQ	ETF	308.0114	308.28	305.91	307.67	402196.0
2023-03-21 09:00:00	QQQ	ETF	307.64	308.94	307.59	308.8505	4891147.0
2023-03-21 10:00:00	QQQ	ETF	308.86	309.4	306.418	306.86	6568140.0
2023-03-21 11:00:00	QQQ	ETF	306.87	307.98	306.395	306.8501	4388332.0
2023-03-21 12:00:00	QQQ	ETF	306.87	308.21	306.67	308.01	3669975.0
2023-03-21 13:00:00	QQQ	ETF	308.005	308.95	307.815	308.06	3155128.0
2023-03-21 14:00:00	QQQ	ETF	308.09	309.64	308.031	309.43	3141584.0
2023-03-21 15:00:00	QQQ	ETF	309.43	310.8	309.39	310.32	8419972.0
2023-03-21 16:00:00	QQQ	ETF	310.32	310.52	310.19	310.22	1950517.0
2023-03-21 17:00:00	QQQ	ETF	310.28	310.31	310.01	310.03	113257.0
2023-03-21 18:00:00	QQQ	ETF	310.09	310.34	309.99	310.06	581258.0
2023-03-21 19:00:00	QQQ	ETF	310.13	310.22	309.99	310.1	41548.0
2023-03-21 04:00:00	IWM	ETF	174.48	174.96	174.18	174.89	35644.0
2023-03-21 05:00:00	IWM	ETF	174.97	175.78	174.76	175.78	21212.0
2023-03-21 06:00:00	IWM	ETF	175.77	176.12	175.57	175.72	99934.0
2023-03-21 07:00:00	IWM	ETF	175.861	176.22	175.661	176.1	125077.0
2023-03-21 08:00:00	IWM	ETF	175.75	176.55	174.29	176.49	176794.0
2023-03-21 09:00:00	IWM	ETF	176.52	177.575	176.33	177.36	4260800.0
2023-03-21 10:00:00	IWM	ETF	177.36	178.18	176.01	176.15	4966316.0
2023-03-21 11:00:00	IWM	ETF	176.22	177.14	176.13	176.3	2441017.0
2023-03-21 12:00:00	IWM	ETF	176.295	176.74	176.02	176.185	2646746.0
2023-03-21 13:00:00	IWM	ETF	176.185	176.74	175.96	176.01	1572468.0
2023-03-21 14:00:00	IWM	ETF	176.01	176.76	175.98	176.595	1761419.0
2023-03-21 15:00:00	IWM	ETF	176.59	177.31	176.55	176.75	6001563.0
2023-03-21 16:00:00	IWM	ETF	176.65	177.17	176.65	177.15	1378305.0
2023-03-21 17:00:00	IWM	ETF	177.14	177.19	176.96	177.07	17812.0
2023-03-21 18:00:00	IWM	ETF	177.08	177.15	176.77	177.02	35289.0
2023-03-21 19:00:00	IWM	ETF	176.98	177.06	176.86	177.02	23556.0
2023-03-21 05:00:00	DIA	ETF	323.59	324.43	323.59	324.43	2100.0
2023-03-21 06:00:00	DIA	ETF	324.5	325.15	324.5	324.6	4570.0

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

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