PREVIEW / etf_30min / 2021-11-08

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-08.parquet
  size:    643 KB
  rows:    25,222

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-08 04:00:00	SPY	ETF	468.05	468.88	468.05	468.8	31179.0
2021-11-08 04:30:00	SPY	ETF	468.84	468.86	468.64	468.64	3710.0
2021-11-08 05:00:00	SPY	ETF	468.65	468.94	468.54	468.9	19339.0
2021-11-08 05:30:00	SPY	ETF	468.91	468.95	468.68	468.77	8341.0
2021-11-08 06:00:00	SPY	ETF	468.84	468.9	468.72	468.85	31603.0
2021-11-08 06:30:00	SPY	ETF	468.86	468.99	468.86	468.93	23516.0
2021-11-08 07:00:00	SPY	ETF	468.92	468.92	468.65	468.8	69050.0
2021-11-08 07:30:00	SPY	ETF	468.8	469.01	468.64	468.7	170410.0
2021-11-08 08:00:00	SPY	ETF	468.88	469.19	467.6	469.17	247938.0
2021-11-08 08:30:00	SPY	ETF	469.18	469.5	469.1	469.49	135540.0
2021-11-08 09:00:00	SPY	ETF	469.5	469.93	469.42	469.67	190826.0
2021-11-08 09:30:00	SPY	ETF	469.7	470.23	469.03	469.45	4352996.0
2021-11-08 10:00:00	SPY	ETF	469.45	469.78	468.8675	469.3813	2118138.0
2021-11-08 10:30:00	SPY	ETF	469.37	469.7	468.655	469.055	2199256.0
2021-11-08 11:00:00	SPY	ETF	469.05	469.34	468.64	469.23	1579880.0
2021-11-08 11:30:00	SPY	ETF	469.23	469.35	468.51	468.65	1215744.0
2021-11-08 12:00:00	SPY	ETF	468.65	468.75	468.2031	468.6	1454857.0
2021-11-08 12:30:00	SPY	ETF	468.605	468.79	468.23	468.61	1220028.0
2021-11-08 13:00:00	SPY	ETF	468.61	468.98	468.44	468.85	1312167.0
2021-11-08 13:30:00	SPY	ETF	468.84	469.13	468.66	469.06	983294.0
2021-11-08 14:00:00	SPY	ETF	469.05	469.45	468.9	468.955	1503248.0
2021-11-08 14:30:00	SPY	ETF	468.96	469.479	468.95	469.47	1461209.0
2021-11-08 15:00:00	SPY	ETF	469.48	469.48	468.91	469.09	1996266.0
2021-11-08 15:30:00	SPY	ETF	469.08	469.3164	468.54	468.96	6355400.0
2021-11-08 16:00:00	SPY	ETF	468.99	469.1	468.4	468.57	3175057.0
2021-11-08 16:30:00	SPY	ETF	468.57	468.93	468.55	468.69	271504.0
2021-11-08 17:00:00	SPY	ETF	468.69	468.73	468.53	468.53	56914.0
2021-11-08 17:30:00	SPY	ETF	468.52	468.62	468.51	468.51	34106.0
2021-11-08 18:00:00	SPY	ETF	468.56	468.66	468.27	468.42	72220.0
2021-11-08 18:30:00	SPY	ETF	468.49	468.6	468.38	468.4	11506.0
2021-11-08 19:00:00	SPY	ETF	468.29	468.48	467.89	467.92	40470.0
2021-11-08 19:30:00	SPY	ETF	467.969	467.9699	467.72	467.77	28000.0
2021-11-08 04:00:00	QQQ	ETF	398.28	398.29	398.04	398.1	38080.0
2021-11-08 04:30:00	QQQ	ETF	398.07	398.22	398.04	398.14	15590.0
2021-11-08 05:00:00	QQQ	ETF	398.23	398.6	398.18	398.6	12159.0
2021-11-08 05:30:00	QQQ	ETF	398.55	398.69	398.34	398.38	192169.0
2021-11-08 06:00:00	QQQ	ETF	398.38	398.59	398.38	398.52	91678.0
2021-11-08 06:30:00	QQQ	ETF	398.54	398.82	398.46	398.61	79271.0
2021-11-08 07:00:00	QQQ	ETF	398.62	398.63	398.31	398.54	44289.0
2021-11-08 07:30:00	QQQ	ETF	398.62	398.77	398.2	398.36	257140.0
2021-11-08 08:00:00	QQQ	ETF	398.48	398.898	397.0	398.67	123395.0
2021-11-08 08:30:00	QQQ	ETF	398.7	398.7	398.55	398.67	54056.0
2021-11-08 09:00:00	QQQ	ETF	398.65	399.14	398.46	398.57	140190.0
2021-11-08 09:30:00	QQQ	ETF	398.57	399.62	397.76	398.27	4316356.0
2021-11-08 10:00:00	QQQ	ETF	398.28	398.85	397.79	398.315	2316289.0
2021-11-08 10:30:00	QQQ	ETF	398.31	398.8	397.4	398.23	1935216.0
2021-11-08 11:00:00	QQQ	ETF	398.23	398.99	397.73	398.815	1682433.0
2021-11-08 11:30:00	QQQ	ETF	398.82	398.97	397.99	398.17	907670.0
2021-11-08 12:00:00	QQQ	ETF	398.18	398.34	397.65	398.02	1095684.0
2021-11-08 12:30:00	QQQ	ETF	398.0	398.48	397.85	398.42	832773.0

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

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