PREVIEW / etf_1hour / 2023-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-28.parquet
  size:    479 KB
  rows:    17,544

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-07-28 04:00:00	SPY	ETF	454.21	454.34	453.65	454.11	22488.0
2023-07-28 05:00:00	SPY	ETF	454.14	454.72	454.0	454.57	83296.0
2023-07-28 06:00:00	SPY	ETF	454.64	454.64	454.12	454.5	70697.0
2023-07-28 07:00:00	SPY	ETF	454.48	455.13	454.0	455.05	240945.0
2023-07-28 08:00:00	SPY	ETF	454.73	455.81	452.17	455.78	675055.0
2023-07-28 09:00:00	SPY	ETF	455.78	456.59	455.16	456.1499	7339834.0
2023-07-28 10:00:00	SPY	ETF	456.14	456.87	455.94	456.7822	10049890.0
2023-07-28 11:00:00	SPY	ETF	456.79	457.78	456.59	457.68	5774010.0
2023-07-28 12:00:00	SPY	ETF	457.675	457.68	456.88	457.0399	4811754.0
2023-07-28 13:00:00	SPY	ETF	457.04	457.045	455.06	456.27	6992037.0
2023-07-28 14:00:00	SPY	ETF	456.27	457.36	456.14	457.0099	5947328.0
2023-07-28 15:00:00	SPY	ETF	457.01	457.305	456.33	456.91	14238920.0
2023-07-28 16:00:00	SPY	ETF	456.88	456.9914	455.0	456.9	3797774.0
2023-07-28 17:00:00	SPY	ETF	456.73	457.09	456.73	456.96	73781.0
2023-07-28 18:00:00	SPY	ETF	456.92	457.0	456.51	456.7	43579.0
2023-07-28 19:00:00	SPY	ETF	456.83	457.01	456.83	457.01	24665.0
2023-07-28 04:00:00	QQQ	ETF	379.17	379.54	378.31	379.1	58971.0
2023-07-28 05:00:00	QQQ	ETF	379.16	379.8	378.9	379.8	63057.0
2023-07-28 06:00:00	QQQ	ETF	379.82	380.06	379.33	379.79	38617.0
2023-07-28 07:00:00	QQQ	ETF	379.76	380.29	379.52	380.2	184236.0
2023-07-28 08:00:00	QQQ	ETF	379.7608	381.1	376.338	380.88	691879.0
2023-07-28 09:00:00	QQQ	ETF	380.91	382.69	380.22	382.02	6612186.0
2023-07-28 10:00:00	QQQ	ETF	382.03	383.12	381.79	382.6102	5886490.0
2023-07-28 11:00:00	QQQ	ETF	382.63	384.52	382.565	384.49	4410077.0
2023-07-28 12:00:00	QQQ	ETF	384.485	384.49	383.345	383.53	4280138.0
2023-07-28 13:00:00	QQQ	ETF	383.52	383.52	381.615	383.055	4934273.0
2023-07-28 14:00:00	QQQ	ETF	383.055	384.1898	382.73	383.81	4308920.0
2023-07-28 15:00:00	QQQ	ETF	383.8	384.16	383.0	383.48	6894519.0
2023-07-28 16:00:00	QQQ	ETF	383.48	383.48	383.1	383.33	1194080.0
2023-07-28 17:00:00	QQQ	ETF	383.35	383.58	383.24	383.44	18379.0
2023-07-28 18:00:00	QQQ	ETF	383.48	383.59	383.33	383.43	20146.0
2023-07-28 19:00:00	QQQ	ETF	383.47	383.74	383.41	383.73	19896.0
2023-07-28 04:00:00	IWM	ETF	194.65	194.7	194.4	194.59	9623.0
2023-07-28 05:00:00	IWM	ETF	194.59	194.8	194.5	194.69	12881.0
2023-07-28 06:00:00	IWM	ETF	194.69	194.81	194.52	194.78	5689.0
2023-07-28 07:00:00	IWM	ETF	194.76	195.24	194.69	195.22	53068.0
2023-07-28 08:00:00	IWM	ETF	195.2	195.86	193.67	195.83	135777.0
2023-07-28 09:00:00	IWM	ETF	195.74	196.77	195.35	196.27	3349061.0
2023-07-28 10:00:00	IWM	ETF	196.26	196.95	195.99	196.52	2805452.0
2023-07-28 11:00:00	IWM	ETF	196.53	196.75	196.255	196.67	1678829.0
2023-07-28 12:00:00	IWM	ETF	196.66	196.9199	196.29	196.735	1239064.0
2023-07-28 13:00:00	IWM	ETF	196.73	196.73	195.705	196.36	1641995.0
2023-07-28 14:00:00	IWM	ETF	196.35	196.76	196.33	196.59	1079926.0
2023-07-28 15:00:00	IWM	ETF	196.6	196.77	196.39	196.45	3373493.0
2023-07-28 16:00:00	IWM	ETF	196.43	196.47	196.36	196.44	884161.0
2023-07-28 17:00:00	IWM	ETF	196.37	196.59	196.37	196.44	508875.0
2023-07-28 18:00:00	IWM	ETF	196.51	196.8	196.36	196.68	54540.0
2023-07-28 19:00:00	IWM	ETF	196.68	197.0	196.66	196.76	17625.0
2023-07-28 05:00:00	DIA	ETF	353.37	353.4	353.37	353.4	3525.0
2023-07-28 06:00:00	DIA	ETF	353.4	353.4	353.34	353.34	600.0

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

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