PREVIEW / etf_30min / 2023-05-09

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-09.parquet
  size:    654 KB
  rows:    26,285

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-05-09 04:00:00	SPY	ETF	412.01	412.11	411.49	411.54	9456.0
2023-05-09 04:30:00	SPY	ETF	411.45	411.5	411.15	411.34	17758.0
2023-05-09 05:00:00	SPY	ETF	411.44	411.47	411.2	411.27	9554.0
2023-05-09 05:30:00	SPY	ETF	411.32	411.48	411.14	411.48	127620.0
2023-05-09 06:00:00	SPY	ETF	411.46	411.5	411.29	411.29	5574.0
2023-05-09 06:30:00	SPY	ETF	411.2	411.46	411.15	411.34	12322.0
2023-05-09 07:00:00	SPY	ETF	411.39	411.41	411.06	411.14	85791.0
2023-05-09 07:30:00	SPY	ETF	411.2	411.35	411.0	411.26	68304.0
2023-05-09 08:00:00	SPY	ETF	411.2994	412.44	411.0	411.53	89536.0
2023-05-09 08:30:00	SPY	ETF	411.56	411.56	411.15	411.2	174283.0
2023-05-09 09:00:00	SPY	ETF	411.2	411.36	411.09	411.12	121098.0
2023-05-09 09:30:00	SPY	ETF	411.13	411.675	410.6894	411.63	4848747.0
2023-05-09 10:00:00	SPY	ETF	411.635	411.84	410.84	411.28	3498416.0
2023-05-09 10:30:00	SPY	ETF	411.3	411.655	410.9113	411.37	2443835.0
2023-05-09 11:00:00	SPY	ETF	411.365	411.72	410.97	411.2799	2138758.0
2023-05-09 11:30:00	SPY	ETF	411.28	411.69	410.975	411.03	1597949.0
2023-05-09 12:00:00	SPY	ETF	411.0	411.21	410.81	410.87	1645729.0
2023-05-09 12:30:00	SPY	ETF	410.865	411.39	410.8289	411.355	1512962.0
2023-05-09 13:00:00	SPY	ETF	411.3501	411.46	411.2	411.38	1385661.0
2023-05-09 13:30:00	SPY	ETF	411.38	411.92	411.24	411.84	1638294.0
2023-05-09 14:00:00	SPY	ETF	411.85	412.09	411.6799	411.7899	2330319.0
2023-05-09 14:30:00	SPY	ETF	411.79	411.91	411.11	411.4699	2094561.0
2023-05-09 15:00:00	SPY	ETF	411.4699	411.8	411.31	411.49	2403777.0
2023-05-09 15:30:00	SPY	ETF	411.49	411.69	410.81	410.96	6780011.0
2023-05-09 16:00:00	SPY	ETF	410.97	411.39	410.88	411.19	2317302.0
2023-05-09 16:30:00	SPY	ETF	411.19	411.35	411.01	411.06	217630.0
2023-05-09 17:00:00	SPY	ETF	411.02	411.06	410.81	410.97	275734.0
2023-05-09 17:30:00	SPY	ETF	410.94	411.08	410.8	411.07	16503.0
2023-05-09 18:00:00	SPY	ETF	410.95	411.19	410.85	411.14	39553.0
2023-05-09 18:30:00	SPY	ETF	411.19	411.27	411.12	411.23	29623.0
2023-05-09 19:00:00	SPY	ETF	411.2	411.26	411.15	411.2	7202.0
2023-05-09 19:30:00	SPY	ETF	411.15	411.41	411.14	411.35	28112.0
2023-05-09 04:00:00	QQQ	ETF	322.64	323.07	322.53	322.53	9400.0
2023-05-09 04:30:00	QQQ	ETF	322.47	322.48	322.15	322.43	13214.0
2023-05-09 05:00:00	QQQ	ETF	322.48	322.53	322.29	322.29	17501.0
2023-05-09 05:30:00	QQQ	ETF	322.31	322.49	322.1	322.49	10355.0
2023-05-09 06:00:00	QQQ	ETF	322.43	322.52	322.34	322.34	5908.0
2023-05-09 06:30:00	QQQ	ETF	322.31	322.48	322.22	322.44	8812.0
2023-05-09 07:00:00	QQQ	ETF	322.47	322.51	322.04	322.15	36163.0
2023-05-09 07:30:00	QQQ	ETF	322.19	322.19	321.88	322.13	64890.0
2023-05-09 08:00:00	QQQ	ETF	322.271	323.51	321.92	322.27	93994.0
2023-05-09 08:30:00	QQQ	ETF	322.29	322.29	321.84	321.88	143370.0
2023-05-09 09:00:00	QQQ	ETF	321.87	321.99	321.73	321.99	175789.0
2023-05-09 09:30:00	QQQ	ETF	322.0	322.74	321.85	322.695	3908432.0
2023-05-09 10:00:00	QQQ	ETF	322.695	322.88	321.87	322.04	2175713.0
2023-05-09 10:30:00	QQQ	ETF	322.05	322.56	321.88	322.3	1375986.0
2023-05-09 11:00:00	QQQ	ETF	322.29	322.4478	321.6	321.86	1688596.0
2023-05-09 11:30:00	QQQ	ETF	321.86	322.1	321.5	321.595	1445572.0
2023-05-09 12:00:00	QQQ	ETF	321.58	321.77	321.405	321.54	1438995.0
2023-05-09 12:30:00	QQQ	ETF	321.54	322.1541	321.51	322.1	1199892.0

> showing 50 of 26,285 rows — these rows as CSV

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