PREVIEW / etf_30min / 2021-11-05

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-05.parquet
  size:    639 KB
  rows:    25,037

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
2021-11-05 04:00:00	SPY	ETF	466.6	467.14	466.6	467.04	4789.0
2021-11-05 04:30:00	SPY	ETF	466.92	467.02	466.92	467.0	2665.0
2021-11-05 05:00:00	SPY	ETF	467.16	467.35	467.1	467.31	4354.0
2021-11-05 05:30:00	SPY	ETF	467.35	467.84	467.35	467.84	10647.0
2021-11-05 06:00:00	SPY	ETF	467.87	468.01	467.75	467.9	16752.0
2021-11-05 06:30:00	SPY	ETF	467.83	468.04	467.82	468.01	12966.0
2021-11-05 07:00:00	SPY	ETF	468.03	468.26	467.56	467.56	47057.0
2021-11-05 07:30:00	SPY	ETF	467.63	467.96	467.59	467.94	32999.0
2021-11-05 08:00:00	SPY	ETF	468.0399	468.11	466.5	468.03	205962.0
2021-11-05 08:30:00	SPY	ETF	468.04	469.2	467.83	468.91	611460.0
2021-11-05 09:00:00	SPY	ETF	468.89	469.46	468.74	469.3	257624.0
2021-11-05 09:30:00	SPY	ETF	469.28	470.41	469.0	470.26	6932129.0
2021-11-05 10:00:00	SPY	ETF	470.26	470.65	469.81	469.97	4246008.0
2021-11-05 10:30:00	SPY	ETF	469.97	470.365	469.92	470.13	2535641.0
2021-11-05 11:00:00	SPY	ETF	470.13	470.31	469.57	469.61	1724848.0
2021-11-05 11:30:00	SPY	ETF	469.6	470.06	469.31	469.32	2808786.0
2021-11-05 12:00:00	SPY	ETF	469.31	469.63	469.24	469.5	1728191.0
2021-11-05 12:30:00	SPY	ETF	469.49	469.67	468.76	468.92	2100733.0
2021-11-05 13:00:00	SPY	ETF	468.93	469.11	466.92	466.93	3369356.0
2021-11-05 13:30:00	SPY	ETF	466.93	468.22	466.92	468.17	3676668.0
2021-11-05 14:00:00	SPY	ETF	468.18	468.74	467.98	468.64	2389664.0
2021-11-05 14:30:00	SPY	ETF	468.64	468.81	468.29	468.68	1399334.0
2021-11-05 15:00:00	SPY	ETF	468.68	468.79	467.98	468.2699	2220159.0
2021-11-05 15:30:00	SPY	ETF	468.26	469.16	468.165	468.49	9656494.0
2021-11-05 16:00:00	SPY	ETF	468.49	468.63	467.77	467.95	3446681.0
2021-11-05 16:30:00	SPY	ETF	467.97	468.53	467.9	468.09	839631.0
2021-11-05 17:00:00	SPY	ETF	468.17	468.21	468.0	468.075	135859.0
2021-11-05 17:30:00	SPY	ETF	468.065	468.1	468.0	468.05	12580.0
2021-11-05 18:00:00	SPY	ETF	468.0	468.05	467.86	467.89	25834.0
2021-11-05 18:30:00	SPY	ETF	468.53	468.53	467.86	467.92	7845.0
2021-11-05 19:00:00	SPY	ETF	467.94	467.95	467.9	467.9	9484.0
2021-11-05 19:30:00	SPY	ETF	467.9	467.95	467.76	467.79	19696.0
2021-11-05 04:00:00	QQQ	ETF	397.87	398.59	397.8	398.51	22867.0
2021-11-05 04:30:00	QQQ	ETF	398.5	398.68	398.37	398.55	8743.0
2021-11-05 05:00:00	QQQ	ETF	398.69	399.0	398.65	399.0	8733.0
2021-11-05 05:30:00	QQQ	ETF	399.11	400.0	399.11	400.0	39300.0
2021-11-05 06:00:00	QQQ	ETF	399.89	400.37	399.88	400.25	37662.0
2021-11-05 06:30:00	QQQ	ETF	400.22	400.22	399.76	399.79	66436.0
2021-11-05 07:00:00	QQQ	ETF	399.78	399.85	398.56	398.56	125318.0
2021-11-05 07:30:00	QQQ	ETF	398.54	398.94	398.5	398.89	300971.0
2021-11-05 08:00:00	QQQ	ETF	399.8099	400.19	397.6	398.8	134826.0
2021-11-05 08:30:00	QQQ	ETF	398.8	399.75	398.12	399.42	542069.0
2021-11-05 09:00:00	QQQ	ETF	399.43	400.31	399.29	400.02	335423.0
2021-11-05 09:30:00	QQQ	ETF	400.04	400.99	399.18	400.19	5075474.0
2021-11-05 10:00:00	QQQ	ETF	400.2	400.87	399.7	400.28	3221748.0
2021-11-05 10:30:00	QQQ	ETF	400.28	400.75	400.25	400.4503	1460158.0
2021-11-05 11:00:00	QQQ	ETF	400.455	400.69	399.93	400.02	1117575.0
2021-11-05 11:30:00	QQQ	ETF	400.01	400.95	399.99	400.49	1361245.0
2021-11-05 12:00:00	QQQ	ETF	400.49	400.74	400.1	400.24	1064697.0
2021-11-05 12:30:00	QQQ	ETF	400.23	400.37	398.99	399.34	1960064.0

> showing 50 of 25,037 rows — these rows as CSV

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