PREVIEW / etf_30min / 2019-03-28

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-28.parquet
  size:    485 KB
  rows:    16,930

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
2019-03-28 04:00:00	SPY	ETF	279.06	279.58	279.06	279.48	18747.0
2019-03-28 04:30:00	SPY	ETF	279.43	280.1	279.39	279.98	12234.0
2019-03-28 05:00:00	SPY	ETF	280.05	280.22	279.85	280.07	8765.0
2019-03-28 05:30:00	SPY	ETF	280.14	280.22	279.95	280.0	2391.0
2019-03-28 06:00:00	SPY	ETF	279.95	280.27	279.84	280.0	5807.0
2019-03-28 06:30:00	SPY	ETF	280.04	280.04	279.75	279.93	17520.0
2019-03-28 07:00:00	SPY	ETF	279.94	279.99	279.48	279.52	207877.0
2019-03-28 07:30:00	SPY	ETF	279.51	279.73	279.41	279.6	178485.0
2019-03-28 08:00:00	SPY	ETF	279.58	280.17	279.08	279.75	282237.0
2019-03-28 08:30:00	SPY	ETF	279.9	279.98	279.46	279.91	223763.0
2019-03-28 09:00:00	SPY	ETF	279.9	280.53	279.7499	280.38	330441.0
2019-03-28 09:30:00	SPY	ETF	280.35	280.86	279.91	280.71	6479402.0
2019-03-28 10:00:00	SPY	ETF	280.71	281.15	280.455	280.88	4020789.0
2019-03-28 10:30:00	SPY	ETF	280.88	281.21	280.38	280.4	3627183.0
2019-03-28 11:00:00	SPY	ETF	280.41	280.4885	279.23	279.28	5749449.0
2019-03-28 11:30:00	SPY	ETF	279.27	279.89	279.18	279.63	4308086.0
2019-03-28 12:00:00	SPY	ETF	279.64	279.76	279.07	279.635	2777215.0
2019-03-28 12:30:00	SPY	ETF	279.64	280.08	279.55	280.0	2231917.0
2019-03-28 13:00:00	SPY	ETF	280.005	280.35	279.99	280.315	2482235.0
2019-03-28 13:30:00	SPY	ETF	280.31	280.42	280.05	280.39	2297659.0
2019-03-28 14:00:00	SPY	ETF	280.39	280.48	280.23	280.37	2203116.0
2019-03-28 14:30:00	SPY	ETF	280.37	280.37	280.01	280.3	2203660.0
2019-03-28 15:00:00	SPY	ETF	280.3	280.77	280.2	280.555	3447210.0
2019-03-28 15:30:00	SPY	ETF	280.555	280.94	280.53	280.78	8831287.0
2019-03-28 16:00:00	SPY	ETF	280.78	280.96	280.61	280.9	2746483.0
2019-03-28 16:30:00	SPY	ETF	280.92	281.06	280.71	281.0	115520.0
2019-03-28 17:00:00	SPY	ETF	280.99	280.99	280.73	280.89	132948.0
2019-03-28 17:30:00	SPY	ETF	280.89	280.94	280.88	280.9	25976.0
2019-03-28 18:00:00	SPY	ETF	280.89	281.09	280.83	280.85	88752.0
2019-03-28 18:30:00	SPY	ETF	280.85	281.0	280.83	280.94	18567.0
2019-03-28 19:00:00	SPY	ETF	280.94	281.67	280.92	281.42	58616.0
2019-03-28 19:30:00	SPY	ETF	281.45	281.6	281.4	281.49	59969.0
2019-03-28 04:00:00	QQQ	ETF	177.54	177.88	177.54	177.81	4250.0
2019-03-28 04:30:00	QQQ	ETF	177.74	178.23	177.74	178.22	12900.0
2019-03-28 05:00:00	QQQ	ETF	178.17	178.29	178.01	178.18	21359.0
2019-03-28 05:30:00	QQQ	ETF	178.23	178.23	178.12	178.18	6850.0
2019-03-28 06:00:00	QQQ	ETF	178.12	178.29	178.07	178.17	3439.0
2019-03-28 06:30:00	QQQ	ETF	178.13	178.16	177.99	178.12	29496.0
2019-03-28 07:00:00	QQQ	ETF	178.13	178.13	177.77	177.79	184272.0
2019-03-28 07:30:00	QQQ	ETF	177.81	177.99	177.75	177.95	104924.0
2019-03-28 08:00:00	QQQ	ETF	178.0299	178.28	177.67	178.0099	363194.0
2019-03-28 08:30:00	QQQ	ETF	178.0	178.15	177.79	178.07	140568.0
2019-03-28 09:00:00	QQQ	ETF	178.06	178.44	177.89	178.39	149494.0
2019-03-28 09:30:00	QQQ	ETF	178.38	178.57	177.77	178.5253	3525843.0
2019-03-28 10:00:00	QQQ	ETF	178.53	178.98	178.39	178.61	3075172.0
2019-03-28 10:30:00	QQQ	ETF	178.63	178.94	178.17	178.2	2844157.0
2019-03-28 11:00:00	QQQ	ETF	178.22	178.26	177.28	177.32	3592723.0
2019-03-28 11:30:00	QQQ	ETF	177.3101	177.85	177.24	177.72	2221421.0
2019-03-28 12:00:00	QQQ	ETF	177.68	177.89	177.37	177.77	1089844.0
2019-03-28 12:30:00	QQQ	ETF	177.78	178.19	177.72	178.14	1019792.0

> showing 50 of 16,930 rows — these rows as CSV

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