PREVIEW / etf_30min / 2023-05-05

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-05.parquet
  size:    675 KB
  rows:    27,048

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-05-05 04:00:00	SPY	ETF	406.48	406.67	406.25	406.49	20579.0
2023-05-05 04:30:00	SPY	ETF	406.46	407.11	406.4	407.05	8217.0
2023-05-05 05:00:00	SPY	ETF	407.02	407.02	406.76	406.97	9770.0
2023-05-05 05:30:00	SPY	ETF	406.96	407.26	406.92	407.15	21499.0
2023-05-05 06:00:00	SPY	ETF	407.22	407.5	407.22	407.45	33141.0
2023-05-05 06:30:00	SPY	ETF	407.49	407.75	407.37	407.5	29240.0
2023-05-05 07:00:00	SPY	ETF	407.55	408.12	407.47	408.12	82250.0
2023-05-05 07:30:00	SPY	ETF	408.111	408.22	407.65	407.98	106637.0
2023-05-05 08:00:00	SPY	ETF	407.58	408.24	406.54	407.9001	392231.0
2023-05-05 08:30:00	SPY	ETF	407.9	408.76	406.88	407.95	1130281.0
2023-05-05 09:00:00	SPY	ETF	407.97	408.95	407.97	408.92	356617.0
2023-05-05 09:30:00	SPY	ETF	408.91	410.34	408.64	410.115	8140216.0
2023-05-05 10:00:00	SPY	ETF	410.12	411.1199	410.05	410.79	6146037.0
2023-05-05 10:30:00	SPY	ETF	410.8	411.64	410.8	411.06	4303746.0
2023-05-05 11:00:00	SPY	ETF	411.07	411.47	410.66	411.3	3352079.0
2023-05-05 11:30:00	SPY	ETF	411.32	411.34	410.715	411.01	2355373.0
2023-05-05 12:00:00	SPY	ETF	411.02	411.11	410.55	410.7893	2324367.0
2023-05-05 12:30:00	SPY	ETF	410.79	411.11	410.2	411.089	2213516.0
2023-05-05 13:00:00	SPY	ETF	411.09	411.53	411.08	411.48	2055416.0
2023-05-05 13:30:00	SPY	ETF	411.485	411.97	411.47	411.8599	2326060.0
2023-05-05 14:00:00	SPY	ETF	411.86	412.6581	411.8	412.48	3028100.0
2023-05-05 14:30:00	SPY	ETF	412.48	413.72	412.48	413.256	4392676.0
2023-05-05 15:00:00	SPY	ETF	413.26	413.51	412.71	413.09	3995262.0
2023-05-05 15:30:00	SPY	ETF	413.1	413.21	412.17	412.61	14082492.0
2023-05-05 16:00:00	SPY	ETF	412.61	412.71	412.17	412.44	5260473.0
2023-05-05 16:30:00	SPY	ETF	412.44	412.47	412.15	412.36	222442.0
2023-05-05 17:00:00	SPY	ETF	412.35	412.35	412.1	412.11	30049.0
2023-05-05 17:30:00	SPY	ETF	412.11	412.45	412.11	412.45	19024.0
2023-05-05 18:00:00	SPY	ETF	412.36	412.4	412.1301	412.15	16403.0
2023-05-05 18:30:00	SPY	ETF	412.15	412.15	412.08	412.08	19757.0
2023-05-05 19:00:00	SPY	ETF	412.1	412.25	412.1	412.25	2362.0
2023-05-05 19:30:00	SPY	ETF	412.25	412.27	412.19	412.2	4276.0
2023-05-05 04:00:00	QQQ	ETF	317.46	317.59	317.25	317.44	12374.0
2023-05-05 04:30:00	QQQ	ETF	317.46	317.8	317.42	317.66	26808.0
2023-05-05 05:00:00	QQQ	ETF	317.72	317.91	317.61	317.91	10605.0
2023-05-05 05:30:00	QQQ	ETF	317.78	318.1	317.78	317.98	27140.0
2023-05-05 06:00:00	QQQ	ETF	318.14	318.16	318.0	318.14	6659.0
2023-05-05 06:30:00	QQQ	ETF	318.08	318.34	317.98	318.08	38503.0
2023-05-05 07:00:00	QQQ	ETF	318.06	318.47	318.03	318.46	39993.0
2023-05-05 07:30:00	QQQ	ETF	318.47	318.47	318.09	318.35	75687.0
2023-05-05 08:00:00	QQQ	ETF	318.1699	318.75	316.92	318.35	251557.0
2023-05-05 08:30:00	QQQ	ETF	318.2	318.57	317.19	317.85	1032103.0
2023-05-05 09:00:00	QQQ	ETF	317.87	318.48	317.8	318.44	455179.0
2023-05-05 09:30:00	QQQ	ETF	318.46	319.76	318.1	319.71	5823275.0
2023-05-05 10:00:00	QQQ	ETF	319.71	320.92	319.71	320.74	4256471.0
2023-05-05 10:30:00	QQQ	ETF	320.75	321.78	320.69	321.33	3081374.0
2023-05-05 11:00:00	QQQ	ETF	321.34	321.69	320.92	321.66	2181164.0
2023-05-05 11:30:00	QQQ	ETF	321.68	321.69	321.09	321.3017	1384192.0
2023-05-05 12:00:00	QQQ	ETF	321.32	321.45	320.89	321.105	1721262.0
2023-05-05 12:30:00	QQQ	ETF	321.12	321.645	320.87	321.6	1597492.0

> showing 50 of 27,048 rows — these rows as CSV

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