PREVIEW / etf_30min / 2020-12-17

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-17.parquet
  size:    596 KB
  rows:    22,361

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
2020-12-17 04:00:00	SPY	ETF	371.59	372.17	371.59	372.13	14053.0
2020-12-17 04:30:00	SPY	ETF	372.06	372.43	371.93	372.03	14170.0
2020-12-17 05:00:00	SPY	ETF	372.05	372.24	372.01	372.17	4946.0
2020-12-17 05:30:00	SPY	ETF	372.16	372.19	372.06	372.06	7963.0
2020-12-17 06:00:00	SPY	ETF	372.11	372.29	372.11	372.24	8138.0
2020-12-17 06:30:00	SPY	ETF	372.25	372.26	371.95	372.05	13277.0
2020-12-17 07:00:00	SPY	ETF	372.08	372.11	371.8	371.9	37053.0
2020-12-17 07:30:00	SPY	ETF	371.89	371.95	371.77	371.92	45557.0
2020-12-17 08:00:00	SPY	ETF	371.94	372.22	370.51	372.0	60661.0
2020-12-17 08:30:00	SPY	ETF	371.9	371.95	371.55	371.65	176331.0
2020-12-17 09:00:00	SPY	ETF	371.73	372.03	371.73	371.9	107756.0
2020-12-17 09:30:00	SPY	ETF	371.94	372.46	371.52	371.71	6251076.0
2020-12-17 10:00:00	SPY	ETF	371.72	371.96	371.35	371.895	4162375.0
2020-12-17 10:30:00	SPY	ETF	371.88	372.05	371.37	371.575	3619937.0
2020-12-17 11:00:00	SPY	ETF	371.58	371.9	371.412	371.69	3006725.0
2020-12-17 11:30:00	SPY	ETF	371.67	371.73	371.05	371.644	3254655.0
2020-12-17 12:00:00	SPY	ETF	371.64	371.72	371.19	371.45	2530106.0
2020-12-17 12:30:00	SPY	ETF	371.44	371.82	371.31	371.685	1379321.0
2020-12-17 13:00:00	SPY	ETF	371.68	371.98	371.67	371.89	2408028.0
2020-12-17 13:30:00	SPY	ETF	371.895	372.135	371.77	372.135	4679227.0
2020-12-17 14:00:00	SPY	ETF	372.13	372.21	371.96	372.045	4196979.0
2020-12-17 14:30:00	SPY	ETF	372.05	372.22	371.96	372.095	2954598.0
2020-12-17 15:00:00	SPY	ETF	372.095	372.23	371.69	371.85	4003934.0
2020-12-17 15:30:00	SPY	ETF	371.86	372.27	371.52	372.21	8438026.0
2020-12-17 16:00:00	SPY	ETF	372.23	372.48	372.01	372.05	8851728.0
2020-12-17 16:30:00	SPY	ETF	372.07	372.32	372.07	372.25	876365.0
2020-12-17 17:00:00	SPY	ETF	372.5	372.5	372.18	372.35	87628.0
2020-12-17 17:30:00	SPY	ETF	372.35	372.36	372.15	372.34	414917.0
2020-12-17 18:00:00	SPY	ETF	372.27	372.29	372.06	372.26	29007.0
2020-12-17 18:30:00	SPY	ETF	372.3	372.32	372.22	372.24	20309.0
2020-12-17 19:00:00	SPY	ETF	372.21	372.27	371.9	371.95	37000.0
2020-12-17 19:30:00	SPY	ETF	371.96	372.01	371.75	371.78	56654.0
2020-12-17 04:00:00	QQQ	ETF	310.3	310.63	310.3	310.58	23244.0
2020-12-17 04:30:00	QQQ	ETF	310.6	310.82	310.4	310.42	17107.0
2020-12-17 05:00:00	QQQ	ETF	310.48	310.6	310.45	310.6	6606.0
2020-12-17 05:30:00	QQQ	ETF	310.64	310.64	310.52	310.53	7592.0
2020-12-17 06:00:00	QQQ	ETF	310.47	310.61	310.46	310.55	11006.0
2020-12-17 06:30:00	QQQ	ETF	310.53	310.57	310.33	310.36	6605.0
2020-12-17 07:00:00	QQQ	ETF	310.34	310.57	310.27	310.42	46203.0
2020-12-17 07:30:00	QQQ	ETF	310.43	310.55	310.4	310.51	28292.0
2020-12-17 08:00:00	QQQ	ETF	310.5299	310.88	308.98	310.42	74908.0
2020-12-17 08:30:00	QQQ	ETF	310.4	310.59	308.98	310.52	236700.0
2020-12-17 09:00:00	QQQ	ETF	310.5502	310.77	310.55	310.62	140206.0
2020-12-17 09:30:00	QQQ	ETF	310.61	311.24	310.42	310.69	2614948.0
2020-12-17 10:00:00	QQQ	ETF	310.7	310.81	309.89	310.6318	1637684.0
2020-12-17 10:30:00	QQQ	ETF	310.64	310.77	309.75	309.82	1179184.0
2020-12-17 11:00:00	QQQ	ETF	309.84	310.42	309.77	310.3687	979827.0
2020-12-17 11:30:00	QQQ	ETF	310.37	310.4	309.39	310.085	1114472.0
2020-12-17 12:00:00	QQQ	ETF	310.08	310.34	309.77	310.1808	765795.0
2020-12-17 12:30:00	QQQ	ETF	310.1903	310.57	309.94	310.449	505539.0

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

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