PREVIEW / etf_30min / 2021-02-16

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-02-16.parquet
  size:    657 KB
  rows:    25,404

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-02-16 04:00:00	SPY	ETF	394.4	394.79	394.4	394.48	15776.0
2021-02-16 04:30:00	SPY	ETF	394.45	394.67	394.22	394.65	19162.0
2021-02-16 05:00:00	SPY	ETF	394.65	394.76	394.51	394.55	11226.0
2021-02-16 05:30:00	SPY	ETF	394.59	394.77	394.59	394.67	4376.0
2021-02-16 06:00:00	SPY	ETF	394.67	394.68	394.33	394.68	27700.0
2021-02-16 06:30:00	SPY	ETF	394.69	395.0	394.69	394.97	87126.0
2021-02-16 07:00:00	SPY	ETF	394.96	395.05	394.77	394.79	83253.0
2021-02-16 07:30:00	SPY	ETF	394.75	394.84	394.68	394.7	118427.0
2021-02-16 08:00:00	SPY	ETF	394.7	395.35	394.33	394.61	164050.0
2021-02-16 08:30:00	SPY	ETF	394.64	394.64	393.9	394.0	201180.0
2021-02-16 09:00:00	SPY	ETF	393.96	394.06	393.6	394.02	272457.0
2021-02-16 09:30:00	SPY	ETF	393.97	394.17	393.255	393.6799	4250457.0
2021-02-16 10:00:00	SPY	ETF	393.72	394.04	392.82	394.02	2963673.0
2021-02-16 10:30:00	SPY	ETF	394.04	394.16	392.4	393.22	4045328.0
2021-02-16 11:00:00	SPY	ETF	393.21	393.37	392.42	392.59	2208014.0
2021-02-16 11:30:00	SPY	ETF	392.59	392.93	391.91	392.07	2758876.0
2021-02-16 12:00:00	SPY	ETF	392.06	392.8899	391.53	392.81	2971419.0
2021-02-16 12:30:00	SPY	ETF	392.82	392.95	392.46	392.875	1570736.0
2021-02-16 13:00:00	SPY	ETF	392.89	393.08	392.6816	392.9189	1119908.0
2021-02-16 13:30:00	SPY	ETF	392.9	393.2	392.47	392.5	1730773.0
2021-02-16 14:00:00	SPY	ETF	392.51	393.21	392.5	393.1999	1419509.0
2021-02-16 14:30:00	SPY	ETF	393.2	393.29	392.47	392.8301	1845324.0
2021-02-16 15:00:00	SPY	ETF	392.8319	393.0	392.37	392.71	2809215.0
2021-02-16 15:30:00	SPY	ETF	392.7	392.9388	392.01	392.34	5736849.0
2021-02-16 16:00:00	SPY	ETF	392.35	392.61	392.1	392.2	3960125.0
2021-02-16 16:30:00	SPY	ETF	392.21	392.61	392.18	392.54	140495.0
2021-02-16 17:00:00	SPY	ETF	392.5	392.6	392.36	392.4	73316.0
2021-02-16 17:30:00	SPY	ETF	392.38	392.58	392.36	392.46	33021.0
2021-02-16 18:00:00	SPY	ETF	392.5	392.72	392.03	392.2	151927.0
2021-02-16 18:30:00	SPY	ETF	392.3	392.33	391.66	391.73	106583.0
2021-02-16 19:00:00	SPY	ETF	391.71	391.72	391.25	391.43	69134.0
2021-02-16 19:30:00	SPY	ETF	391.53	391.69	391.26	391.47	35979.0
2021-02-16 04:00:00	QQQ	ETF	337.64	337.94	337.64	337.7	21584.0
2021-02-16 04:30:00	QQQ	ETF	337.68	337.85	337.65	337.85	13885.0
2021-02-16 05:00:00	QQQ	ETF	337.88	337.94	337.83	337.9	14616.0
2021-02-16 05:30:00	QQQ	ETF	337.93	338.11	337.93	338.06	5635.0
2021-02-16 06:00:00	QQQ	ETF	338.01	338.05	337.77	338.03	11533.0
2021-02-16 06:30:00	QQQ	ETF	338.08	338.29	338.08	338.25	20608.0
2021-02-16 07:00:00	QQQ	ETF	338.2	338.33	338.06	338.1	55054.0
2021-02-16 07:30:00	QQQ	ETF	338.13	338.35	338.13	338.32	44015.0
2021-02-16 08:00:00	QQQ	ETF	338.3	338.85	338.0	338.14	366570.0
2021-02-16 08:30:00	QQQ	ETF	338.14	338.17	337.58	337.65	110616.0
2021-02-16 09:00:00	QQQ	ETF	337.62	337.7	337.17	337.31	244505.0
2021-02-16 09:30:00	QQQ	ETF	337.25	338.03	336.66	337.64	2990008.0
2021-02-16 10:00:00	QQQ	ETF	337.67	337.91	336.89	337.91	1303027.0
2021-02-16 10:30:00	QQQ	ETF	337.94	338.19	336.7	337.1899	2090565.0
2021-02-16 11:00:00	QQQ	ETF	337.17	337.29	335.78	336.0	1860778.0
2021-02-16 11:30:00	QQQ	ETF	335.99	336.48	335.02	335.1694	1487236.0
2021-02-16 12:00:00	QQQ	ETF	335.14	335.8501	334.34	335.81	1888572.0
2021-02-16 12:30:00	QQQ	ETF	335.81	336.18	335.24	336.122	758024.0

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

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