PREVIEW / etf_30min / 2023-02-09

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-09.parquet
  size:    703 KB
  rows:    27,822

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-02-09 04:00:00	SPY	ETF	413.59	413.94	413.02	413.7	35550.0
2023-02-09 04:30:00	SPY	ETF	413.79	414.65	413.7	414.65	31767.0
2023-02-09 05:00:00	SPY	ETF	414.71	414.71	414.22	414.3	14404.0
2023-02-09 05:30:00	SPY	ETF	414.22	414.92	414.21	414.91	28345.0
2023-02-09 06:00:00	SPY	ETF	414.91	414.91	414.01	414.04	60995.0
2023-02-09 06:30:00	SPY	ETF	414.09	414.18	413.8	414.08	126356.0
2023-02-09 07:00:00	SPY	ETF	414.09	414.09	413.76	413.85	54871.0
2023-02-09 07:30:00	SPY	ETF	413.9	414.05	413.49	413.53	194186.0
2023-02-09 08:00:00	SPY	ETF	414.04	414.6896	411.86	413.76	139074.0
2023-02-09 08:30:00	SPY	ETF	413.85	414.5	413.72	414.41	287383.0
2023-02-09 09:00:00	SPY	ETF	414.45	414.49	414.0	414.42	341207.0
2023-02-09 09:30:00	SPY	ETF	414.41	414.57	412.96	413.35	5321137.0
2023-02-09 10:00:00	SPY	ETF	413.37	414.03	412.1	412.3	3861112.0
2023-02-09 10:30:00	SPY	ETF	412.28	413.25	412.09	413.01	3129951.0
2023-02-09 11:00:00	SPY	ETF	413.02	413.02	411.09	411.52	3728963.0
2023-02-09 11:30:00	SPY	ETF	411.54	411.73	410.925	411.4099	2411209.0
2023-02-09 12:00:00	SPY	ETF	411.41	412.13	411.32	411.33	2482671.0
2023-02-09 12:30:00	SPY	ETF	411.3399	411.39	409.28	410.131	4392069.0
2023-02-09 13:00:00	SPY	ETF	410.131	410.24	409.405	409.8	3152873.0
2023-02-09 13:30:00	SPY	ETF	409.78	410.5	409.03	409.3399	3007428.0
2023-02-09 14:00:00	SPY	ETF	409.34	409.615	408.245	408.31	4061109.0
2023-02-09 14:30:00	SPY	ETF	408.315	408.89	408.165	408.44	3680859.0
2023-02-09 15:00:00	SPY	ETF	408.45	408.47	406.58	406.7899	5648056.0
2023-02-09 15:30:00	SPY	ETF	406.78	408.2021	405.81	407.13	13348644.0
2023-02-09 16:00:00	SPY	ETF	407.14	407.67	406.98	407.53	2858279.0
2023-02-09 16:30:00	SPY	ETF	407.5	407.71	407.09	407.68	289752.0
2023-02-09 17:00:00	SPY	ETF	407.69	407.74	407.57	407.71	34231.0
2023-02-09 17:30:00	SPY	ETF	407.71	407.77	407.6	407.71	35874.0
2023-02-09 18:00:00	SPY	ETF	407.65	407.66	407.39	407.61	37707.0
2023-02-09 18:30:00	SPY	ETF	407.54	407.54	407.24	407.4	59554.0
2023-02-09 19:00:00	SPY	ETF	407.27	407.35	406.75	406.75	92355.0
2023-02-09 19:30:00	SPY	ETF	406.74	407.1	406.74	407.04	67927.0
2023-02-09 04:00:00	QQQ	ETF	307.26	307.49	307.15	307.49	56300.0
2023-02-09 04:30:00	QQQ	ETF	307.44	308.35	307.41	308.35	54662.0
2023-02-09 05:00:00	QQQ	ETF	308.36	308.36	307.89	308.04	37804.0
2023-02-09 05:30:00	QQQ	ETF	308.05	308.78	307.99	308.78	33842.0
2023-02-09 06:00:00	QQQ	ETF	308.75	308.79	307.99	308.02	58160.0
2023-02-09 06:30:00	QQQ	ETF	308.05	308.14	307.66	308.05	88454.0
2023-02-09 07:00:00	QQQ	ETF	308.06	308.07	307.62	307.86	161802.0
2023-02-09 07:30:00	QQQ	ETF	307.8	308.03	307.35	307.35	185767.0
2023-02-09 08:00:00	QQQ	ETF	307.99	308.51	304.598	307.77	162064.0
2023-02-09 08:30:00	QQQ	ETF	307.81	308.69	307.81	308.6	443327.0
2023-02-09 09:00:00	QQQ	ETF	308.61	308.91	308.29	308.869	402386.0
2023-02-09 09:30:00	QQQ	ETF	308.84	308.99	306.68	307.63	5111089.0
2023-02-09 10:00:00	QQQ	ETF	307.64	308.45	306.32	306.36	3220151.0
2023-02-09 10:30:00	QQQ	ETF	306.36	307.39	306.17	307.16	2290962.0
2023-02-09 11:00:00	QQQ	ETF	307.16	307.17	305.06	305.38	2517180.0
2023-02-09 11:30:00	QQQ	ETF	305.41	305.7699	304.86	305.45	2199500.0
2023-02-09 12:00:00	QQQ	ETF	305.42	306.27	305.32	305.4363	1533599.0
2023-02-09 12:30:00	QQQ	ETF	305.44	305.51	303.46	304.485	2584696.0

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

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