PREVIEW / etf_30min / 2023-11-28

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-28.parquet
  size:    757 KB
  rows:    29,732

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-28 04:00:00	SPY	ETF	454.12	454.36	453.92	454.3	9666.0
2023-11-28 04:30:00	SPY	ETF	454.34	454.52	454.34	454.52	6966.0
2023-11-28 05:00:00	SPY	ETF	454.52	454.56	454.41	454.41	2271.0
2023-11-28 05:30:00	SPY	ETF	454.38	454.55	454.35	454.35	2142.0
2023-11-28 06:00:00	SPY	ETF	454.59	454.59	454.39	454.45	3085.0
2023-11-28 06:30:00	SPY	ETF	454.35	454.35	454.15	454.18	16838.0
2023-11-28 07:00:00	SPY	ETF	454.2	454.33	454.13	454.13	24520.0
2023-11-28 07:30:00	SPY	ETF	454.2	454.24	453.7	453.72	111161.0
2023-11-28 08:00:00	SPY	ETF	454.3292	454.99	453.3	453.83	295081.0
2023-11-28 08:30:00	SPY	ETF	453.87	454.04	453.71	453.94	132885.0
2023-11-28 09:00:00	SPY	ETF	453.96	454.16	453.73	454.06	116219.0
2023-11-28 09:30:00	SPY	ETF	454.08	454.23	453.5	453.6131	3555401.0
2023-11-28 10:00:00	SPY	ETF	453.63	454.285	453.6	454.05	3037681.0
2023-11-28 10:30:00	SPY	ETF	454.05	455.44	453.925	455.17	4417886.0
2023-11-28 11:00:00	SPY	ETF	455.18	455.665	454.92	455.57	2980649.0
2023-11-28 11:30:00	SPY	ETF	455.57	456.27	455.53	456.02	3313956.0
2023-11-28 12:00:00	SPY	ETF	456.02	456.055	455.35	455.4	2237221.0
2023-11-28 12:30:00	SPY	ETF	455.41	455.41	454.6	454.9001	3068837.0
2023-11-28 13:00:00	SPY	ETF	454.91	454.92	453.77	454.55	4632217.0
2023-11-28 13:30:00	SPY	ETF	454.54	454.7967	454.31	454.39	1876749.0
2023-11-28 14:00:00	SPY	ETF	454.39	454.57	454.1503	454.25	1839305.0
2023-11-28 14:30:00	SPY	ETF	454.25	454.945	453.97	454.75	2122069.0
2023-11-28 15:00:00	SPY	ETF	454.76	454.805	453.99	454.39	2168916.0
2023-11-28 15:30:00	SPY	ETF	454.38	455.1	454.24	454.88	9334458.0
2023-11-28 16:00:00	SPY	ETF	454.88	455.09	454.87	455.05	2404720.0
2023-11-28 16:30:00	SPY	ETF	455.05	455.25	454.93	455.0	368449.0
2023-11-28 17:00:00	SPY	ETF	455.04	455.04	454.88	454.99	40219.0
2023-11-28 17:30:00	SPY	ETF	455.0	455.02	454.99	455.0	11430.0
2023-11-28 18:00:00	SPY	ETF	455.0	455.08	454.85	455.01	28743.0
2023-11-28 18:30:00	SPY	ETF	454.99	455.07	454.99	455.01	3072.0
2023-11-28 19:00:00	SPY	ETF	455.0	455.02	454.96	454.96	5887.0
2023-11-28 19:30:00	SPY	ETF	455.02	455.35	455.02	455.29	55118.0
2023-11-28 04:00:00	QQQ	ETF	388.32	388.62	388.25	388.62	15926.0
2023-11-28 04:30:00	QQQ	ETF	388.65	388.79	388.65	388.79	7553.0
2023-11-28 05:00:00	QQQ	ETF	388.78	388.9	388.68	388.7	3674.0
2023-11-28 05:30:00	QQQ	ETF	388.68	389.17	388.68	389.17	6333.0
2023-11-28 06:00:00	QQQ	ETF	389.15	389.24	389.02	389.22	6911.0
2023-11-28 06:30:00	QQQ	ETF	389.12	389.12	388.82	388.83	9083.0
2023-11-28 07:00:00	QQQ	ETF	388.8	389.04	388.7	388.77	25006.0
2023-11-28 07:30:00	QQQ	ETF	388.79	388.85	388.28	388.35	24766.0
2023-11-28 08:00:00	QQQ	ETF	388.8007	389.461	387.745	388.41	187433.0
2023-11-28 08:30:00	QQQ	ETF	388.4398	388.7	388.41	388.7	92936.0
2023-11-28 09:00:00	QQQ	ETF	388.68	388.84	388.25	388.41	267297.0
2023-11-28 09:30:00	QQQ	ETF	388.4	389.23	388.05	388.25	3636405.0
2023-11-28 10:00:00	QQQ	ETF	388.254	389.055	388.21	388.695	1900868.0
2023-11-28 10:30:00	QQQ	ETF	388.68	390.21	388.35	389.3497	3336878.0
2023-11-28 11:00:00	QQQ	ETF	389.35	390.16	389.07	390.03	1486127.0
2023-11-28 11:30:00	QQQ	ETF	390.03	390.78	389.99	390.3699	1538995.0
2023-11-28 12:00:00	QQQ	ETF	390.38	390.474	390.04	390.05	1125575.0
2023-11-28 12:30:00	QQQ	ETF	390.06	390.065	389.23	389.612	1190628.0

> showing 50 of 29,732 rows — these rows as CSV

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