PREVIEW / etf_30min / 2023-09-21

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-21.parquet
  size:    725 KB
  rows:    29,138

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-09-21 04:00:00	SPY	ETF	437.73	437.85	437.18	437.5	23820.0
2023-09-21 04:30:00	SPY	ETF	437.46	437.46	436.81	437.03	38966.0
2023-09-21 05:00:00	SPY	ETF	437.01	437.23	436.82	436.94	12347.0
2023-09-21 05:30:00	SPY	ETF	436.96	437.06	436.44	436.48	26980.0
2023-09-21 06:00:00	SPY	ETF	436.53	436.53	436.0	436.05	60862.0
2023-09-21 06:30:00	SPY	ETF	436.06	436.23	435.86	436.13	47101.0
2023-09-21 07:00:00	SPY	ETF	436.09	436.3	435.25	435.34	228046.0
2023-09-21 07:30:00	SPY	ETF	435.3	435.68	435.18	435.31	141772.0
2023-09-21 08:00:00	SPY	ETF	436.1481	437.79	435.0	435.24	542959.0
2023-09-21 08:30:00	SPY	ETF	435.13	435.22	434.5	435.16	408359.0
2023-09-21 09:00:00	SPY	ETF	435.22	435.72	435.12	435.69	505915.0
2023-09-21 09:30:00	SPY	ETF	435.7	435.97	434.11	434.15	8191833.0
2023-09-21 10:00:00	SPY	ETF	434.145	435.57	434.01	434.6885	7741647.0
2023-09-21 10:30:00	SPY	ETF	434.69	435.44	434.01	434.105	4637434.0
2023-09-21 11:00:00	SPY	ETF	434.12	434.57	433.65	433.8	4068663.0
2023-09-21 11:30:00	SPY	ETF	433.8	434.52	433.72	433.92	3236576.0
2023-09-21 12:00:00	SPY	ETF	433.92	433.96	433.43	433.7526	3108669.0
2023-09-21 12:30:00	SPY	ETF	433.78	434.17	433.54	433.577	2889147.0
2023-09-21 13:00:00	SPY	ETF	433.58	434.815	433.49	434.595	3609331.0
2023-09-21 13:30:00	SPY	ETF	434.6	434.9	434.28	434.42	2701807.0
2023-09-21 14:00:00	SPY	ETF	434.43	434.49	433.32	433.33	3565933.0
2023-09-21 14:30:00	SPY	ETF	433.33	433.77	433.07	433.08	4558569.0
2023-09-21 15:00:00	SPY	ETF	433.08	433.39	432.01	432.11	6565435.0
2023-09-21 15:30:00	SPY	ETF	432.11	432.4	431.23	431.41	17980612.0
2023-09-21 16:00:00	SPY	ETF	431.42	434.2004	430.85	430.86	4821606.0
2023-09-21 16:30:00	SPY	ETF	430.88	431.377	430.81	431.01	433790.0
2023-09-21 17:00:00	SPY	ETF	430.96	431.07	430.88	431.05	81757.0
2023-09-21 17:30:00	SPY	ETF	431.02	431.09	430.92	431.09	23158.0
2023-09-21 18:00:00	SPY	ETF	431.09	431.58	431.09	431.52	152116.0
2023-09-21 18:30:00	SPY	ETF	431.57	431.57	431.41	431.44	12465.0
2023-09-21 19:00:00	SPY	ETF	431.43	431.48	431.24	431.27	22963.0
2023-09-21 19:30:00	SPY	ETF	431.27	431.39	431.05	431.12	28353.0
2023-09-21 04:00:00	QQQ	ETF	363.5	363.64	362.95	363.08	34661.0
2023-09-21 04:30:00	QQQ	ETF	362.99	362.99	362.36	362.54	35507.0
2023-09-21 05:00:00	QQQ	ETF	362.5	362.83	362.34	362.57	99684.0
2023-09-21 05:30:00	QQQ	ETF	362.57	362.68	362.0	362.13	36025.0
2023-09-21 06:00:00	QQQ	ETF	362.14	362.15	361.75	361.88	43821.0
2023-09-21 06:30:00	QQQ	ETF	361.89	361.98	361.56	361.75	39209.0
2023-09-21 07:00:00	QQQ	ETF	361.85	361.97	360.8	360.95	236920.0
2023-09-21 07:30:00	QQQ	ETF	360.97	361.19	360.68	360.76	215666.0
2023-09-21 08:00:00	QQQ	ETF	361.34	364.813	360.45	360.74	731203.0
2023-09-21 08:30:00	QQQ	ETF	360.71	360.7448	359.8	360.2	616936.0
2023-09-21 09:00:00	QQQ	ETF	360.2	360.83	360.12	360.79	429627.0
2023-09-21 09:30:00	QQQ	ETF	360.8	361.6	359.435	359.5	9004883.0
2023-09-21 10:00:00	QQQ	ETF	359.47	361.21	359.17	360.31	5728025.0
2023-09-21 10:30:00	QQQ	ETF	360.32	361.56	360.09	360.2094	4424615.0
2023-09-21 11:00:00	QQQ	ETF	360.21	360.81	359.61	359.75	2853686.0
2023-09-21 11:30:00	QQQ	ETF	359.74	360.4876	359.61	359.82	2557661.0
2023-09-21 12:00:00	QQQ	ETF	359.81	359.928	359.2273	359.73	2489451.0
2023-09-21 12:30:00	QQQ	ETF	359.73	360.44	359.58	359.86	2334072.0

> showing 50 of 29,138 rows — these rows as CSV

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