PREVIEW / etf_1hour / 2023-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-16.parquet
  size:    483 KB
  rows:    17,622

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-08-16 04:00:00	SPY	ETF	443.71	444.33	443.71	443.94	47564.0
2023-08-16 05:00:00	SPY	ETF	443.98	444.06	442.89	443.12	43855.0
2023-08-16 06:00:00	SPY	ETF	443.15	443.28	442.88	443.06	38779.0
2023-08-16 07:00:00	SPY	ETF	443.05	443.21	442.48	443.19	169556.0
2023-08-16 08:00:00	SPY	ETF	442.95	444.01	442.12	442.15	386057.0
2023-08-16 09:00:00	SPY	ETF	442.16	444.18	442.09	443.5199	5723196.0
2023-08-16 10:00:00	SPY	ETF	443.515	444.1393	442.96	443.94	5769047.0
2023-08-16 11:00:00	SPY	ETF	443.95	444.16	442.28	442.53	5274736.0
2023-08-16 12:00:00	SPY	ETF	442.52	442.83	441.71	441.765	5469085.0
2023-08-16 13:00:00	SPY	ETF	441.77	442.615	440.98	442.28	6479013.0
2023-08-16 14:00:00	SPY	ETF	442.29	443.09	440.87	441.82	8220812.0
2023-08-16 15:00:00	SPY	ETF	441.82	441.82	439.53	439.63	19026832.0
2023-08-16 16:00:00	SPY	ETF	439.63	440.0	439.0	439.66	3235352.0
2023-08-16 17:00:00	SPY	ETF	439.7	439.75	439.56	439.6	540765.0
2023-08-16 18:00:00	SPY	ETF	439.63	440.02	439.63	439.81	48991.0
2023-08-16 19:00:00	SPY	ETF	439.74	439.8	439.48	439.54	41133.0
2023-08-16 04:00:00	QQQ	ETF	367.35	367.89	366.87	367.56	33410.0
2023-08-16 05:00:00	QQQ	ETF	367.52	367.64	366.5	366.79	50531.0
2023-08-16 06:00:00	QQQ	ETF	366.83	367.06	366.56	366.7	52982.0
2023-08-16 07:00:00	QQQ	ETF	366.62	366.71	365.84	366.6	250628.0
2023-08-16 08:00:00	QQQ	ETF	365.9219	367.9304	365.5299	365.6	397135.0
2023-08-16 09:00:00	QQQ	ETF	365.59	367.03	365.2	366.41	4686951.0
2023-08-16 10:00:00	QQQ	ETF	366.38	367.43	365.65	367.01	4519054.0
2023-08-16 11:00:00	QQQ	ETF	367.02	367.34	364.77	365.02	3887327.0
2023-08-16 12:00:00	QQQ	ETF	365.02	365.3499	364.11	364.32	5306462.0
2023-08-16 13:00:00	QQQ	ETF	364.31	365.54	363.64	365.11	3659223.0
2023-08-16 14:00:00	QQQ	ETF	365.1	366.04	363.58	364.69	6076982.0
2023-08-16 15:00:00	QQQ	ETF	364.7	364.7	362.44	362.48	11156809.0
2023-08-16 16:00:00	QQQ	ETF	362.48	362.67	362.06	362.45	1151878.0
2023-08-16 17:00:00	QQQ	ETF	362.44	362.54	362.3	362.3617	487553.0
2023-08-16 18:00:00	QQQ	ETF	362.43	362.75	362.43	362.5	52488.0
2023-08-16 19:00:00	QQQ	ETF	362.45	362.53	362.18	362.22	30387.0
2023-08-16 04:00:00	IWM	ETF	188.49	189.04	188.49	188.94	8058.0
2023-08-16 05:00:00	IWM	ETF	188.88	188.88	188.32	188.34	2269.0
2023-08-16 06:00:00	IWM	ETF	188.43	188.43	188.23	188.38	4720.0
2023-08-16 07:00:00	IWM	ETF	188.24	188.5	188.15	188.5	86627.0
2023-08-16 08:00:00	IWM	ETF	188.4	188.75	187.91	187.96	224401.0
2023-08-16 09:00:00	IWM	ETF	187.99	189.06	187.81	188.4493	2718589.0
2023-08-16 10:00:00	IWM	ETF	188.46	188.46	187.52	188.07	3101000.0
2023-08-16 11:00:00	IWM	ETF	188.07	188.07	187.17	187.28	2158322.0
2023-08-16 12:00:00	IWM	ETF	187.28	187.49	186.88	187.08	1983623.0
2023-08-16 13:00:00	IWM	ETF	187.06	187.21	186.57	187.075	1625263.0
2023-08-16 14:00:00	IWM	ETF	187.075	187.26	186.43	186.66	2792958.0
2023-08-16 15:00:00	IWM	ETF	186.65	186.695	185.81	185.83	5169910.0
2023-08-16 16:00:00	IWM	ETF	185.84	186.0	185.69	185.69	1078304.0
2023-08-16 17:00:00	IWM	ETF	185.671	185.77	185.56	185.6	50575.0
2023-08-16 18:00:00	IWM	ETF	185.67	185.85	185.67	185.7	26154.0
2023-08-16 19:00:00	IWM	ETF	185.63	185.67	185.46	185.53	21434.0
2023-08-16 04:00:00	DIA	ETF	350.33	350.53	350.29	350.53	2313.0
2023-08-16 05:00:00	DIA	ETF	350.41	350.41	350.15	350.15	575.0

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

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