PREVIEW / etf_30min / 2021-11-23

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-23.parquet
  size:    646 KB
  rows:    25,452

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-23 04:00:00	SPY	ETF	466.66	466.66	465.71	466.25	34378.0
2021-11-23 04:30:00	SPY	ETF	466.3	467.0	466.17	466.98	22637.0
2021-11-23 05:00:00	SPY	ETF	467.13	467.5	467.12	467.26	59854.0
2021-11-23 05:30:00	SPY	ETF	467.1	467.39	467.09	467.17	11754.0
2021-11-23 06:00:00	SPY	ETF	467.19	467.19	466.42	466.91	18904.0
2021-11-23 06:30:00	SPY	ETF	466.96	467.53	466.88	467.3	24149.0
2021-11-23 07:00:00	SPY	ETF	467.28	467.72	467.13	467.2	88801.0
2021-11-23 07:30:00	SPY	ETF	467.11	467.35	466.9	467.12	76100.0
2021-11-23 08:00:00	SPY	ETF	467.49	467.72	465.9696	467.52	193883.0
2021-11-23 08:30:00	SPY	ETF	467.5	467.69	465.4	467.43	150803.0
2021-11-23 09:00:00	SPY	ETF	467.46	467.55	467.12	467.2	173766.0
2021-11-23 09:30:00	SPY	ETF	467.22	469.095	466.26	468.575	7106694.0
2021-11-23 10:00:00	SPY	ETF	468.57	468.71	465.92	466.08	5591152.0
2021-11-23 10:30:00	SPY	ETF	466.08	466.7	465.02	465.07	4233392.0
2021-11-23 11:00:00	SPY	ETF	465.065	466.9861	464.45	466.59	4537517.0
2021-11-23 11:30:00	SPY	ETF	466.59	467.03	465.78	466.21	3305356.0
2021-11-23 12:00:00	SPY	ETF	466.21	466.65	465.21	466.3	2585335.0
2021-11-23 12:30:00	SPY	ETF	466.305	466.71	465.28	465.49	1994707.0
2021-11-23 13:00:00	SPY	ETF	465.46	466.09	465.07	465.42	2119590.0
2021-11-23 13:30:00	SPY	ETF	465.41	466.938	464.93	466.27	2521246.0
2021-11-23 14:00:00	SPY	ETF	466.28	466.66	465.53	466.02	2824627.0
2021-11-23 14:30:00	SPY	ETF	466.0	467.83	465.57	467.55	3901184.0
2021-11-23 15:00:00	SPY	ETF	467.54	467.89	466.97	467.2	3145844.0
2021-11-23 15:30:00	SPY	ETF	467.19	468.67	467.18	468.24	8913970.0
2021-11-23 16:00:00	SPY	ETF	468.24	468.29	467.45	467.74	3201984.0
2021-11-23 16:30:00	SPY	ETF	467.74	468.19	467.68	468.0	2634750.0
2021-11-23 17:00:00	SPY	ETF	467.85	468.08	467.85	468.02	8027.0
2021-11-23 17:30:00	SPY	ETF	468.02	468.05	467.89	467.91	12703.0
2021-11-23 18:00:00	SPY	ETF	467.97	468.21	467.82	468.21	30255.0
2021-11-23 18:30:00	SPY	ETF	468.19	468.19	467.7	467.79	18017.0
2021-11-23 19:00:00	SPY	ETF	467.81	468.3	467.81	468.1	31093.0
2021-11-23 19:30:00	SPY	ETF	468.13	468.14	467.9	468.05	23546.0
2021-11-23 04:00:00	QQQ	ETF	398.19	398.19	397.31	397.45	180098.0
2021-11-23 04:30:00	QQQ	ETF	397.43	398.15	397.31	398.15	35181.0
2021-11-23 05:00:00	QQQ	ETF	398.23	398.59	398.18	398.43	124745.0
2021-11-23 05:30:00	QQQ	ETF	398.22	398.43	397.96	397.96	17741.0
2021-11-23 06:00:00	QQQ	ETF	398.09	398.09	397.36	397.83	21124.0
2021-11-23 06:30:00	QQQ	ETF	397.75	398.56	397.74	398.32	53773.0
2021-11-23 07:00:00	QQQ	ETF	398.44	399.15	398.22	398.25	116051.0
2021-11-23 07:30:00	QQQ	ETF	398.23	398.6	397.96	398.16	134415.0
2021-11-23 08:00:00	QQQ	ETF	398.05	399.15	397.0	398.85	211874.0
2021-11-23 08:30:00	QQQ	ETF	398.84	399.24	396.85	398.58	266483.0
2021-11-23 09:00:00	QQQ	ETF	398.6	398.71	397.91	398.09	246640.0
2021-11-23 09:30:00	QQQ	ETF	398.11	400.23	396.9	399.73	7045305.0
2021-11-23 10:00:00	QQQ	ETF	399.73	399.89	395.8	395.93	5619834.0
2021-11-23 10:30:00	QQQ	ETF	395.92	396.57	393.96	394.09	5968702.0
2021-11-23 11:00:00	QQQ	ETF	394.09	396.593	393.44	396.04	5462011.0
2021-11-23 11:30:00	QQQ	ETF	396.04	396.54	394.66	395.15	3753607.0
2021-11-23 12:00:00	QQQ	ETF	395.14	395.929	394.245	395.36	2380657.0
2021-11-23 12:30:00	QQQ	ETF	395.39	395.93	394.01	394.25	2365247.0

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

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