PREVIEW / etf_1hour / 2023-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-20.parquet
  size:    515 KB
  rows:    18,868

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-11-20 04:00:00	SPY	ETF	450.62	451.39	450.61	451.39	61118.0
2023-11-20 05:00:00	SPY	ETF	451.41	451.42	450.87	451.01	7707.0
2023-11-20 06:00:00	SPY	ETF	450.96	451.31	450.88	451.27	14083.0
2023-11-20 07:00:00	SPY	ETF	451.09	451.19	450.47	450.54	58078.0
2023-11-20 08:00:00	SPY	ETF	451.14	451.2196	450.12	451.09	211549.0
2023-11-20 09:00:00	SPY	ETF	451.06	452.17	450.52	452.17	4925084.0
2023-11-20 10:00:00	SPY	ETF	452.165	452.6152	451.45	452.615	6554915.0
2023-11-20 11:00:00	SPY	ETF	452.62	452.895	452.52	452.755	4881318.0
2023-11-20 12:00:00	SPY	ETF	452.76	453.08	452.48	452.65	3460079.0
2023-11-20 13:00:00	SPY	ETF	452.65	454.1	452.62	453.9972	6439347.0
2023-11-20 14:00:00	SPY	ETF	454.0	454.71	453.78	454.56	5854905.0
2023-11-20 15:00:00	SPY	ETF	454.555	455.125	453.92	454.24	17460581.0
2023-11-20 16:00:00	SPY	ETF	454.23	454.7701	451.76	454.13	3133986.0
2023-11-20 17:00:00	SPY	ETF	454.15	454.26	454.15	454.25	489457.0
2023-11-20 18:00:00	SPY	ETF	454.26	454.43	454.16	454.42	101525.0
2023-11-20 19:00:00	SPY	ETF	454.41	454.62	454.27	454.43	61094.0
2023-11-20 04:00:00	QQQ	ETF	385.78	386.87	385.77	386.87	77273.0
2023-11-20 05:00:00	QQQ	ETF	386.89	386.93	386.42	386.56	43507.0
2023-11-20 06:00:00	QQQ	ETF	386.52	386.85	386.29	386.7	48060.0
2023-11-20 07:00:00	QQQ	ETF	386.62	386.73	385.94	386.08	104596.0
2023-11-20 08:00:00	QQQ	ETF	386.66	386.7	384.69	386.5	139270.0
2023-11-20 09:00:00	QQQ	ETF	386.49	388.52	385.94	388.48	4692625.0
2023-11-20 10:00:00	QQQ	ETF	388.5	388.65	387.1	388.59	4850335.0
2023-11-20 11:00:00	QQQ	ETF	388.59	389.09	388.59	388.9099	4434117.0
2023-11-20 12:00:00	QQQ	ETF	388.91	389.36	388.68	388.87	3079807.0
2023-11-20 13:00:00	QQQ	ETF	388.88	390.43	388.83	390.32	5671782.0
2023-11-20 14:00:00	QQQ	ETF	390.31	390.95	390.02	390.88	3879785.0
2023-11-20 15:00:00	QQQ	ETF	390.885	391.41	390.425	390.74	8053955.0
2023-11-20 16:00:00	QQQ	ETF	390.74	390.77	390.5	390.74	1448199.0
2023-11-20 17:00:00	QQQ	ETF	390.71	390.76	390.63	390.74	36123.0
2023-11-20 18:00:00	QQQ	ETF	390.75	391.04	390.6311	391.04	71394.0
2023-11-20 19:00:00	QQQ	ETF	391.0	391.2	390.86	391.1	48485.0
2023-11-20 04:00:00	IWM	ETF	178.15	178.46	178.08	178.42	23184.0
2023-11-20 05:00:00	IWM	ETF	178.43	178.45	178.22	178.34	9542.0
2023-11-20 06:00:00	IWM	ETF	178.39	178.44	178.32	178.43	5676.0
2023-11-20 07:00:00	IWM	ETF	178.4	178.46	177.63	177.82	47320.0
2023-11-20 08:00:00	IWM	ETF	178.45	178.53	177.69	178.41	120068.0
2023-11-20 09:00:00	IWM	ETF	178.39	179.09	177.74	178.82	4066692.0
2023-11-20 10:00:00	IWM	ETF	178.82	179.4482	178.58	179.415	3335190.0
2023-11-20 11:00:00	IWM	ETF	179.42	179.505	179.09	179.14	2143066.0
2023-11-20 12:00:00	IWM	ETF	179.1342	179.375	178.9	179.12	1723957.0
2023-11-20 13:00:00	IWM	ETF	179.12	179.65	179.08	179.42	2169763.0
2023-11-20 14:00:00	IWM	ETF	179.42	179.47	178.99	179.28	2358846.0
2023-11-20 15:00:00	IWM	ETF	179.27	179.44	179.115	179.32	5345320.0
2023-11-20 16:00:00	IWM	ETF	179.33	179.38	179.14	179.34	813611.0
2023-11-20 17:00:00	IWM	ETF	179.33	179.4	179.31	179.37	8919.0
2023-11-20 18:00:00	IWM	ETF	179.37	179.56	179.37	179.56	21162.0
2023-11-20 19:00:00	IWM	ETF	179.56	179.66	179.45	179.58	20067.0
2023-11-20 04:00:00	DIA	ETF	349.29	349.61	349.29	349.58	6422.0
2023-11-20 06:00:00	DIA	ETF	349.51	349.51	349.5	349.5	200.0

> showing 50 of 18,868 rows — these rows as CSV

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