PREVIEW / etf_1hour / 2024-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-05-13.parquet
  size:    520 KB
  rows:    19,477

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
2024-05-13 04:00:00	SPY	ETF	521.2	521.66	521.2	521.36	15911.0
2024-05-13 05:00:00	SPY	ETF	521.36	521.74	521.36	521.56	11532.0
2024-05-13 06:00:00	SPY	ETF	521.58	521.85	521.56	521.76	21201.0
2024-05-13 07:00:00	SPY	ETF	521.81	522.32	521.4	522.31	197256.0
2024-05-13 08:00:00	SPY	ETF	521.72	522.4101	521.24	522.33	258521.0
2024-05-13 09:00:00	SPY	ETF	522.3	522.73	521.1	521.695	4538085.0
2024-05-13 10:00:00	SPY	ETF	521.68	521.845	521.12	521.26	3925260.0
2024-05-13 11:00:00	SPY	ETF	521.27	521.46	520.4	521.0404	3315010.0
2024-05-13 12:00:00	SPY	ETF	521.045	521.375	520.995	521.005	2014504.0
2024-05-13 13:00:00	SPY	ETF	521.0	521.0	519.74	520.6888	3437340.0
2024-05-13 14:00:00	SPY	ETF	520.68	520.99	520.315	520.92	2759020.0
2024-05-13 15:00:00	SPY	ETF	520.905	521.1396	520.47	520.91	6312605.0
2024-05-13 16:00:00	SPY	ETF	520.9	521.1	520.52	520.64	2342762.0
2024-05-13 17:00:00	SPY	ETF	520.7	520.75	520.61	520.62	16694.0
2024-05-13 18:00:00	SPY	ETF	520.62	520.8299	520.6	520.77	19979.0
2024-05-13 19:00:00	SPY	ETF	520.73	520.88	520.7	520.79	24966.0
2024-05-13 04:00:00	QQQ	ETF	442.72	443.12	442.59	442.75	28027.0
2024-05-13 05:00:00	QQQ	ETF	442.69	443.28	442.69	442.94	17150.0
2024-05-13 06:00:00	QQQ	ETF	442.93	443.26	442.92	443.26	22714.0
2024-05-13 07:00:00	QQQ	ETF	443.32	443.701	443.17	443.66	38654.0
2024-05-13 08:00:00	QQQ	ETF	443.18	443.91	442.391	443.87	132522.0
2024-05-13 09:00:00	QQQ	ETF	443.85	444.1	442.08	442.9	2801374.0
2024-05-13 10:00:00	QQQ	ETF	442.91	443.5	442.69	443.06	2553294.0
2024-05-13 11:00:00	QQQ	ETF	443.06	443.41	442.24	443.07	2425401.0
2024-05-13 12:00:00	QQQ	ETF	443.06	443.44	443.04	443.07	999706.0
2024-05-13 13:00:00	QQQ	ETF	443.06	443.13	441.65	442.8301	2313439.0
2024-05-13 14:00:00	QQQ	ETF	442.82	442.95	442.435	442.92	1135153.0
2024-05-13 15:00:00	QQQ	ETF	442.92	443.2299	442.57	443.1	2865047.0
2024-05-13 16:00:00	QQQ	ETF	443.09	443.23	442.6697	442.86	569175.0
2024-05-13 17:00:00	QQQ	ETF	442.87	443.0	442.85	442.98	11990.0
2024-05-13 18:00:00	QQQ	ETF	442.88	442.96	442.66	442.82	26557.0
2024-05-13 19:00:00	QQQ	ETF	442.7597	442.92	442.73	442.85	44836.0
2024-05-13 04:00:00	IWM	ETF	204.79	205.03	204.11	205.03	25751.0
2024-05-13 05:00:00	IWM	ETF	205.02	205.14	205.0	205.03	8837.0
2024-05-13 06:00:00	IWM	ETF	205.13	205.3	205.09	205.3	10019.0
2024-05-13 07:00:00	IWM	ETF	205.25	205.43	205.15	205.33	97710.0
2024-05-13 08:00:00	IWM	ETF	205.22	205.84	204.54	205.8	227120.0
2024-05-13 09:00:00	IWM	ETF	205.81	206.43	205.44	206.39	2290077.0
2024-05-13 10:00:00	IWM	ETF	206.39	206.55	205.825	206.02	2989833.0
2024-05-13 11:00:00	IWM	ETF	206.03	206.16	205.25	205.615	1259268.0
2024-05-13 12:00:00	IWM	ETF	205.61	205.7183	205.3	205.3	867657.0
2024-05-13 13:00:00	IWM	ETF	205.29	205.29	204.645	204.93	1542200.0
2024-05-13 14:00:00	IWM	ETF	204.93	205.23	204.72	205.04	1240548.0
2024-05-13 15:00:00	IWM	ETF	205.05	205.14	204.6	204.72	3320356.0
2024-05-13 16:00:00	IWM	ETF	204.74	204.81	204.48	204.69	770031.0
2024-05-13 17:00:00	IWM	ETF	204.67	204.74	204.54	204.71	74088.0
2024-05-13 18:00:00	IWM	ETF	204.71	204.71	204.59	204.64	4043.0
2024-05-13 19:00:00	IWM	ETF	204.67	204.77	204.58	204.62	57116.0
2024-05-13 05:00:00	DIA	ETF	395.49	395.49	395.49	395.49	300.0
2024-05-13 06:00:00	DIA	ETF	395.56	395.66	395.54	395.54	4519.0

> showing 50 of 19,477 rows — these rows as CSV

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