PREVIEW / etf_30min / 2023-11-17

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-17.parquet
  size:    735 KB
  rows:    29,278

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-17 04:00:00	SPY	ETF	451.12	451.53	450.94	451.11	47018.0
2023-11-17 04:30:00	SPY	ETF	451.07	451.22	451.01	451.01	9148.0
2023-11-17 05:00:00	SPY	ETF	451.0	451.5	451.0	451.5	3524.0
2023-11-17 05:30:00	SPY	ETF	451.46	451.62	451.43	451.49	2692.0
2023-11-17 06:00:00	SPY	ETF	451.4	451.4	451.13	451.21	4587.0
2023-11-17 06:30:00	SPY	ETF	451.26	451.35	451.01	451.3	4819.0
2023-11-17 07:00:00	SPY	ETF	451.31	451.49	451.15	451.33	51706.0
2023-11-17 07:30:00	SPY	ETF	451.35	451.67	451.33	451.35	128765.0
2023-11-17 08:00:00	SPY	ETF	451.2614	451.92	450.45	451.88	170933.0
2023-11-17 08:30:00	SPY	ETF	451.799	451.94	451.05	451.18	230584.0
2023-11-17 09:00:00	SPY	ETF	451.17	451.37	449.99	450.24	313991.0
2023-11-17 09:30:00	SPY	ETF	450.24	450.6	449.46	450.15	5208029.0
2023-11-17 10:00:00	SPY	ETF	450.145	450.37	449.49	450.25	3525691.0
2023-11-17 10:30:00	SPY	ETF	450.25	450.28	449.71	450.09	2850986.0
2023-11-17 11:00:00	SPY	ETF	450.09	450.16	449.29	449.8	2504765.0
2023-11-17 11:30:00	SPY	ETF	449.8	450.24	449.5431	450.21	1884882.0
2023-11-17 12:00:00	SPY	ETF	450.215	450.69	450.01	450.125	2852469.0
2023-11-17 12:30:00	SPY	ETF	450.13	450.47	450.0819	450.45	1460170.0
2023-11-17 13:00:00	SPY	ETF	450.47	450.87	450.25	450.71	2004092.0
2023-11-17 13:30:00	SPY	ETF	450.71	451.1	450.71	451.04	2137666.0
2023-11-17 14:00:00	SPY	ETF	451.05	451.395	450.87	450.95	2377382.0
2023-11-17 14:30:00	SPY	ETF	450.95	451.11	450.64	450.945	2165214.0
2023-11-17 15:00:00	SPY	ETF	450.95	451.42	450.71	451.09	2913065.0
2023-11-17 15:30:00	SPY	ETF	451.09	451.13	450.2	450.78	8983658.0
2023-11-17 16:00:00	SPY	ETF	450.785	451.0	450.0	450.6	4428495.0
2023-11-17 16:30:00	SPY	ETF	450.59	450.79	450.39	450.4	309432.0
2023-11-17 17:00:00	SPY	ETF	450.45	450.65	450.45	450.61	34158.0
2023-11-17 17:30:00	SPY	ETF	450.59	450.68	450.38	450.38	18442.0
2023-11-17 18:00:00	SPY	ETF	450.41	450.41	450.23	450.23	31453.0
2023-11-17 18:30:00	SPY	ETF	450.25	450.4	450.2	450.25	22063.0
2023-11-17 19:00:00	SPY	ETF	450.25	450.4499	450.25	450.4	1296.0
2023-11-17 19:30:00	SPY	ETF	450.39	450.42	450.3	450.36	3888.0
2023-11-17 04:00:00	QQQ	ETF	385.84	386.55	385.84	386.08	35662.0
2023-11-17 04:30:00	QQQ	ETF	386.04	386.2	385.95	386.03	19577.0
2023-11-17 05:00:00	QQQ	ETF	386.0	386.37	385.96	386.34	36264.0
2023-11-17 05:30:00	QQQ	ETF	386.38	386.47	386.22	386.35	14616.0
2023-11-17 06:00:00	QQQ	ETF	386.21	386.29	385.94	386.1	25606.0
2023-11-17 06:30:00	QQQ	ETF	386.09	386.15	385.69	386.15	20940.0
2023-11-17 07:00:00	QQQ	ETF	386.15	386.3	385.95	386.2	49246.0
2023-11-17 07:30:00	QQQ	ETF	386.22	386.47	386.13	386.14	20526.0
2023-11-17 08:00:00	QQQ	ETF	386.1004	386.59	385.52	386.49	131602.0
2023-11-17 08:30:00	QQQ	ETF	386.51	386.51	385.71	385.86	154262.0
2023-11-17 09:00:00	QQQ	ETF	385.79	386.02	385.14	385.22	323101.0
2023-11-17 09:30:00	QQQ	ETF	385.21	385.63	384.45	385.47	4097995.0
2023-11-17 10:00:00	QQQ	ETF	385.48	385.531	384.34	385.385	2631428.0
2023-11-17 10:30:00	QQQ	ETF	385.38	385.44	384.56	385.21	1488905.0
2023-11-17 11:00:00	QQQ	ETF	385.21	385.32	384.29	385.1	1480606.0
2023-11-17 11:30:00	QQQ	ETF	385.11	385.63	384.91	385.625	1341218.0
2023-11-17 12:00:00	QQQ	ETF	385.62	386.045	385.245	385.34	1725843.0
2023-11-17 12:30:00	QQQ	ETF	385.36	385.93	385.27	385.93	1137150.0

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

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