PREVIEW / etf_1hour / 2023-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-15.parquet
  size:    513 KB
  rows:    18,942

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-15 04:00:00	SPY	ETF	450.66	450.67	449.65	449.79	78706.0
2023-11-15 05:00:00	SPY	ETF	449.77	450.61	449.77	450.54	15706.0
2023-11-15 06:00:00	SPY	ETF	450.5	450.76	450.15	450.76	87290.0
2023-11-15 07:00:00	SPY	ETF	450.71	451.05	450.45	451.0	203119.0
2023-11-15 08:00:00	SPY	ETF	451.01	451.76	449.65	450.28	789304.0
2023-11-15 09:00:00	SPY	ETF	450.36	450.75	449.4	449.92	6699742.0
2023-11-15 10:00:00	SPY	ETF	449.92	451.37	449.76	451.09	9247249.0
2023-11-15 11:00:00	SPY	ETF	451.09	451.38	449.6	449.8273	7343823.0
2023-11-15 12:00:00	SPY	ETF	449.825	450.37	449.54	449.77	5059485.0
2023-11-15 13:00:00	SPY	ETF	449.77	450.31	448.8	450.225	6239495.0
2023-11-15 14:00:00	SPY	ETF	450.23	450.69	449.61	450.24	6476212.0
2023-11-15 15:00:00	SPY	ETF	450.24	450.38	449.21	449.63	14109870.0
2023-11-15 16:00:00	SPY	ETF	449.63	450.4835	448.9	449.17	4568725.0
2023-11-15 17:00:00	SPY	ETF	449.18	449.68	448.99	449.03	86683.0
2023-11-15 18:00:00	SPY	ETF	449.1	449.38	449.1	449.3793	42456.0
2023-11-15 19:00:00	SPY	ETF	449.36	449.68	449.31	449.5501	99353.0
2023-11-15 04:00:00	QQQ	ETF	386.32	387.34	386.32	386.63	47795.0
2023-11-15 05:00:00	QQQ	ETF	386.64	387.58	386.64	387.51	38887.0
2023-11-15 06:00:00	QQQ	ETF	387.45	387.71	387.2	387.68	45731.0
2023-11-15 07:00:00	QQQ	ETF	387.66	388.04	387.51	388.02	180128.0
2023-11-15 08:00:00	QQQ	ETF	387.99	389.49	385.618	387.48	1041641.0
2023-11-15 09:00:00	QQQ	ETF	387.5	387.65	385.9906	386.285	6369814.0
2023-11-15 10:00:00	QQQ	ETF	386.29	387.75	386.07	387.33	6509791.0
2023-11-15 11:00:00	QQQ	ETF	387.3292	387.52	385.692	385.83	5554138.0
2023-11-15 12:00:00	QQQ	ETF	385.85	386.28	385.492	385.6448	3817200.0
2023-11-15 13:00:00	QQQ	ETF	385.65	386.08	384.235	386.07	5467311.0
2023-11-15 14:00:00	QQQ	ETF	386.09	386.56	385.33	386.12	3571626.0
2023-11-15 15:00:00	QQQ	ETF	386.13	386.21	385.22	385.61	7032074.0
2023-11-15 16:00:00	QQQ	ETF	385.61	385.65	384.23	384.57	2305920.0
2023-11-15 17:00:00	QQQ	ETF	384.58	384.62	384.3	384.43	71775.0
2023-11-15 18:00:00	QQQ	ETF	384.46	385.0	384.44	385.0	89258.0
2023-11-15 19:00:00	QQQ	ETF	385.01	385.36	385.0	385.24	70316.0
2023-11-15 04:00:00	IWM	ETF	179.49	179.84	178.88	179.0	55925.0
2023-11-15 05:00:00	IWM	ETF	178.96	179.53	178.96	179.4	34229.0
2023-11-15 06:00:00	IWM	ETF	179.4	179.7	179.15	179.63	163593.0
2023-11-15 07:00:00	IWM	ETF	179.63	179.74	179.29	179.6	193241.0
2023-11-15 08:00:00	IWM	ETF	179.6	180.41	178.21	178.95	1282836.0
2023-11-15 09:00:00	IWM	ETF	178.95	179.78	178.11	179.72	6335459.0
2023-11-15 10:00:00	IWM	ETF	179.73	181.48	179.73	181.235	10339725.0
2023-11-15 11:00:00	IWM	ETF	181.23	181.76	179.62	179.73	7949719.0
2023-11-15 12:00:00	IWM	ETF	179.73	180.34	179.54	179.61	3973252.0
2023-11-15 13:00:00	IWM	ETF	179.61	179.6791	178.5	179.43	4640854.0
2023-11-15 14:00:00	IWM	ETF	179.44	179.61	178.68	178.875	3822000.0
2023-11-15 15:00:00	IWM	ETF	178.88	179.145	178.615	178.78	6159525.0
2023-11-15 16:00:00	IWM	ETF	178.77	178.79	178.34	178.57	1362083.0
2023-11-15 17:00:00	IWM	ETF	178.62	178.62	178.36	178.49	45940.0
2023-11-15 18:00:00	IWM	ETF	178.48	178.6	178.4	178.58	58938.0
2023-11-15 19:00:00	IWM	ETF	178.58	178.77	178.56	178.69	7419.0
2023-11-15 04:00:00	DIA	ETF	349.62	349.62	349.1	349.1	1042.0
2023-11-15 05:00:00	DIA	ETF	349.61	349.61	349.6	349.6	1725.0

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

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