PREVIEW / etf_30min / 2023-04-03

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-03.parquet
  size:    712 KB
  rows:    28,451

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-03 04:00:00	SPY	ETF	409.0	409.32	408.42	408.42	60682.0
2023-04-03 04:30:00	SPY	ETF	408.45	408.8	408.36	408.67	18224.0
2023-04-03 05:00:00	SPY	ETF	408.72	409.0	408.72	408.79	8033.0
2023-04-03 05:30:00	SPY	ETF	408.92	408.97	408.77	408.84	11559.0
2023-04-03 06:00:00	SPY	ETF	408.98	409.3	408.95	409.16	25803.0
2023-04-03 06:30:00	SPY	ETF	409.18	409.35	409.1	409.24	43415.0
2023-04-03 07:00:00	SPY	ETF	409.24	409.36	408.92	409.22	109341.0
2023-04-03 07:30:00	SPY	ETF	409.22	409.22	408.76	409.01	85088.0
2023-04-03 08:00:00	SPY	ETF	409.05	409.3296	408.1	408.7	193832.0
2023-04-03 08:30:00	SPY	ETF	408.7699	409.07	408.4799	409.0	131993.0
2023-04-03 09:00:00	SPY	ETF	409.0	409.08	408.78	408.86	171724.0
2023-04-03 09:30:00	SPY	ETF	408.86	410.7	408.82	410.11	6310633.0
2023-04-03 10:00:00	SPY	ETF	410.15	411.31	410.04	411.19	4904890.0
2023-04-03 10:30:00	SPY	ETF	411.2	411.37	408.96	408.995	4687029.0
2023-04-03 11:00:00	SPY	ETF	409.0	409.27	408.44	409.04	4321340.0
2023-04-03 11:30:00	SPY	ETF	409.06	409.5	408.97	409.49	2620425.0
2023-04-03 12:00:00	SPY	ETF	409.49	409.89	409.38	409.6401	2759635.0
2023-04-03 12:30:00	SPY	ETF	409.645	409.78	409.22	409.28	1661169.0
2023-04-03 13:00:00	SPY	ETF	409.285	409.77	408.95	409.21	2606992.0
2023-04-03 13:30:00	SPY	ETF	409.22	409.6	408.9	409.2214	2349632.0
2023-04-03 14:00:00	SPY	ETF	409.23	409.68	409.1	409.61	2722287.0
2023-04-03 14:30:00	SPY	ETF	409.61	410.46	409.57	410.375	2825698.0
2023-04-03 15:00:00	SPY	ETF	410.38	411.0	410.306	410.835	3316343.0
2023-04-03 15:30:00	SPY	ETF	410.835	411.19	410.5	410.93	8296753.0
2023-04-03 16:00:00	SPY	ETF	410.92	411.09	410.79	411.04	2623095.0
2023-04-03 16:30:00	SPY	ETF	411.04	411.05	410.85	410.9	262677.0
2023-04-03 17:00:00	SPY	ETF	410.9	410.95	410.85	410.85	303011.0
2023-04-03 17:30:00	SPY	ETF	410.84	410.88	410.67	410.75	49357.0
2023-04-03 18:00:00	SPY	ETF	410.75	410.76	410.4	410.47	169671.0
2023-04-03 18:30:00	SPY	ETF	410.49	410.54	410.43	410.47	15159.0
2023-04-03 19:00:00	SPY	ETF	410.46	410.671	410.46	410.6	25203.0
2023-04-03 19:30:00	SPY	ETF	410.55	410.7	410.51	410.58	68189.0
2023-04-03 04:00:00	QQQ	ETF	319.92	319.92	318.63	318.65	76044.0
2023-04-03 04:30:00	QQQ	ETF	318.7	318.9	318.6	318.77	23802.0
2023-04-03 05:00:00	QQQ	ETF	318.81	319.03	318.72	318.98	22051.0
2023-04-03 05:30:00	QQQ	ETF	319.02	319.05	318.8	318.92	17345.0
2023-04-03 06:00:00	QQQ	ETF	318.96	319.27	318.96	319.15	95690.0
2023-04-03 06:30:00	QQQ	ETF	319.14	319.19	319.0	319.02	76709.0
2023-04-03 07:00:00	QQQ	ETF	319.05	319.23	318.83	319.07	167091.0
2023-04-03 07:30:00	QQQ	ETF	319.07	319.07	318.62	318.81	176363.0
2023-04-03 08:00:00	QQQ	ETF	318.99	321.17	318.14	318.39	331754.0
2023-04-03 08:30:00	QQQ	ETF	318.38	318.9	318.08	318.84	262239.0
2023-04-03 09:00:00	QQQ	ETF	318.83	319.15	318.65	318.77	339248.0
2023-04-03 09:30:00	QQQ	ETF	318.77	320.01	318.49	319.15	5461869.0
2023-04-03 10:00:00	QQQ	ETF	319.16	320.17	318.9	319.99	3997123.0
2023-04-03 10:30:00	QQQ	ETF	320.0	320.14	318.0	318.025	3103360.0
2023-04-03 11:00:00	QQQ	ETF	318.04	318.35	317.4201	318.17	2477859.0
2023-04-03 11:30:00	QQQ	ETF	318.17	318.415	317.68	318.22	1769367.0
2023-04-03 12:00:00	QQQ	ETF	318.23	318.765	318.06	318.3	1658484.0
2023-04-03 12:30:00	QQQ	ETF	318.29	318.49	317.85	317.88	1135853.0

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

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