PREVIEW / etf_30min / 2023-04-18

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-18.parquet
  size:    686 KB
  rows:    27,333

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-04-18 04:00:00	SPY	ETF	414.2	414.6	414.2	414.37	18126.0
2023-04-18 04:30:00	SPY	ETF	414.57	415.0	414.53	414.83	8568.0
2023-04-18 05:00:00	SPY	ETF	414.73	415.26	414.73	415.1	16401.0
2023-04-18 05:30:00	SPY	ETF	415.11	415.57	415.11	415.37	14085.0
2023-04-18 06:00:00	SPY	ETF	415.33	415.43	415.25	415.39	7174.0
2023-04-18 06:30:00	SPY	ETF	415.5	415.85	415.5	415.75	44277.0
2023-04-18 07:00:00	SPY	ETF	415.77	415.78	415.22	415.46	169949.0
2023-04-18 07:30:00	SPY	ETF	415.51	415.81	415.42	415.52	107153.0
2023-04-18 08:00:00	SPY	ETF	415.72	415.91	413.68	415.8	107400.0
2023-04-18 08:30:00	SPY	ETF	415.81	416.06	415.76	415.8	126731.0
2023-04-18 09:00:00	SPY	ETF	415.79	415.81	415.45	415.6	125680.0
2023-04-18 09:30:00	SPY	ETF	415.58	415.72	414.49	414.675	5603567.0
2023-04-18 10:00:00	SPY	ETF	414.68	414.705	413.35	413.51	4774725.0
2023-04-18 10:30:00	SPY	ETF	413.51	413.84	412.93	413.315	4027929.0
2023-04-18 11:00:00	SPY	ETF	413.31	413.66	412.99	413.4901	2744410.0
2023-04-18 11:30:00	SPY	ETF	413.51	413.835	412.7802	413.22	2548438.0
2023-04-18 12:00:00	SPY	ETF	413.24	414.19	413.11	414.17	2168666.0
2023-04-18 12:30:00	SPY	ETF	414.17	414.25	413.57	413.79	2111156.0
2023-04-18 13:00:00	SPY	ETF	413.7915	414.2399	413.6595	413.67	2104297.0
2023-04-18 13:30:00	SPY	ETF	413.66	414.46	413.56	413.9512	2828741.0
2023-04-18 14:00:00	SPY	ETF	413.955	414.47	413.62	414.2801	2982329.0
2023-04-18 14:30:00	SPY	ETF	414.28	414.49	413.08	413.8313	3464893.0
2023-04-18 15:00:00	SPY	ETF	413.8301	414.42	413.82	414.0699	3409373.0
2023-04-18 15:30:00	SPY	ETF	414.07	414.595	413.916	414.22	8427300.0
2023-04-18 16:00:00	SPY	ETF	414.215	415.0	413.8	414.21	2350539.0
2023-04-18 16:30:00	SPY	ETF	414.21	414.36	414.14	414.14	149870.0
2023-04-18 17:00:00	SPY	ETF	414.2	414.29	414.1	414.18	27918.0
2023-04-18 17:30:00	SPY	ETF	414.17	414.21	414.12	414.12	10110.0
2023-04-18 18:00:00	SPY	ETF	414.12	414.1299	414.0	414.04	33708.0
2023-04-18 18:30:00	SPY	ETF	414.04	414.1	413.95	414.1	16263.0
2023-04-18 19:00:00	SPY	ETF	414.13	414.13	413.95	413.95	13057.0
2023-04-18 19:30:00	SPY	ETF	413.95	413.97	413.88	413.9	19791.0
2023-04-18 04:00:00	QQQ	ETF	318.93	319.85	318.93	319.61	16747.0
2023-04-18 04:30:00	QQQ	ETF	319.75	320.25	319.75	320.15	14293.0
2023-04-18 05:00:00	QQQ	ETF	320.13	320.77	320.0	320.62	13174.0
2023-04-18 05:30:00	QQQ	ETF	320.56	321.07	320.56	320.85	25969.0
2023-04-18 06:00:00	QQQ	ETF	320.85	320.9	320.66	320.71	19372.0
2023-04-18 06:30:00	QQQ	ETF	320.82	320.95	320.65	320.65	32283.0
2023-04-18 07:00:00	QQQ	ETF	320.66	320.95	320.45	320.8	44419.0
2023-04-18 07:30:00	QQQ	ETF	320.82	321.32	320.8	321.0	75058.0
2023-04-18 08:00:00	QQQ	ETF	320.6806	321.2695	318.84	321.09	148749.0
2023-04-18 08:30:00	QQQ	ETF	321.09	321.46	321.09	321.22	247960.0
2023-04-18 09:00:00	QQQ	ETF	321.2	321.2	320.8	321.0	314194.0
2023-04-18 09:30:00	QQQ	ETF	320.99	321.42	320.08	320.31	4461434.0
2023-04-18 10:00:00	QQQ	ETF	320.32	320.36	318.3	318.55	4199175.0
2023-04-18 10:30:00	QQQ	ETF	318.5401	318.9899	318.06	318.57	2911393.0
2023-04-18 11:00:00	QQQ	ETF	318.57	319.04	318.4	318.79	2097853.0
2023-04-18 11:30:00	QQQ	ETF	318.8	319.0414	317.96	318.32	2055248.0
2023-04-18 12:00:00	QQQ	ETF	318.33	319.1	318.2	319.075	1333811.0
2023-04-18 12:30:00	QQQ	ETF	319.08	319.18	318.32	318.55	1819655.0

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

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