PREVIEW / etf_30min / 2021-10-22

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-22.parquet
  size:    605 KB
  rows:    23,519

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-10-22 04:00:00	SPY	ETF	453.19	453.43	452.89	453.43	19265.0
2021-10-22 04:30:00	SPY	ETF	453.35	453.58	453.35	453.44	17649.0
2021-10-22 05:00:00	SPY	ETF	453.48	453.48	453.26	453.33	4487.0
2021-10-22 05:30:00	SPY	ETF	453.3	453.44	453.29	453.4	2899.0
2021-10-22 06:00:00	SPY	ETF	453.31	453.92	453.28	453.71	8314.0
2021-10-22 06:30:00	SPY	ETF	453.74	454.14	453.74	453.99	20760.0
2021-10-22 07:00:00	SPY	ETF	454.0	454.31	453.93	454.28	35173.0
2021-10-22 07:30:00	SPY	ETF	454.27	454.3	454.16	454.21	22544.0
2021-10-22 08:00:00	SPY	ETF	453.6296	454.29	453.6296	454.02	160387.0
2021-10-22 08:30:00	SPY	ETF	454.02	454.02	453.4	453.5	88888.0
2021-10-22 09:00:00	SPY	ETF	453.5	453.59	452.97	453.14	248010.0
2021-10-22 09:30:00	SPY	ETF	453.13	454.21	452.91	453.86	4847355.0
2021-10-22 10:00:00	SPY	ETF	453.84	454.67	453.58	454.65	2508718.0
2021-10-22 10:30:00	SPY	ETF	454.65	454.66	453.35	453.495	2114751.0
2021-10-22 11:00:00	SPY	ETF	453.49	453.93	451.94	452.42	3872848.0
2021-10-22 11:30:00	SPY	ETF	452.43	452.54	451.05	451.811	5484127.0
2021-10-22 12:00:00	SPY	ETF	451.81	452.35	451.35	452.35	2555700.0
2021-10-22 12:30:00	SPY	ETF	452.34	453.35	452.28	452.69	3113833.0
2021-10-22 13:00:00	SPY	ETF	452.7	453.169	452.57	452.87	1260906.0
2021-10-22 13:30:00	SPY	ETF	452.89	453.28	452.49	452.535	1583082.0
2021-10-22 14:00:00	SPY	ETF	452.53	453.42	452.53	453.42	1845165.0
2021-10-22 14:30:00	SPY	ETF	453.426	454.08	453.1101	453.13	2698376.0
2021-10-22 15:00:00	SPY	ETF	453.15	453.26	452.7	452.965	3017505.0
2021-10-22 15:30:00	SPY	ETF	452.96	453.67	452.89	453.13	8115855.0
2021-10-22 16:00:00	SPY	ETF	453.13	453.6278	452.73	452.89	2619597.0
2021-10-22 16:30:00	SPY	ETF	452.89	452.92	452.34	452.48	202033.0
2021-10-22 17:00:00	SPY	ETF	452.48	453.12	452.47	452.66	103236.0
2021-10-22 17:30:00	SPY	ETF	452.7	452.8	452.7	452.71	23004.0
2021-10-22 18:00:00	SPY	ETF	452.71	452.74	452.6	452.6	10408.0
2021-10-22 18:30:00	SPY	ETF	453.12	453.12	452.4	452.4	44200.0
2021-10-22 19:00:00	SPY	ETF	452.48	452.55	452.41	452.5	12530.0
2021-10-22 19:30:00	SPY	ETF	452.5	452.5	452.3	452.3	12623.0
2021-10-22 04:00:00	QQQ	ETF	375.87	376.01	375.55	376.01	25050.0
2021-10-22 04:30:00	QQQ	ETF	375.95	376.22	375.93	376.07	11253.0
2021-10-22 05:00:00	QQQ	ETF	376.05	376.11	375.93	376.01	8632.0
2021-10-22 05:30:00	QQQ	ETF	375.95	376.15	375.9	376.14	8767.0
2021-10-22 06:00:00	QQQ	ETF	376.17	376.52	376.14	376.4	30749.0
2021-10-22 06:30:00	QQQ	ETF	376.43	376.72	376.43	376.59	17942.0
2021-10-22 07:00:00	QQQ	ETF	376.57	376.87	376.45	376.79	86951.0
2021-10-22 07:30:00	QQQ	ETF	376.79	376.8	376.65	376.69	70966.0
2021-10-22 08:00:00	QQQ	ETF	376.58	377.552	375.16	376.5804	223869.0
2021-10-22 08:30:00	QQQ	ETF	376.6	376.68	376.2	376.28	120044.0
2021-10-22 09:00:00	QQQ	ETF	376.28	376.28	375.8	375.97	408776.0
2021-10-22 09:30:00	QQQ	ETF	375.98	376.85	375.09	376.04	3520521.0
2021-10-22 10:00:00	QQQ	ETF	376.03	376.97	375.58	376.96	1757138.0
2021-10-22 10:30:00	QQQ	ETF	376.97	376.97	375.33	375.56	1605113.0
2021-10-22 11:00:00	QQQ	ETF	375.565	375.79	373.33	373.91	3079305.0
2021-10-22 11:30:00	QQQ	ETF	373.92	374.03	372.385	373.4	3978913.0
2021-10-22 12:00:00	QQQ	ETF	373.385	373.72	372.95	373.72	2021468.0
2021-10-22 12:30:00	QQQ	ETF	373.72	374.91	373.61	374.0	1879754.0

> showing 50 of 23,519 rows — these rows as CSV

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