PREVIEW / etf_1hour / 2024-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-05-14.parquet
  size:    526 KB
  rows:    19,649

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-14 04:00:00	SPY	ETF	521.03	521.21	520.98	521.2	6072.0
2024-05-14 05:00:00	SPY	ETF	521.18	521.18	520.95	521.16	6348.0
2024-05-14 06:00:00	SPY	ETF	521.15	521.25	520.99	521.22	10544.0
2024-05-14 07:00:00	SPY	ETF	521.2	521.24	520.98	521.13	27131.0
2024-05-14 08:00:00	SPY	ETF	521.08	521.43	518.18	520.87	954787.0
2024-05-14 09:00:00	SPY	ETF	520.86	521.68	520.52	521.3	3838579.0
2024-05-14 10:00:00	SPY	ETF	521.27	522.41	520.64	521.765	5971067.0
2024-05-14 11:00:00	SPY	ETF	521.77	522.13	520.96	521.09	2813974.0
2024-05-14 12:00:00	SPY	ETF	521.095	521.3	520.68	520.98	2260068.0
2024-05-14 13:00:00	SPY	ETF	520.98	521.485	520.56	521.29	2487542.0
2024-05-14 14:00:00	SPY	ETF	521.28	523.5225	521.23	523.2687	5531298.0
2024-05-14 15:00:00	SPY	ETF	523.255	523.83	522.985	523.29	12376345.0
2024-05-14 16:00:00	SPY	ETF	523.29	523.4259	523.09	523.33	5263228.0
2024-05-14 17:00:00	SPY	ETF	523.38	523.4	523.1	523.27	54927.0
2024-05-14 18:00:00	SPY	ETF	523.22	523.76	523.1	523.71	54653.0
2024-05-14 19:00:00	SPY	ETF	523.7	523.73	523.55	523.6	30823.0
2024-05-14 04:00:00	QQQ	ETF	443.01	443.43	443.01	443.43	13944.0
2024-05-14 05:00:00	QQQ	ETF	443.37	443.43	443.02	443.3	10432.0
2024-05-14 06:00:00	QQQ	ETF	443.3	443.36	443.04	443.31	15479.0
2024-05-14 07:00:00	QQQ	ETF	443.3	443.35	442.82	442.94	43559.0
2024-05-14 08:00:00	QQQ	ETF	443.3205	443.42	440.06	442.39	547653.0
2024-05-14 09:00:00	QQQ	ETF	442.4	443.911	442.1	443.055	4175696.0
2024-05-14 10:00:00	QQQ	ETF	443.03	444.97	442.66	444.2197	5283289.0
2024-05-14 11:00:00	QQQ	ETF	444.21	444.88	443.4	443.77	2740885.0
2024-05-14 12:00:00	QQQ	ETF	443.765	444.03	443.24	443.6889	1851240.0
2024-05-14 13:00:00	QQQ	ETF	443.69	444.22	443.24	444.02	1706280.0
2024-05-14 14:00:00	QQQ	ETF	444.02	446.04	443.965	445.9	3761540.0
2024-05-14 15:00:00	QQQ	ETF	445.9	446.465	445.6	445.97	6195753.0
2024-05-14 16:00:00	QQQ	ETF	445.96	446.11	445.75	445.93	737254.0
2024-05-14 17:00:00	QQQ	ETF	445.93	445.95	445.61	445.799	31584.0
2024-05-14 18:00:00	QQQ	ETF	445.8	446.32	445.79	446.289	37669.0
2024-05-14 19:00:00	QQQ	ETF	446.3	446.3	446.06	446.13	32858.0
2024-05-14 04:00:00	IWM	ETF	204.93	205.17	204.87	205.04	13644.0
2024-05-14 05:00:00	IWM	ETF	205.0	205.1	204.91	205.1	9309.0
2024-05-14 06:00:00	IWM	ETF	205.07	205.23	204.93	205.21	5727.0
2024-05-14 07:00:00	IWM	ETF	205.3	205.769	205.25	205.74	93032.0
2024-05-14 08:00:00	IWM	ETF	205.2214	206.91	203.0	206.51	1743063.0
2024-05-14 09:00:00	IWM	ETF	206.5	207.74	206.31	207.12	3753392.0
2024-05-14 10:00:00	IWM	ETF	207.11	207.2	206.11	206.88	4321933.0
2024-05-14 11:00:00	IWM	ETF	206.88	207.02	206.625	206.67	2533497.0
2024-05-14 12:00:00	IWM	ETF	206.66	206.725	206.125	206.27	1384590.0
2024-05-14 13:00:00	IWM	ETF	206.28	206.4	205.91	206.1	2043736.0
2024-05-14 14:00:00	IWM	ETF	206.105	206.85	206.08	206.65	2142348.0
2024-05-14 15:00:00	IWM	ETF	206.65	207.2	206.5	206.87	4770009.0
2024-05-14 16:00:00	IWM	ETF	206.86	207.21	206.79	207.21	1357989.0
2024-05-14 17:00:00	IWM	ETF	207.12	207.12	206.84	206.95	111478.0
2024-05-14 18:00:00	IWM	ETF	207.03	207.4	206.92	207.4	64995.0
2024-05-14 19:00:00	IWM	ETF	207.4	207.44	207.27	207.38	27644.0
2024-05-14 05:00:00	DIA	ETF	394.72	394.76	394.72	394.76	200.0
2024-05-14 06:00:00	DIA	ETF	395.0	395.0	395.0	395.0	100.0

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

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