PREVIEW / etf_30min / 2021-06-29

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-29.parquet
  size:    596 KB
  rows:    22,953

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-06-29 04:00:00	SPY	ETF	427.53	427.53	427.19	427.19	2274.0
2021-06-29 04:30:00	SPY	ETF	427.18	427.23	427.0	427.21	8418.0
2021-06-29 05:00:00	SPY	ETF	427.33	427.46	427.33	427.45	5847.0
2021-06-29 05:30:00	SPY	ETF	427.39	427.51	427.35	427.45	5400.0
2021-06-29 06:00:00	SPY	ETF	427.46	427.5	427.39	427.39	5408.0
2021-06-29 06:30:00	SPY	ETF	427.36	427.62	427.28	427.62	150764.0
2021-06-29 07:00:00	SPY	ETF	427.62	427.62	427.27	427.27	24718.0
2021-06-29 07:30:00	SPY	ETF	427.27	427.27	427.05	427.22	36115.0
2021-06-29 08:00:00	SPY	ETF	427.22	427.68	427.06	427.45	117694.0
2021-06-29 08:30:00	SPY	ETF	427.46	427.6	427.41	427.57	75882.0
2021-06-29 09:00:00	SPY	ETF	427.59	428.02	427.53	427.9	171339.0
2021-06-29 09:30:00	SPY	ETF	427.89	428.4	427.86	428.17	4146554.0
2021-06-29 10:00:00	SPY	ETF	428.17	428.285	427.94	428.18	2231231.0
2021-06-29 10:30:00	SPY	ETF	428.18	428.56	428.09	428.165	2164809.0
2021-06-29 11:00:00	SPY	ETF	428.165	428.25	427.97	428.19	1862503.0
2021-06-29 11:30:00	SPY	ETF	428.195	428.22	427.845	427.995	1619184.0
2021-06-29 12:00:00	SPY	ETF	427.99	428.09	427.89	428.055	1049527.0
2021-06-29 12:30:00	SPY	ETF	428.055	428.06	427.77	428.01	995502.0
2021-06-29 13:00:00	SPY	ETF	428.02	428.07	427.74	427.743	804700.0
2021-06-29 13:30:00	SPY	ETF	427.744	427.91	427.64	427.87	794364.0
2021-06-29 14:00:00	SPY	ETF	427.87	428.06	427.61	427.66	1332011.0
2021-06-29 14:30:00	SPY	ETF	427.66	427.71	427.13	427.54	2319230.0
2021-06-29 15:00:00	SPY	ETF	427.54	427.75	427.3	427.705	2024643.0
2021-06-29 15:30:00	SPY	ETF	427.7	427.81	427.46	427.67	5266283.0
2021-06-29 16:00:00	SPY	ETF	427.67	428.07	427.66	427.94	2178373.0
2021-06-29 16:30:00	SPY	ETF	427.7	427.97	427.7	427.9	122866.0
2021-06-29 17:00:00	SPY	ETF	427.96	427.96	427.78	427.92	18856.0
2021-06-29 17:30:00	SPY	ETF	427.89	427.91	427.89	427.91	2090.0
2021-06-29 18:00:00	SPY	ETF	427.96	427.96	427.81	427.93	17623.0
2021-06-29 18:30:00	SPY	ETF	427.7	428.0	427.7	427.95	7607.0
2021-06-29 19:00:00	SPY	ETF	427.98	428.18	427.98	428.15	9671.0
2021-06-29 19:30:00	SPY	ETF	428.17	428.27	428.1	428.25	23430.0
2021-06-29 04:00:00	QQQ	ETF	353.18	353.18	352.66	352.78	11343.0
2021-06-29 04:30:00	QQQ	ETF	352.71	352.99	352.64	352.99	9236.0
2021-06-29 05:00:00	QQQ	ETF	353.02	353.27	353.02	353.24	6805.0
2021-06-29 05:30:00	QQQ	ETF	353.25	353.45	353.18	353.45	32735.0
2021-06-29 06:00:00	QQQ	ETF	353.31	353.34	353.2	353.34	11505.0
2021-06-29 06:30:00	QQQ	ETF	353.32	353.7	353.29	353.7	85589.0
2021-06-29 07:00:00	QQQ	ETF	353.71	353.71	353.24	353.32	29066.0
2021-06-29 07:30:00	QQQ	ETF	353.26	353.32	352.98	353.15	68792.0
2021-06-29 08:00:00	QQQ	ETF	353.16	353.58	352.84	353.08	164619.0
2021-06-29 08:30:00	QQQ	ETF	353.12	353.14	352.85	353.11	107434.0
2021-06-29 09:00:00	QQQ	ETF	353.08	353.55	353.071	353.55	182672.0
2021-06-29 09:30:00	QQQ	ETF	353.53	354.13	352.67	353.71	3820317.0
2021-06-29 10:00:00	QQQ	ETF	353.74	353.879	352.83	353.35	2386392.0
2021-06-29 10:30:00	QQQ	ETF	353.34	354.17	353.24	353.72	1951923.0
2021-06-29 11:00:00	QQQ	ETF	353.729	353.85	353.235	353.73	1325472.0
2021-06-29 11:30:00	QQQ	ETF	353.73	353.99	353.58	353.99	828689.0
2021-06-29 12:00:00	QQQ	ETF	353.99	354.5402	353.76	354.53	1052728.0
2021-06-29 12:30:00	QQQ	ETF	354.53	354.71	354.24	354.615	1146337.0

> showing 50 of 22,953 rows — these rows as CSV

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