PREVIEW / etf_30min / 2023-04-06

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-06.parquet
  size:    683 KB
  rows:    27,545

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-04-06 04:00:00	SPY	ETF	407.62	407.79	407.5	407.53	8576.0
2023-04-06 04:30:00	SPY	ETF	407.51	407.69	407.46	407.67	10458.0
2023-04-06 05:00:00	SPY	ETF	407.71	407.73	407.36	407.4	8096.0
2023-04-06 05:30:00	SPY	ETF	407.44	407.53	407.22	407.25	5219.0
2023-04-06 06:00:00	SPY	ETF	407.19	407.49	406.85	407.41	70452.0
2023-04-06 06:30:00	SPY	ETF	407.45	407.65	407.43	407.56	86097.0
2023-04-06 07:00:00	SPY	ETF	407.65	407.91	407.62	407.83	32882.0
2023-04-06 07:30:00	SPY	ETF	407.9	408.25	407.9	408.25	87116.0
2023-04-06 08:00:00	SPY	ETF	408.101	408.33	406.55	407.55	161576.0
2023-04-06 08:30:00	SPY	ETF	407.55	407.8	407.0	407.08	360925.0
2023-04-06 09:00:00	SPY	ETF	407.05	407.15	406.53	406.76	193189.0
2023-04-06 09:30:00	SPY	ETF	406.77	406.9	405.678	406.145	5054844.0
2023-04-06 10:00:00	SPY	ETF	406.15	407.29	406.07	406.84	5040947.0
2023-04-06 10:30:00	SPY	ETF	406.83	407.13	406.12	406.44	3560006.0
2023-04-06 11:00:00	SPY	ETF	406.43	407.35	406.23	407.16	2623548.0
2023-04-06 11:30:00	SPY	ETF	407.17	408.14	407.04	408.115	3257794.0
2023-04-06 12:00:00	SPY	ETF	408.12	408.635	408.12	408.465	3152917.0
2023-04-06 12:30:00	SPY	ETF	408.48	409.15	408.4601	408.59	2999172.0
2023-04-06 13:00:00	SPY	ETF	408.61	409.2	408.42	408.9999	1900117.0
2023-04-06 13:30:00	SPY	ETF	408.99	409.22	408.73	408.86	2001624.0
2023-04-06 14:00:00	SPY	ETF	408.865	409.3799	408.76	409.28	1902418.0
2023-04-06 14:30:00	SPY	ETF	409.295	409.48	408.85	408.93	2270212.0
2023-04-06 15:00:00	SPY	ETF	408.935	409.1899	408.47	408.888	3197337.0
2023-04-06 15:30:00	SPY	ETF	408.9	409.26	408.75	409.2	8328850.0
2023-04-06 16:00:00	SPY	ETF	409.2	409.22	409.02	409.05	1947884.0
2023-04-06 16:30:00	SPY	ETF	409.06	409.16	409.01	409.01	146753.0
2023-04-06 17:00:00	SPY	ETF	409.02	409.02	408.92	408.95	30542.0
2023-04-06 17:30:00	SPY	ETF	408.95	408.97	408.85	408.85	72739.0
2023-04-06 18:00:00	SPY	ETF	408.85	408.97	408.72	408.97	200935.0
2023-04-06 18:30:00	SPY	ETF	408.98	409.02	408.88	408.9	12940.0
2023-04-06 19:00:00	SPY	ETF	408.8699	408.88	408.68	408.72	12542.0
2023-04-06 19:30:00	SPY	ETF	408.71	408.8	408.71	408.76	23922.0
2023-04-06 04:00:00	QQQ	ETF	315.53	315.65	315.33	315.34	28605.0
2023-04-06 04:30:00	QQQ	ETF	315.4	315.47	315.13	315.21	10906.0
2023-04-06 05:00:00	QQQ	ETF	315.28	315.32	315.06	315.13	10912.0
2023-04-06 05:30:00	QQQ	ETF	315.19	315.26	314.09	314.2	27363.0
2023-04-06 06:00:00	QQQ	ETF	314.19	314.71	313.65	314.65	38292.0
2023-04-06 06:30:00	QQQ	ETF	314.68	315.09	314.66	315.09	33904.0
2023-04-06 07:00:00	QQQ	ETF	315.09	315.43	315.0	315.28	84599.0
2023-04-06 07:30:00	QQQ	ETF	315.33	315.61	315.33	315.59	65423.0
2023-04-06 08:00:00	QQQ	ETF	315.15	315.85	313.965	314.95	271586.0
2023-04-06 08:30:00	QQQ	ETF	314.99	315.36	314.34	314.43	478941.0
2023-04-06 09:00:00	QQQ	ETF	314.37	314.56	314.05	314.22	250981.0
2023-04-06 09:30:00	QQQ	ETF	314.24	314.27	312.82	313.64	4863436.0
2023-04-06 10:00:00	QQQ	ETF	313.65	315.275	313.555	314.73	4549681.0
2023-04-06 10:30:00	QQQ	ETF	314.73	315.19	314.17	314.54	2312162.0
2023-04-06 11:00:00	QQQ	ETF	314.51	315.92	314.38	315.73	2159367.0
2023-04-06 11:30:00	QQQ	ETF	315.73	317.06	315.57	316.95	2752910.0
2023-04-06 12:00:00	QQQ	ETF	316.95	317.66	316.95	317.35	2407763.0
2023-04-06 12:30:00	QQQ	ETF	317.35	317.849	317.0	317.065	1850704.0

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

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