PREVIEW / etf_30min / 2023-04-19

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-19.parquet
  size:    691 KB
  rows:    27,213

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-19 04:00:00	SPY	ETF	413.09	413.09	412.32	412.67	23691.0
2023-04-19 04:30:00	SPY	ETF	412.66	412.74	412.57	412.64	10441.0
2023-04-19 05:00:00	SPY	ETF	412.48	412.48	411.98	412.26	27483.0
2023-04-19 05:30:00	SPY	ETF	412.17	412.25	411.69	411.74	24530.0
2023-04-19 06:00:00	SPY	ETF	411.84	412.05	411.77	412.0	11315.0
2023-04-19 06:30:00	SPY	ETF	412.11	412.29	411.88	412.29	40953.0
2023-04-19 07:00:00	SPY	ETF	412.3	412.34	412.05	412.28	64592.0
2023-04-19 07:30:00	SPY	ETF	412.28	412.55	412.0	412.14	111251.0
2023-04-19 08:00:00	SPY	ETF	412.33	413.85	411.7	412.04	335060.0
2023-04-19 08:30:00	SPY	ETF	412.04	412.04	411.46	411.72	199399.0
2023-04-19 09:00:00	SPY	ETF	411.72	412.26	411.72	412.21	317567.0
2023-04-19 09:30:00	SPY	ETF	412.22	412.74	412.16	412.3	5444743.0
2023-04-19 10:00:00	SPY	ETF	412.31	413.07	412.26	412.9812	4022123.0
2023-04-19 10:30:00	SPY	ETF	412.99	413.585	412.87	413.32	3653299.0
2023-04-19 11:00:00	SPY	ETF	413.34	413.615	413.07	413.295	3159928.0
2023-04-19 11:30:00	SPY	ETF	413.29	413.79	412.97	413.72	2024723.0
2023-04-19 12:00:00	SPY	ETF	413.73	413.99	413.53	413.9	1988927.0
2023-04-19 12:30:00	SPY	ETF	413.905	414.21	413.87	414.0309	2023668.0
2023-04-19 13:00:00	SPY	ETF	414.04	414.4403	413.84	414.27	2773396.0
2023-04-19 13:30:00	SPY	ETF	414.28	414.58	414.01	414.5394	2178649.0
2023-04-19 14:00:00	SPY	ETF	414.54	415.08	414.24	414.55	2805243.0
2023-04-19 14:30:00	SPY	ETF	414.56	414.64	414.18	414.53	2164221.0
2023-04-19 15:00:00	SPY	ETF	414.53	414.775	414.27	414.505	2912983.0
2023-04-19 15:30:00	SPY	ETF	414.5	414.635	413.63	414.21	6845073.0
2023-04-19 16:00:00	SPY	ETF	414.2	414.22	413.6	413.84	2478140.0
2023-04-19 16:30:00	SPY	ETF	413.84	413.88	413.65	413.7	207301.0
2023-04-19 17:00:00	SPY	ETF	413.6	413.9	413.56	413.74	33593.0
2023-04-19 17:30:00	SPY	ETF	413.64	413.75	413.63	413.63	11841.0
2023-04-19 18:00:00	SPY	ETF	413.63	413.65	413.2	413.3	365661.0
2023-04-19 18:30:00	SPY	ETF	413.29	413.29	413.13	413.25	100175.0
2023-04-19 19:00:00	SPY	ETF	413.24	413.27	413.08	413.2	17421.0
2023-04-19 19:30:00	SPY	ETF	413.11	413.15	412.85	412.94	43678.0
2023-04-19 04:00:00	QQQ	ETF	317.43	317.9	316.78	317.23	33093.0
2023-04-19 04:30:00	QQQ	ETF	317.2	317.29	317.01	317.01	11052.0
2023-04-19 05:00:00	QQQ	ETF	317.1	317.1	316.36	316.49	60411.0
2023-04-19 05:30:00	QQQ	ETF	316.5	316.5	315.92	316.07	42991.0
2023-04-19 06:00:00	QQQ	ETF	316.17	316.41	316.12	316.35	16224.0
2023-04-19 06:30:00	QQQ	ETF	316.41	316.66	316.24	316.59	46378.0
2023-04-19 07:00:00	QQQ	ETF	316.63	316.69	316.35	316.65	78745.0
2023-04-19 07:30:00	QQQ	ETF	316.63	316.88	316.43	316.56	172157.0
2023-04-19 08:00:00	QQQ	ETF	316.6284	319.099	316.27	316.57	213843.0
2023-04-19 08:30:00	QQQ	ETF	316.54	316.56	316.02	316.28	143111.0
2023-04-19 09:00:00	QQQ	ETF	316.31	316.54	316.18	316.42	311056.0
2023-04-19 09:30:00	QQQ	ETF	316.41	317.545	316.28	316.63	4357009.0
2023-04-19 10:00:00	QQQ	ETF	316.63	317.4	316.54	317.17	2942372.0
2023-04-19 10:30:00	QQQ	ETF	317.18	317.93	317.04	317.68	2495791.0
2023-04-19 11:00:00	QQQ	ETF	317.7	318.29	317.66	317.9	2381575.0
2023-04-19 11:30:00	QQQ	ETF	317.8908	318.625	317.66	318.52	1865825.0
2023-04-19 12:00:00	QQQ	ETF	318.52	319.07	318.29	318.95	1972657.0
2023-04-19 12:30:00	QQQ	ETF	318.95	319.31	318.905	318.93	1809915.0

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

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