PREVIEW / etf_30min / 2021-12-08

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-08.parquet
  size:    641 KB
  rows:    24,974

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-12-08 04:00:00	SPY	ETF	469.59	469.71	469.14	469.14	21501.0
2021-12-08 04:30:00	SPY	ETF	469.16	469.4	469.0	469.15	6856.0
2021-12-08 05:00:00	SPY	ETF	469.24	469.25	469.01	469.05	7624.0
2021-12-08 05:30:00	SPY	ETF	468.95	468.98	468.2	468.23	36466.0
2021-12-08 06:00:00	SPY	ETF	468.13	468.78	467.8	468.33	26493.0
2021-12-08 06:30:00	SPY	ETF	468.39	470.98	468.21	469.91	320945.0
2021-12-08 07:00:00	SPY	ETF	469.99	470.58	469.15	469.61	234456.0
2021-12-08 07:30:00	SPY	ETF	469.61	469.69	468.84	469.17	147689.0
2021-12-08 08:00:00	SPY	ETF	470.03	470.8096	468.1296	469.06	187888.0
2021-12-08 08:30:00	SPY	ETF	469.0	469.1	468.72	468.88	220910.0
2021-12-08 09:00:00	SPY	ETF	468.85	468.96	468.48	468.7	188245.0
2021-12-08 09:30:00	SPY	ETF	468.7	469.285	467.5	468.14	6217190.0
2021-12-08 10:00:00	SPY	ETF	468.14	468.79	467.4012	467.46	4355081.0
2021-12-08 10:30:00	SPY	ETF	467.46	468.29	466.97	467.08	3549508.0
2021-12-08 11:00:00	SPY	ETF	467.08	467.93	466.83	467.9201	2375853.0
2021-12-08 11:30:00	SPY	ETF	467.93	468.3	467.46	468.1282	2219546.0
2021-12-08 12:00:00	SPY	ETF	468.11	468.2294	467.47	467.84	1868352.0
2021-12-08 12:30:00	SPY	ETF	467.83	468.51	467.77	468.27	1396526.0
2021-12-08 13:00:00	SPY	ETF	468.27	468.62	468.14	468.58	1327321.0
2021-12-08 13:30:00	SPY	ETF	468.58	469.0	468.36	468.65	1745881.0
2021-12-08 14:00:00	SPY	ETF	468.64	468.91	468.22	468.85	2206122.0
2021-12-08 14:30:00	SPY	ETF	468.845	469.17	468.54	469.11	1936183.0
2021-12-08 15:00:00	SPY	ETF	469.11	469.525	468.892	469.46	2682056.0
2021-12-08 15:30:00	SPY	ETF	469.45	470.0	469.12	469.5401	9801229.0
2021-12-08 16:00:00	SPY	ETF	469.55	469.8	469.4	469.58	2565625.0
2021-12-08 16:30:00	SPY	ETF	469.58	469.66	469.35	469.4	411473.0
2021-12-08 17:00:00	SPY	ETF	469.32	469.5	469.32	469.41	4519.0
2021-12-08 17:30:00	SPY	ETF	469.47	469.52	469.4	469.5	18852.0
2021-12-08 18:00:00	SPY	ETF	469.49	469.64	469.25	469.5	28398.0
2021-12-08 18:30:00	SPY	ETF	469.52	469.54	469.19	469.28	43380.0
2021-12-08 19:00:00	SPY	ETF	469.4	469.4	469.1	469.33	20222.0
2021-12-08 19:30:00	SPY	ETF	469.29	469.33	469.15	469.2201	24530.0
2021-12-08 04:00:00	QQQ	ETF	399.84	400.0	399.23	399.26	35825.0
2021-12-08 04:30:00	QQQ	ETF	399.19	399.36	398.83	399.18	23431.0
2021-12-08 05:00:00	QQQ	ETF	399.15	399.31	399.0	399.13	5361.0
2021-12-08 05:30:00	QQQ	ETF	399.06	399.07	398.57	398.82	24193.0
2021-12-08 06:00:00	QQQ	ETF	398.76	399.46	398.55	399.16	64290.0
2021-12-08 06:30:00	QQQ	ETF	399.23	400.6	399.1	399.2	145834.0
2021-12-08 07:00:00	QQQ	ETF	399.15	399.7	398.4	399.09	136220.0
2021-12-08 07:30:00	QQQ	ETF	398.99	399.25	398.66	398.92	79935.0
2021-12-08 08:00:00	QQQ	ETF	399.24	399.9904	398.128	398.63	168020.0
2021-12-08 08:30:00	QQQ	ETF	398.5	398.5	397.86	398.21	163407.0
2021-12-08 09:00:00	QQQ	ETF	398.2	398.38	397.81	398.16	137790.0
2021-12-08 09:30:00	QQQ	ETF	398.17	398.77	396.22	397.06	6442931.0
2021-12-08 10:00:00	QQQ	ETF	397.02	398.15	396.56	396.97	3306938.0
2021-12-08 10:30:00	QQQ	ETF	396.98	397.66	396.295	396.96	2331626.0
2021-12-08 11:00:00	QQQ	ETF	396.96	397.9	396.3314	397.87	1643912.0
2021-12-08 11:30:00	QQQ	ETF	397.86	398.39	397.48	398.065	1646978.0
2021-12-08 12:00:00	QQQ	ETF	398.02	398.13	397.17	397.5018	1157261.0
2021-12-08 12:30:00	QQQ	ETF	397.52	398.39	397.36	397.91	1040501.0

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

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