PREVIEW / etf_30min / 2021-08-11

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-11.parquet
  size:    611 KB
  rows:    23,104

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-08-11 04:00:00	SPY	ETF	441.95	442.16	441.95	442.09	7213.0
2021-08-11 04:30:00	SPY	ETF	441.97	442.14	441.96	442.06	4191.0
2021-08-11 05:00:00	SPY	ETF	442.12	442.12	441.83	441.9	7149.0
2021-08-11 05:30:00	SPY	ETF	441.99	442.1	441.93	442.1	4332.0
2021-08-11 06:00:00	SPY	ETF	442.11	442.33	442.06	442.27	10854.0
2021-08-11 06:30:00	SPY	ETF	442.28	442.38	442.18	442.3	16718.0
2021-08-11 07:00:00	SPY	ETF	442.4	442.41	442.13	442.14	16874.0
2021-08-11 07:30:00	SPY	ETF	442.14	442.2	442.03	442.15	31516.0
2021-08-11 08:00:00	SPY	ETF	442.2801	442.4	442.02	442.14	50461.0
2021-08-11 08:30:00	SPY	ETF	442.19	443.5	442.19	443.28	768967.0
2021-08-11 09:00:00	SPY	ETF	443.33	443.94	443.28	443.85	274552.0
2021-08-11 09:30:00	SPY	ETF	443.8	443.882	443.24	443.56	4316599.0
2021-08-11 10:00:00	SPY	ETF	443.55	443.8	443.465	443.645	2424446.0
2021-08-11 10:30:00	SPY	ETF	443.64	443.73	443.27	443.358	2508184.0
2021-08-11 11:00:00	SPY	ETF	443.36	443.38	442.72	442.91	2964453.0
2021-08-11 11:30:00	SPY	ETF	442.91	443.12	442.62	442.78	1882076.0
2021-08-11 12:00:00	SPY	ETF	442.78	443.16	442.74	443.0	1512802.0
2021-08-11 12:30:00	SPY	ETF	442.99	443.26	442.965	443.2499	1001774.0
2021-08-11 13:00:00	SPY	ETF	443.245	443.49	443.21	443.4301	1730703.0
2021-08-11 13:30:00	SPY	ETF	443.43	443.49	443.15	443.3712	1290128.0
2021-08-11 14:00:00	SPY	ETF	443.375	443.49	443.12	443.295	1618494.0
2021-08-11 14:30:00	SPY	ETF	443.295	443.5	443.285	443.39	1003380.0
2021-08-11 15:00:00	SPY	ETF	443.399	443.75	443.38	443.6997	1921622.0
2021-08-11 15:30:00	SPY	ETF	443.7	443.79	443.38	443.74	5953339.0
2021-08-11 16:00:00	SPY	ETF	443.74	443.78	443.505	443.71	2462870.0
2021-08-11 16:30:00	SPY	ETF	443.7	443.8	443.69	443.75	141473.0
2021-08-11 17:00:00	SPY	ETF	443.8	443.8	443.6	443.69	34099.0
2021-08-11 17:30:00	SPY	ETF	443.66	443.7	443.61	443.69	8408.0
2021-08-11 18:00:00	SPY	ETF	443.66	443.74	443.6	443.66	20493.0
2021-08-11 18:30:00	SPY	ETF	443.61	443.64	443.59	443.59	13260.0
2021-08-11 19:00:00	SPY	ETF	443.59	443.67	443.57	443.61	10097.0
2021-08-11 19:30:00	SPY	ETF	443.61	443.63	443.55	443.57	9792.0
2021-08-11 04:00:00	QQQ	ETF	366.4	366.4	365.8	365.8	39804.0
2021-08-11 04:30:00	QQQ	ETF	365.91	365.96	365.79	365.84	18765.0
2021-08-11 05:00:00	QQQ	ETF	365.85	365.91	365.32	365.45	14241.0
2021-08-11 05:30:00	QQQ	ETF	365.47	365.62	365.35	365.6	8792.0
2021-08-11 06:00:00	QQQ	ETF	365.5	365.9	365.4	365.88	7792.0
2021-08-11 06:30:00	QQQ	ETF	365.83	366.25	365.83	366.25	30261.0
2021-08-11 07:00:00	QQQ	ETF	366.27	366.35	365.99	366.0	29420.0
2021-08-11 07:30:00	QQQ	ETF	366.02	366.12	365.96	366.11	33989.0
2021-08-11 08:00:00	QQQ	ETF	366.12	367.115	365.34	366.02	74955.0
2021-08-11 08:30:00	QQQ	ETF	366.0	368.44	366.0	367.94	1618084.0
2021-08-11 09:00:00	QQQ	ETF	367.98	368.38	367.79	368.14	203519.0
2021-08-11 09:30:00	QQQ	ETF	368.14	368.65	366.89	367.135	4676627.0
2021-08-11 10:00:00	QQQ	ETF	367.12	367.7195	366.54	366.82	2318518.0
2021-08-11 10:30:00	QQQ	ETF	366.82	367.02	365.94	365.95	2266580.0
2021-08-11 11:00:00	QQQ	ETF	365.98	366.0502	364.84	365.63	3083399.0
2021-08-11 11:30:00	QQQ	ETF	365.6119	365.775	364.87	365.305	1655842.0
2021-08-11 12:00:00	QQQ	ETF	365.29	366.07	365.16	365.68	1248279.0
2021-08-11 12:30:00	QQQ	ETF	365.66	366.03	365.54	365.79	646198.0

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

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