PREVIEW / etf_30min / 2022-02-02

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-02-02.parquet
  size:    681 KB
  rows:    26,909

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
2022-02-02 04:00:00	SPY	ETF	455.0	456.23	455.0	455.87	19586.0
2022-02-02 04:30:00	SPY	ETF	455.86	457.01	455.77	456.92	15029.0
2022-02-02 05:00:00	SPY	ETF	456.82	456.88	456.45	456.55	36240.0
2022-02-02 05:30:00	SPY	ETF	456.62	456.81	456.31	456.33	15364.0
2022-02-02 06:00:00	SPY	ETF	456.38	456.38	455.95	456.06	34602.0
2022-02-02 06:30:00	SPY	ETF	456.21	456.56	456.18	456.43	30779.0
2022-02-02 07:00:00	SPY	ETF	456.46	457.01	456.14	456.8	129708.0
2022-02-02 07:30:00	SPY	ETF	456.84	457.43	456.48	457.2	132600.0
2022-02-02 08:00:00	SPY	ETF	456.75	457.34	453.289	456.4	321480.0
2022-02-02 08:30:00	SPY	ETF	456.39	456.73	455.69	455.83	225663.0
2022-02-02 09:00:00	SPY	ETF	455.74	455.99	455.3	455.48	433393.0
2022-02-02 09:30:00	SPY	ETF	455.5	456.39	453.9808	454.51	8603211.0
2022-02-02 10:00:00	SPY	ETF	454.54	456.08	453.86	454.16	5633369.0
2022-02-02 10:30:00	SPY	ETF	454.18	455.79	453.39	455.07	5588511.0
2022-02-02 11:00:00	SPY	ETF	455.08	455.31	453.05	454.28	4859655.0
2022-02-02 11:30:00	SPY	ETF	454.28	454.83	453.16	454.76	3731939.0
2022-02-02 12:00:00	SPY	ETF	454.76	456.02	454.3	455.12	4041731.0
2022-02-02 12:30:00	SPY	ETF	455.13	456.84	454.76	456.82	3467879.0
2022-02-02 13:00:00	SPY	ETF	456.82	456.87	455.24	455.68	3196951.0
2022-02-02 13:30:00	SPY	ETF	455.68	456.67	455.58	456.2715	3337668.0
2022-02-02 14:00:00	SPY	ETF	456.27	456.84	455.48	456.25	4075064.0
2022-02-02 14:30:00	SPY	ETF	456.25	457.7181	456.2	457.0	5249806.0
2022-02-02 15:00:00	SPY	ETF	456.99	458.01	456.59	457.38	5800529.0
2022-02-02 15:30:00	SPY	ETF	457.4	458.12	456.87	457.3	13678465.0
2022-02-02 16:00:00	SPY	ETF	457.31	457.54	453.5	453.94	6050287.0
2022-02-02 16:30:00	SPY	ETF	454.0	457.35	453.8	454.38	598787.0
2022-02-02 17:00:00	SPY	ETF	454.37	454.3801	453.9	454.1	124733.0
2022-02-02 17:30:00	SPY	ETF	454.1	457.35	453.84	453.98	77891.0
2022-02-02 18:00:00	SPY	ETF	454.01	454.34	453.51	453.54	153504.0
2022-02-02 18:30:00	SPY	ETF	457.35	457.35	452.53	452.61	104785.0
2022-02-02 19:00:00	SPY	ETF	452.61	453.28	452.54	453.0301	71397.0
2022-02-02 19:30:00	SPY	ETF	453.11	453.16	452.69	452.69	45581.0
2022-02-02 04:00:00	QQQ	ETF	369.99	370.9	369.86	370.41	92394.0
2022-02-02 04:30:00	QQQ	ETF	370.48	371.88	370.48	371.83	46500.0
2022-02-02 05:00:00	QQQ	ETF	371.7	371.7	370.98	371.1	38121.0
2022-02-02 05:30:00	QQQ	ETF	371.32	371.4	370.66	370.76	9057.0
2022-02-02 06:00:00	QQQ	ETF	370.94	370.99	370.25	370.76	108725.0
2022-02-02 06:30:00	QQQ	ETF	370.65	371.28	370.65	371.1	49087.0
2022-02-02 07:00:00	QQQ	ETF	371.19	372.05	370.78	371.93	132668.0
2022-02-02 07:30:00	QQQ	ETF	371.93	372.0	371.45	371.74	212019.0
2022-02-02 08:00:00	QQQ	ETF	371.5996	372.0	365.794	370.7	405798.0
2022-02-02 08:30:00	QQQ	ETF	370.73	370.95	369.77	369.93	383388.0
2022-02-02 09:00:00	QQQ	ETF	369.88	370.09	369.3	369.74	491217.0
2022-02-02 09:30:00	QQQ	ETF	369.8	370.1	366.37	368.04	7805206.0
2022-02-02 10:00:00	QQQ	ETF	368.12	369.83	366.63	367.3	5936139.0
2022-02-02 10:30:00	QQQ	ETF	367.29	368.32	366.12	367.29	4662639.0
2022-02-02 11:00:00	QQQ	ETF	367.29	367.63	364.39	365.74	5359629.0
2022-02-02 11:30:00	QQQ	ETF	365.73	366.47	364.285	366.38	3528169.0
2022-02-02 12:00:00	QQQ	ETF	366.38	367.48	365.6	366.4399	2547057.0
2022-02-02 12:30:00	QQQ	ETF	366.47	368.65	366.0216	368.629	2474114.0

> showing 50 of 26,909 rows — these rows as CSV

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