PREVIEW / etf_30min / 2021-12-09

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-09.parquet
  size:    637 KB
  rows:    24,303

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-09 04:00:00	SPY	ETF	468.58	468.69	468.29	468.62	10127.0
2021-12-09 04:30:00	SPY	ETF	468.62	468.77	468.62	468.7	15867.0
2021-12-09 05:00:00	SPY	ETF	468.62	468.62	467.7	467.93	17182.0
2021-12-09 05:30:00	SPY	ETF	468.09	468.24	467.98	468.14	3807.0
2021-12-09 06:00:00	SPY	ETF	468.27	468.31	467.5	468.03	19459.0
2021-12-09 06:30:00	SPY	ETF	468.04	468.21	467.61	467.93	21868.0
2021-12-09 07:00:00	SPY	ETF	468.0	468.51	467.95	468.22	76341.0
2021-12-09 07:30:00	SPY	ETF	468.26	468.34	467.99	468.21	74452.0
2021-12-09 08:00:00	SPY	ETF	468.25	469.872	467.57	467.74	208150.0
2021-12-09 08:30:00	SPY	ETF	467.84	468.1	467.45	467.92	234510.0
2021-12-09 09:00:00	SPY	ETF	467.96	468.39	467.96	468.12	243199.0
2021-12-09 09:30:00	SPY	ETF	468.15	469.07	467.82	468.26	5212727.0
2021-12-09 10:00:00	SPY	ETF	468.26	468.815	467.5	467.526	2943009.0
2021-12-09 10:30:00	SPY	ETF	467.53	468.3	467.06	468.21	3044104.0
2021-12-09 11:00:00	SPY	ETF	468.22	468.65	467.58	468.595	2148733.0
2021-12-09 11:30:00	SPY	ETF	468.6	468.86	467.76	467.96	1663927.0
2021-12-09 12:00:00	SPY	ETF	467.95	468.37	467.66	468.115	1603318.0
2021-12-09 12:30:00	SPY	ETF	468.115	469.0	468.01	468.945	1654713.0
2021-12-09 13:00:00	SPY	ETF	468.94	468.94	468.43	468.51	1872601.0
2021-12-09 13:30:00	SPY	ETF	468.51	469.11	467.91	468.45	2177710.0
2021-12-09 14:00:00	SPY	ETF	468.44	468.71	468.02	468.11	2101288.0
2021-12-09 14:30:00	SPY	ETF	468.11	468.25	467.17	467.45	2654952.0
2021-12-09 15:00:00	SPY	ETF	467.45	468.01	466.31	466.81	4982062.0
2021-12-09 15:30:00	SPY	ETF	466.81	467.69	466.14	466.33	9393271.0
2021-12-09 16:00:00	SPY	ETF	466.32	466.7	465.9	466.5	2741441.0
2021-12-09 16:30:00	SPY	ETF	466.43	466.58	466.29	466.51	133479.0
2021-12-09 17:00:00	SPY	ETF	466.5	466.71	466.45	466.68	51122.0
2021-12-09 17:30:00	SPY	ETF	466.68	466.85	466.67	466.68	58710.0
2021-12-09 18:00:00	SPY	ETF	466.66	467.04	466.58	466.91	26104.0
2021-12-09 18:30:00	SPY	ETF	466.35	467.18	466.35	466.97	12083.0
2021-12-09 19:00:00	SPY	ETF	467.04	467.1	466.65	466.9	28331.0
2021-12-09 19:30:00	SPY	ETF	466.72	466.79	466.46	466.53	14489.0
2021-12-09 04:00:00	QQQ	ETF	399.33	399.33	398.61	398.9	17876.0
2021-12-09 04:30:00	QQQ	ETF	398.96	399.04	398.76	398.8	2794.0
2021-12-09 05:00:00	QQQ	ETF	398.7	398.7	397.9	398.1	14267.0
2021-12-09 05:30:00	QQQ	ETF	398.21	398.25	398.09	398.18	7706.0
2021-12-09 06:00:00	QQQ	ETF	398.05	398.33	397.61	398.02	19440.0
2021-12-09 06:30:00	QQQ	ETF	398.09	398.2	397.59	397.94	21798.0
2021-12-09 07:00:00	QQQ	ETF	397.91	398.49	397.84	398.24	103847.0
2021-12-09 07:30:00	QQQ	ETF	398.24	398.4	398.18	398.35	18917.0
2021-12-09 08:00:00	QQQ	ETF	398.0501	399.909	397.89	398.1	104077.0
2021-12-09 08:30:00	QQQ	ETF	398.05	398.32	397.7	398.02	142899.0
2021-12-09 09:00:00	QQQ	ETF	398.1	398.48	398.09	398.34	154063.0
2021-12-09 09:30:00	QQQ	ETF	398.35	400.2	397.96	398.558	5772154.0
2021-12-09 10:00:00	QQQ	ETF	398.58	399.02	396.681	396.73	3807302.0
2021-12-09 10:30:00	QQQ	ETF	396.735	397.68	396.32	397.51	3290607.0
2021-12-09 11:00:00	QQQ	ETF	397.55	398.36	396.962	398.25	2844721.0
2021-12-09 11:30:00	QQQ	ETF	398.25	398.5086	397.01	397.15	1753615.0
2021-12-09 12:00:00	QQQ	ETF	397.1473	397.45	396.555	396.89	1558279.0
2021-12-09 12:30:00	QQQ	ETF	396.9	397.663	396.62	397.4912	1148084.0

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

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