PREVIEW / etf_30min / 2024-04-09

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-09.parquet
  size:    789 KB
  rows:    31,816

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
2024-04-09 04:00:00	SPY	ETF	518.32	518.68	518.25	518.68	7999.0
2024-04-09 04:30:00	SPY	ETF	518.65	518.73	518.5	518.73	1708.0
2024-04-09 05:00:00	SPY	ETF	518.85	519.05	518.65	519.04	4663.0
2024-04-09 05:30:00	SPY	ETF	518.99	519.23	518.87	519.01	8350.0
2024-04-09 06:00:00	SPY	ETF	519.01	519.2	518.81	518.81	8445.0
2024-04-09 06:30:00	SPY	ETF	518.77	518.77	518.01	518.37	11701.0
2024-04-09 07:00:00	SPY	ETF	518.39	519.3	518.39	519.1	61102.0
2024-04-09 07:30:00	SPY	ETF	519.08	519.46	518.95	519.46	25512.0
2024-04-09 08:00:00	SPY	ETF	519.48	520.09	518.2596	519.78	141679.0
2024-04-09 08:30:00	SPY	ETF	519.78	520.15	519.69	519.96	56017.0
2024-04-09 09:00:00	SPY	ETF	519.96	520.59	519.76	520.52	131174.0
2024-04-09 09:30:00	SPY	ETF	520.5	520.75	518.77	518.88	4515606.0
2024-04-09 10:00:00	SPY	ETF	518.89	519.28	517.4103	517.59	3400576.0
2024-04-09 10:30:00	SPY	ETF	517.59	517.63	514.35	515.515	7774838.0
2024-04-09 11:00:00	SPY	ETF	515.52	516.55	515.19	515.95	3199628.0
2024-04-09 11:30:00	SPY	ETF	515.96	517.125	515.67	516.825	2642164.0
2024-04-09 12:00:00	SPY	ETF	516.825	517.64	516.76	517.26	1906226.0
2024-04-09 12:30:00	SPY	ETF	517.26	517.78	516.575	516.79	1732756.0
2024-04-09 13:00:00	SPY	ETF	516.8	517.64	516.6	517.16	1916295.0
2024-04-09 13:30:00	SPY	ETF	517.17	517.64	516.66	516.6701	1614674.0
2024-04-09 14:00:00	SPY	ETF	516.67	517.29	516.23	516.65	1811082.0
2024-04-09 14:30:00	SPY	ETF	516.6574	516.91	516.2599	516.51	1811446.0
2024-04-09 15:00:00	SPY	ETF	516.5	518.61	515.71	518.55	3393774.0
2024-04-09 15:30:00	SPY	ETF	518.51	519.44	517.45	519.29	8722601.0
2024-04-09 16:00:00	SPY	ETF	519.3	520.45	519.22	519.93	2552886.0
2024-04-09 16:30:00	SPY	ETF	519.98	520.07	519.32	519.79	154008.0
2024-04-09 17:00:00	SPY	ETF	519.82	519.92	519.63	519.63	44184.0
2024-04-09 17:30:00	SPY	ETF	519.67	519.75	519.62	519.75	9829.0
2024-04-09 18:00:00	SPY	ETF	519.72	519.8	519.65	519.65	29240.0
2024-04-09 18:30:00	SPY	ETF	519.6	519.75	519.5302	519.61	9330.0
2024-04-09 19:00:00	SPY	ETF	519.61	519.65	519.5899	519.59	15948.0
2024-04-09 19:30:00	SPY	ETF	519.59	519.61	519.53	519.55	35511.0
2024-04-09 04:00:00	QQQ	ETF	440.08	441.03	440.05	441.03	13777.0
2024-04-09 04:30:00	QQQ	ETF	440.99	440.99	440.58	440.88	4045.0
2024-04-09 05:00:00	QQQ	ETF	440.8	441.22	440.76	441.13	7273.0
2024-04-09 05:30:00	QQQ	ETF	441.17	441.55	440.98	441.29	14517.0
2024-04-09 06:00:00	QQQ	ETF	441.3	441.33	440.79	440.82	5478.0
2024-04-09 06:30:00	QQQ	ETF	440.6	440.6	439.68	440.34	25660.0
2024-04-09 07:00:00	QQQ	ETF	440.525	441.58	440.44	441.32	45485.0
2024-04-09 07:30:00	QQQ	ETF	441.37	441.81	441.18	441.78	26205.0
2024-04-09 08:00:00	QQQ	ETF	440.4099	442.38	440.0	442.02	129933.0
2024-04-09 08:30:00	QQQ	ETF	441.99	442.44	441.95	442.27	59289.0
2024-04-09 09:00:00	QQQ	ETF	442.26	443.0	442.06	442.931	107966.0
2024-04-09 09:30:00	QQQ	ETF	442.94	443.24	441.61	441.78	3529390.0
2024-04-09 10:00:00	QQQ	ETF	441.78	442.4402	440.07	440.34	2178806.0
2024-04-09 10:30:00	QQQ	ETF	440.36	440.38	437.44	438.8	4973933.0
2024-04-09 11:00:00	QQQ	ETF	438.78	439.72	438.49	438.985	2355346.0
2024-04-09 11:30:00	QQQ	ETF	438.98	440.17	438.5824	439.85	1762801.0
2024-04-09 12:00:00	QQQ	ETF	439.83	440.81	439.71	440.38	1513516.0
2024-04-09 12:30:00	QQQ	ETF	440.4	440.85	439.7386	439.89	1318315.0

> showing 50 of 31,816 rows — these rows as CSV

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