PREVIEW / etf_30min / 2019-03-04

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-04.parquet
  size:    509 KB
  rows:    17,966

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-04 04:00:00	SPY	ETF	281.59	281.64	280.9	281.45	9693.0
2019-03-04 04:30:00	SPY	ETF	281.45	281.45	281.15	281.24	13277.0
2019-03-04 05:00:00	SPY	ETF	281.1	281.25	281.08	281.25	4301.0
2019-03-04 05:30:00	SPY	ETF	281.24	281.31	281.21	281.21	12450.0
2019-03-04 06:00:00	SPY	ETF	281.15	281.31	281.1	281.31	7676.0
2019-03-04 06:30:00	SPY	ETF	281.3	281.36	281.21	281.21	13008.0
2019-03-04 07:00:00	SPY	ETF	281.3	281.43	281.28	281.42	17860.0
2019-03-04 07:30:00	SPY	ETF	281.44	281.45	281.35	281.39	38472.0
2019-03-04 08:00:00	SPY	ETF	281.34	281.81	281.34	281.5	219709.0
2019-03-04 08:30:00	SPY	ETF	281.5	281.59	281.48	281.55	70366.0
2019-03-04 09:00:00	SPY	ETF	281.56	281.66	281.48	281.63	353687.0
2019-03-04 09:30:00	SPY	ETF	281.6	281.87	281.2	281.6	8604814.0
2019-03-04 10:00:00	SPY	ETF	281.6	281.69	280.97	281.525	4659532.0
2019-03-04 10:30:00	SPY	ETF	281.5201	281.61	280.65	280.69	4423245.0
2019-03-04 11:00:00	SPY	ETF	280.685	280.76	279.53	279.55	6299792.0
2019-03-04 11:30:00	SPY	ETF	279.555	279.65	277.66	277.95	10509471.0
2019-03-04 12:00:00	SPY	ETF	277.95	278.43	277.04	277.67	8402283.0
2019-03-04 12:30:00	SPY	ETF	277.6799	277.94	276.91	277.4	8140369.0
2019-03-04 13:00:00	SPY	ETF	277.39	278.04	276.84	277.95	6971642.0
2019-03-04 13:30:00	SPY	ETF	277.9627	278.545	277.8	278.47	4545888.0
2019-03-04 14:00:00	SPY	ETF	278.47	278.96	278.21	278.91	3687581.0
2019-03-04 14:30:00	SPY	ETF	278.91	279.06	278.63	278.69	5763300.0
2019-03-04 15:00:00	SPY	ETF	278.68	278.945	278.39	278.7315	4008655.0
2019-03-04 15:30:00	SPY	ETF	278.74	279.49	278.61	279.41	13525004.0
2019-03-04 16:00:00	SPY	ETF	279.42	279.42	279.17	279.26	13018443.0
2019-03-04 16:30:00	SPY	ETF	279.25	279.4	279.18	279.21	201373.0
2019-03-04 17:00:00	SPY	ETF	279.16	279.2	279.11	279.15	40972.0
2019-03-04 17:30:00	SPY	ETF	279.18	279.4	279.15	279.15	147167.0
2019-03-04 18:00:00	SPY	ETF	279.15	279.4	278.9	279.02	74814.0
2019-03-04 18:30:00	SPY	ETF	279.02	279.16	278.94	279.16	20900.0
2019-03-04 19:00:00	SPY	ETF	279.19	279.29	278.91	279.19	32661.0
2019-03-04 19:30:00	SPY	ETF	279.25	279.31	279.07	279.07	51097.0
2019-03-04 04:00:00	QQQ	ETF	174.95	175.47	174.95	175.34	27791.0
2019-03-04 04:30:00	QQQ	ETF	175.34	175.34	175.16	175.2	10180.0
2019-03-04 05:00:00	QQQ	ETF	175.16	175.28	175.15	175.22	13350.0
2019-03-04 05:30:00	QQQ	ETF	175.21	175.21	175.08	175.14	22450.0
2019-03-04 06:00:00	QQQ	ETF	175.05	175.25	175.05	175.25	38250.0
2019-03-04 06:30:00	QQQ	ETF	175.23	175.26	175.13	175.15	29568.0
2019-03-04 07:00:00	QQQ	ETF	175.18	175.33	175.18	175.32	42052.0
2019-03-04 07:30:00	QQQ	ETF	175.3	175.33	175.21	175.3	37334.0
2019-03-04 08:00:00	QQQ	ETF	175.24	175.61	175.085	175.4	74751.0
2019-03-04 08:30:00	QQQ	ETF	175.41	175.46	175.36	175.42	51072.0
2019-03-04 09:00:00	QQQ	ETF	175.45	175.53	175.3	175.38	105656.0
2019-03-04 09:30:00	QQQ	ETF	175.37	175.79	175.37	175.69	3138436.0
2019-03-04 10:00:00	QQQ	ETF	175.7	175.75	175.12	175.51	2008445.0
2019-03-04 10:30:00	QQQ	ETF	175.53	175.58	174.87	174.875	2190015.0
2019-03-04 11:00:00	QQQ	ETF	174.88	174.98	174.08	174.1	2916426.0
2019-03-04 11:30:00	QQQ	ETF	174.1	174.19	172.8	173.0074	4545713.0
2019-03-04 12:00:00	QQQ	ETF	173.0	173.4	172.47	172.93	3861256.0
2019-03-04 12:30:00	QQQ	ETF	172.93	173.2	172.6	173.06	2650263.0

> showing 50 of 17,966 rows — these rows as CSV

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