PREVIEW / etf_30min / 2023-08-21

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-21.parquet
  size:    708 KB
  rows:    28,160

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-08-21 04:00:00	SPY	ETF	437.02	437.92	436.75	437.91	24678.0
2023-08-21 04:30:00	SPY	ETF	437.93	437.95	437.73	437.95	11077.0
2023-08-21 05:00:00	SPY	ETF	437.97	438.55	437.97	438.44	14872.0
2023-08-21 05:30:00	SPY	ETF	438.39	438.52	438.2	438.52	9423.0
2023-08-21 06:00:00	SPY	ETF	438.49	438.62	438.13	438.13	41671.0
2023-08-21 06:30:00	SPY	ETF	438.28	438.28	438.04	438.04	25445.0
2023-08-21 07:00:00	SPY	ETF	438.12	438.43	438.0	438.4	146953.0
2023-08-21 07:30:00	SPY	ETF	438.47	438.7	438.39	438.57	142413.0
2023-08-21 08:00:00	SPY	ETF	438.3	438.76	435.73	438.38	175219.0
2023-08-21 08:30:00	SPY	ETF	438.36	438.44	437.5	437.57	308070.0
2023-08-21 09:00:00	SPY	ETF	437.54	437.7	437.15	437.53	216821.0
2023-08-21 09:30:00	SPY	ETF	437.55	438.71	437.33	438.71	4917139.0
2023-08-21 10:00:00	SPY	ETF	438.72	438.89	436.555	436.64	5196053.0
2023-08-21 10:30:00	SPY	ETF	436.65	437.08	436.42	436.725	3856518.0
2023-08-21 11:00:00	SPY	ETF	436.725	437.06	435.82	435.9956	3613565.0
2023-08-21 11:30:00	SPY	ETF	435.995	436.47	435.32	435.62	3013313.0
2023-08-21 12:00:00	SPY	ETF	435.62	436.95	435.52	436.91	2748496.0
2023-08-21 12:30:00	SPY	ETF	436.91	437.4095	436.59	437.31	2725670.0
2023-08-21 13:00:00	SPY	ETF	437.32	438.145	436.95	437.9	3038758.0
2023-08-21 13:30:00	SPY	ETF	437.899	438.45	437.81	438.05	3375014.0
2023-08-21 14:00:00	SPY	ETF	438.06	438.69	437.9	438.3485	2900756.0
2023-08-21 14:30:00	SPY	ETF	438.36	439.2401	438.24	438.98	3049083.0
2023-08-21 15:00:00	SPY	ETF	439.01	439.72	439.01	439.4	3378307.0
2023-08-21 15:30:00	SPY	ETF	439.405	440.11	439.11	439.34	9276256.0
2023-08-21 16:00:00	SPY	ETF	439.33	439.542	437.9266	438.9	2638711.0
2023-08-21 16:30:00	SPY	ETF	438.93	439.04	438.88	438.99	64559.0
2023-08-21 17:00:00	SPY	ETF	438.95	439.04	438.95	439.03	40449.0
2023-08-21 17:30:00	SPY	ETF	439.05	439.09	439.0	439.03	11962.0
2023-08-21 18:00:00	SPY	ETF	439.03	439.03	438.6402	438.76	35755.0
2023-08-21 18:30:00	SPY	ETF	438.7794	438.8	438.64	438.64	29612.0
2023-08-21 19:00:00	SPY	ETF	438.7	439.03	438.7	438.98	17061.0
2023-08-21 19:30:00	SPY	ETF	438.97	439.02	438.6005	438.67	31625.0
2023-08-21 04:00:00	QQQ	ETF	358.54	360.07	358.54	360.07	89423.0
2023-08-21 04:30:00	QQQ	ETF	360.08	360.23	359.93	360.17	18585.0
2023-08-21 05:00:00	QQQ	ETF	360.22	360.44	360.16	360.28	19520.0
2023-08-21 05:30:00	QQQ	ETF	360.23	360.4	360.08	360.4	17150.0
2023-08-21 06:00:00	QQQ	ETF	360.34	360.53	360.06	360.06	39788.0
2023-08-21 06:30:00	QQQ	ETF	360.08	360.22	359.88	360.06	42322.0
2023-08-21 07:00:00	QQQ	ETF	360.04	360.3	359.91	360.3	229892.0
2023-08-21 07:30:00	QQQ	ETF	360.3	360.67	360.25	360.6	102784.0
2023-08-21 08:00:00	QQQ	ETF	360.0	360.8	357.61	360.53	175006.0
2023-08-21 08:30:00	QQQ	ETF	360.57	360.57	359.75	359.77	217151.0
2023-08-21 09:00:00	QQQ	ETF	359.78	359.94	359.28	359.6	365398.0
2023-08-21 09:30:00	QQQ	ETF	359.6	362.16	359.55	362.16	4625836.0
2023-08-21 10:00:00	QQQ	ETF	362.17	362.61	360.06	360.16	3961166.0
2023-08-21 10:30:00	QQQ	ETF	360.17	361.06	359.93	360.18	2859714.0
2023-08-21 11:00:00	QQQ	ETF	360.17	360.779	359.26	359.69	2362794.0
2023-08-21 11:30:00	QQQ	ETF	359.69	360.2701	359.15	359.655	2234390.0
2023-08-21 12:00:00	QQQ	ETF	359.65	361.31	359.58	361.2574	2477140.0
2023-08-21 12:30:00	QQQ	ETF	361.26	361.9448	361.02	361.86	1966832.0

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

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