PREVIEW / etf_30min / 2021-11-17

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-17.parquet
  size:    633 KB
  rows:    24,518

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-17 04:00:00	SPY	ETF	469.48	469.48	469.26	469.28	4637.0
2021-11-17 04:30:00	SPY	ETF	469.24	469.24	468.96	469.04	2015.0
2021-11-17 05:00:00	SPY	ETF	469.03	469.04	468.94	468.97	2622.0
2021-11-17 05:30:00	SPY	ETF	469.0	469.03	468.88	468.88	11189.0
2021-11-17 06:00:00	SPY	ETF	468.9	469.05	468.8	468.98	8145.0
2021-11-17 06:30:00	SPY	ETF	469.08	469.08	468.8	469.01	10682.0
2021-11-17 07:00:00	SPY	ETF	469.06	469.31	469.03	469.3	151706.0
2021-11-17 07:30:00	SPY	ETF	469.26	469.3	468.95	468.95	81804.0
2021-11-17 08:00:00	SPY	ETF	469.1599	469.4004	468.4	468.9	416773.0
2021-11-17 08:30:00	SPY	ETF	468.9	469.28	468.65	468.73	295725.0
2021-11-17 09:00:00	SPY	ETF	468.74	468.99	468.7	468.99	128700.0
2021-11-17 09:30:00	SPY	ETF	469.0	469.05	467.48	467.58	4177560.0
2021-11-17 10:00:00	SPY	ETF	467.57	468.2913	467.49	468.0	2874138.0
2021-11-17 10:30:00	SPY	ETF	468.01	468.82	467.94	468.49	2501947.0
2021-11-17 11:00:00	SPY	ETF	468.485	468.66	468.17	468.405	1229576.0
2021-11-17 11:30:00	SPY	ETF	468.4	469.165	468.3	469.085	1413776.0
2021-11-17 12:00:00	SPY	ETF	469.08	469.19	467.71	467.72	2094080.0
2021-11-17 12:30:00	SPY	ETF	467.74	468.34	467.66	468.09	1792779.0
2021-11-17 13:00:00	SPY	ETF	468.1	468.49	467.91	468.42	1147771.0
2021-11-17 13:30:00	SPY	ETF	468.43	468.75	468.265	468.722	987284.0
2021-11-17 14:00:00	SPY	ETF	468.71	468.72	467.98	468.16	1384030.0
2021-11-17 14:30:00	SPY	ETF	468.16	468.51	467.96	468.49	1167388.0
2021-11-17 15:00:00	SPY	ETF	468.5	468.62	467.995	468.39	1703110.0
2021-11-17 15:30:00	SPY	ETF	468.39	468.77	467.97	468.11	7024449.0
2021-11-17 16:00:00	SPY	ETF	468.12	468.27	467.69	467.96	2397792.0
2021-11-17 16:30:00	SPY	ETF	467.95	468.14	467.93	468.02	166194.0
2021-11-17 17:00:00	SPY	ETF	468.04	468.04	467.95	468.0	32687.0
2021-11-17 17:30:00	SPY	ETF	467.98	468.0	467.94	467.99	19916.0
2021-11-17 18:00:00	SPY	ETF	467.99	468.15	467.96	468.15	63357.0
2021-11-17 18:30:00	SPY	ETF	468.14	468.32	468.13	468.32	25992.0
2021-11-17 19:00:00	SPY	ETF	468.34	468.42	468.24	468.38	29430.0
2021-11-17 19:30:00	SPY	ETF	468.39	468.52	468.31	468.37	115120.0
2021-11-17 04:00:00	QQQ	ETF	397.82	398.02	397.79	397.97	24274.0
2021-11-17 04:30:00	QQQ	ETF	397.97	397.99	397.7	397.79	7470.0
2021-11-17 05:00:00	QQQ	ETF	397.82	397.87	397.5	397.58	14482.0
2021-11-17 05:30:00	QQQ	ETF	397.55	397.78	397.54	397.66	3544.0
2021-11-17 06:00:00	QQQ	ETF	397.72	397.85	397.61	397.85	5612.0
2021-11-17 06:30:00	QQQ	ETF	397.87	397.94	397.72	397.86	16382.0
2021-11-17 07:00:00	QQQ	ETF	397.89	398.1	397.85	398.03	59304.0
2021-11-17 07:30:00	QQQ	ETF	398.01	398.05	397.71	397.73	34563.0
2021-11-17 08:00:00	QQQ	ETF	397.76	398.1	397.14	397.5799	86222.0
2021-11-17 08:30:00	QQQ	ETF	397.55	397.68	397.42	397.62	67961.0
2021-11-17 09:00:00	QQQ	ETF	397.59	397.74	397.43	397.71	84508.0
2021-11-17 09:30:00	QQQ	ETF	397.75	397.92	396.64	397.0	2971926.0
2021-11-17 10:00:00	QQQ	ETF	396.99	398.03	396.97	397.69	1941095.0
2021-11-17 10:30:00	QQQ	ETF	397.7	398.66	397.56	398.2	1837610.0
2021-11-17 11:00:00	QQQ	ETF	398.219	398.78	398.05	398.69	1097102.0
2021-11-17 11:30:00	QQQ	ETF	398.69	399.575	398.5499	399.55	1170617.0
2021-11-17 12:00:00	QQQ	ETF	399.5419	399.7196	397.54	397.57	2102671.0
2021-11-17 12:30:00	QQQ	ETF	397.6	398.275	397.23	397.47	1659392.0

> showing 50 of 24,518 rows — these rows as CSV

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