PREVIEW / etf_1hour / 2023-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-19.parquet
  size:    489 KB
  rows:    17,975

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-19 04:00:00	SPY	ETF	454.09	454.61	454.09	454.55	47671.0
2023-07-19 05:00:00	SPY	ETF	454.42	454.64	454.42	454.5	31420.0
2023-07-19 06:00:00	SPY	ETF	454.47	454.54	454.37	454.51	23642.0
2023-07-19 07:00:00	SPY	ETF	454.52	454.59	454.0	454.21	79574.0
2023-07-19 08:00:00	SPY	ETF	454.26	454.71	454.02	454.43	229377.0
2023-07-19 09:00:00	SPY	ETF	454.44	456.12	454.4312	456.02	6738967.0
2023-07-19 10:00:00	SPY	ETF	456.01	456.34	454.6	455.28	8978739.0
2023-07-19 11:00:00	SPY	ETF	455.29	456.15	455.09	455.98	5118473.0
2023-07-19 12:00:00	SPY	ETF	455.98	456.43	454.76	455.359	7188542.0
2023-07-19 13:00:00	SPY	ETF	455.37	455.41	454.65	455.0785	3600952.0
2023-07-19 14:00:00	SPY	ETF	455.075	455.47	454.37	455.375	5627873.0
2023-07-19 15:00:00	SPY	ETF	455.38	456.07	455.03	455.13	9287135.0
2023-07-19 16:00:00	SPY	ETF	455.11	455.3	454.66	455.05	2409480.0
2023-07-19 17:00:00	SPY	ETF	455.03	455.19	454.8	454.82	144956.0
2023-07-19 18:00:00	SPY	ETF	454.83	454.92	453.69	453.82	315784.0
2023-07-19 19:00:00	SPY	ETF	453.86	454.05	453.74	454.01	78507.0
2023-07-19 04:00:00	QQQ	ETF	385.84	386.29	385.62	386.19	37358.0
2023-07-19 05:00:00	QQQ	ETF	386.18	386.7	386.01	386.54	44432.0
2023-07-19 06:00:00	QQQ	ETF	386.54	386.6	386.14	386.6	35202.0
2023-07-19 07:00:00	QQQ	ETF	386.6	386.7	386.06	386.29	113486.0
2023-07-19 08:00:00	QQQ	ETF	386.32	386.85	385.42	386.72	297707.0
2023-07-19 09:00:00	QQQ	ETF	386.67	387.38	385.955	386.53	5361352.0
2023-07-19 10:00:00	QQQ	ETF	386.535	387.54	385.79	386.5199	6159583.0
2023-07-19 11:00:00	QQQ	ETF	386.52	387.655	386.26	387.0897	4491831.0
2023-07-19 12:00:00	QQQ	ETF	387.07	387.98	385.215	385.8388	8463692.0
2023-07-19 13:00:00	QQQ	ETF	385.85	385.9393	384.69	385.17	4417591.0
2023-07-19 14:00:00	QQQ	ETF	385.18	385.37	384.3	385.3	4130692.0
2023-07-19 15:00:00	QQQ	ETF	385.3	386.45	385.28	385.39	5840184.0
2023-07-19 16:00:00	QQQ	ETF	385.39	385.85	384.42	385.02	1792266.0
2023-07-19 17:00:00	QQQ	ETF	385.02	385.11	384.42	384.6	90591.0
2023-07-19 18:00:00	QQQ	ETF	384.48	384.6	382.72	382.99	521433.0
2023-07-19 19:00:00	QQQ	ETF	382.99	383.11	382.68	383.0	181537.0
2023-07-19 04:00:00	IWM	ETF	196.11	196.38	196.11	196.29	8177.0
2023-07-19 05:00:00	IWM	ETF	196.33	196.43	196.17	196.19	8960.0
2023-07-19 06:00:00	IWM	ETF	196.18	196.18	196.09	196.14	18491.0
2023-07-19 07:00:00	IWM	ETF	196.2	196.21	195.47	195.57	101452.0
2023-07-19 08:00:00	IWM	ETF	195.56	196.2304	195.43	195.78	136352.0
2023-07-19 09:00:00	IWM	ETF	195.81	197.66	195.73	197.2	3753990.0
2023-07-19 10:00:00	IWM	ETF	197.2	197.42	196.26	196.59	2662308.0
2023-07-19 11:00:00	IWM	ETF	196.61	197.248	196.375	196.97	2034457.0
2023-07-19 12:00:00	IWM	ETF	196.97	197.165	195.9301	196.68	1942738.0
2023-07-19 13:00:00	IWM	ETF	196.68	196.695	196.13	196.41	1569854.0
2023-07-19 14:00:00	IWM	ETF	196.41	196.7184	196.11	196.49	1597816.0
2023-07-19 15:00:00	IWM	ETF	196.5	197.05	196.48	196.77	3022123.0
2023-07-19 16:00:00	IWM	ETF	196.76	197.03	196.68	196.98	641113.0
2023-07-19 17:00:00	IWM	ETF	196.91	196.98	196.71	196.85	50786.0
2023-07-19 18:00:00	IWM	ETF	196.88	196.95	196.48	196.62	44793.0
2023-07-19 19:00:00	IWM	ETF	196.6	196.73	196.53	196.57	39558.0
2023-07-19 04:00:00	DIA	ETF	350.13	350.13	350.13	350.13	1000.0
2023-07-19 05:00:00	DIA	ETF	350.34	350.36	350.12	350.12	800.0

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

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