PREVIEW / etf_30min / 2023-07-24

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-24.parquet
  size:    718 KB
  rows:    28,383

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-24 04:00:00	SPY	ETF	453.02	453.13	452.78	453.13	21972.0
2023-07-24 04:30:00	SPY	ETF	453.13	453.26	452.99	453.12	10573.0
2023-07-24 05:00:00	SPY	ETF	453.11	453.5	453.08	453.39	9850.0
2023-07-24 05:30:00	SPY	ETF	453.4	453.4	453.29	453.33	4283.0
2023-07-24 06:00:00	SPY	ETF	453.28	453.28	453.18	453.27	3359.0
2023-07-24 06:30:00	SPY	ETF	453.27	453.37	453.11	453.11	6478.0
2023-07-24 07:00:00	SPY	ETF	453.11	453.4	452.89	453.25	29895.0
2023-07-24 07:30:00	SPY	ETF	453.29	453.34	452.99	453.06	42213.0
2023-07-24 08:00:00	SPY	ETF	452.97	453.4004	452.33	452.89	77549.0
2023-07-24 08:30:00	SPY	ETF	452.94	453.2	452.92	453.2	43634.0
2023-07-24 09:00:00	SPY	ETF	453.22	453.39	453.05	453.37	86065.0
2023-07-24 09:30:00	SPY	ETF	453.37	454.45	452.75	453.2	5686807.0
2023-07-24 10:00:00	SPY	ETF	453.195	454.265	452.91	454.12	4241407.0
2023-07-24 10:30:00	SPY	ETF	454.13	454.3699	453.74	454.245	2706799.0
2023-07-24 11:00:00	SPY	ETF	454.25	454.58	453.76	454.28	2348395.0
2023-07-24 11:30:00	SPY	ETF	454.28	454.51	453.75	454.49	1839143.0
2023-07-24 12:00:00	SPY	ETF	454.48	454.705	454.14	454.5023	1484375.0
2023-07-24 12:30:00	SPY	ETF	454.51	454.635	453.995	454.3	1246267.0
2023-07-24 13:00:00	SPY	ETF	454.3	454.4799	454.03	454.46	1350053.0
2023-07-24 13:30:00	SPY	ETF	454.465	454.82	454.22	454.77	1845925.0
2023-07-24 14:00:00	SPY	ETF	454.77	455.04	454.585	454.6035	1887101.0
2023-07-24 14:30:00	SPY	ETF	454.61	454.61	453.82	454.29	2493265.0
2023-07-24 15:00:00	SPY	ETF	454.28	454.4377	453.43	453.49	2562883.0
2023-07-24 15:30:00	SPY	ETF	453.49	454.24	453.45	454.2	6798840.0
2023-07-24 16:00:00	SPY	ETF	454.2	454.55	453.87	454.38	3306040.0
2023-07-24 16:30:00	SPY	ETF	454.36	454.49	454.34	454.37	182674.0
2023-07-24 17:00:00	SPY	ETF	454.42	454.46	454.39	454.46	7681.0
2023-07-24 17:30:00	SPY	ETF	454.45	454.47	454.4	454.4	12596.0
2023-07-24 18:00:00	SPY	ETF	454.4	454.4	454.17	454.2304	24590.0
2023-07-24 18:30:00	SPY	ETF	454.3	454.3	454.2	454.26	2989.0
2023-07-24 19:00:00	SPY	ETF	454.28	454.39	454.23	454.35	10692.0
2023-07-24 19:30:00	SPY	ETF	454.3998	454.4	454.27	454.28	15575.0
2023-07-24 04:00:00	QQQ	ETF	376.35	376.9	376.31	376.77	29039.0
2023-07-24 04:30:00	QQQ	ETF	376.9	376.97	376.45	376.45	11534.0
2023-07-24 05:00:00	QQQ	ETF	376.54	376.96	376.54	376.9	13892.0
2023-07-24 05:30:00	QQQ	ETF	376.91	376.97	376.7	376.76	5000.0
2023-07-24 06:00:00	QQQ	ETF	376.68	376.75	376.57	376.68	15926.0
2023-07-24 06:30:00	QQQ	ETF	376.75	376.84	376.52	376.52	20204.0
2023-07-24 07:00:00	QQQ	ETF	376.52	376.87	376.29	376.75	37412.0
2023-07-24 07:30:00	QQQ	ETF	376.8	376.85	376.6	376.7	19051.0
2023-07-24 08:00:00	QQQ	ETF	376.68	376.89	375.69	376.47	102568.0
2023-07-24 08:30:00	QQQ	ETF	376.56	376.65	376.3	376.51	75254.0
2023-07-24 09:00:00	QQQ	ETF	376.52	376.79	376.33	376.64	134252.0
2023-07-24 09:30:00	QQQ	ETF	376.62	377.58	374.34	374.88	5495791.0
2023-07-24 10:00:00	QQQ	ETF	374.86	376.9	374.67	376.67	3648961.0
2023-07-24 10:30:00	QQQ	ETF	376.68	376.96	375.77	376.24	2232665.0
2023-07-24 11:00:00	QQQ	ETF	376.24	376.97	375.57	376.0303	2214491.0
2023-07-24 11:30:00	QQQ	ETF	376.045	376.24	375.17	376.21	1969827.0
2023-07-24 12:00:00	QQQ	ETF	376.21	376.67	375.59	376.105	1664800.0
2023-07-24 12:30:00	QQQ	ETF	376.131	376.41	375.515	375.9001	1136650.0

> showing 50 of 28,383 rows — these rows as CSV

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