PREVIEW / etf_30min / 2019-04-24

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-04-24.parquet
  size:    503 KB
  rows:    17,594

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-04-24 04:00:00	SPY	ETF	292.71	292.71	292.43	292.62	8560.0
2019-04-24 04:30:00	SPY	ETF	292.73	292.73	292.7	292.72	1750.0
2019-04-24 05:00:00	SPY	ETF	292.7	292.95	292.7	292.85	1612.0
2019-04-24 05:30:00	SPY	ETF	292.9	293.02	292.9	292.95	4029.0
2019-04-24 06:00:00	SPY	ETF	293.01	293.1	293.0	293.0	6088.0
2019-04-24 06:30:00	SPY	ETF	292.95	293.02	292.94	292.98	2077.0
2019-04-24 07:00:00	SPY	ETF	292.97	293.03	292.9	292.93	33074.0
2019-04-24 07:30:00	SPY	ETF	292.94	293.0	292.84	292.95	77742.0
2019-04-24 08:00:00	SPY	ETF	293.0	293.11	292.56	293.01	203127.0
2019-04-24 08:30:00	SPY	ETF	293.03	293.03	292.88	292.95	166578.0
2019-04-24 09:00:00	SPY	ETF	292.92	292.92	292.75	292.76	342474.0
2019-04-24 09:30:00	SPY	ETF	292.79	292.89	292.31	292.675	4971222.0
2019-04-24 10:00:00	SPY	ETF	292.67	292.96	292.53	292.91	3302031.0
2019-04-24 10:30:00	SPY	ETF	292.91	293.08	292.69	293.07	2675218.0
2019-04-24 11:00:00	SPY	ETF	293.07	293.16	292.86	292.8953	2227623.0
2019-04-24 11:30:00	SPY	ETF	292.9	293.075	292.6	292.68	2320082.0
2019-04-24 12:00:00	SPY	ETF	292.67	292.75	292.49	292.735	2203874.0
2019-04-24 12:30:00	SPY	ETF	292.735	292.78	292.36	292.41	1673667.0
2019-04-24 13:00:00	SPY	ETF	292.4	292.51	292.07	292.465	2349483.0
2019-04-24 13:30:00	SPY	ETF	292.46	292.58	292.41	292.425	1347400.0
2019-04-24 14:00:00	SPY	ETF	292.425	292.64	292.35	292.47	1603185.0
2019-04-24 14:30:00	SPY	ETF	292.47	292.81	292.43	292.745	1851707.0
2019-04-24 15:00:00	SPY	ETF	292.75	292.85	292.69	292.73	2673159.0
2019-04-24 15:30:00	SPY	ETF	292.73	292.89	292.17	292.23	9247944.0
2019-04-24 16:00:00	SPY	ETF	292.22	292.57	292.17	292.24	7772698.0
2019-04-24 16:30:00	SPY	ETF	292.24	292.33	292.0	292.05	394667.0
2019-04-24 17:00:00	SPY	ETF	292.06	292.37	292.05	292.35	719143.0
2019-04-24 17:30:00	SPY	ETF	292.32	292.38	292.28	292.28	765053.0
2019-04-24 18:00:00	SPY	ETF	292.27	292.48	292.18	292.44	132386.0
2019-04-24 18:30:00	SPY	ETF	292.43	292.44	292.39	292.39	10104.0
2019-04-24 19:00:00	SPY	ETF	292.39	292.44	292.39	292.44	10240.0
2019-04-24 19:30:00	SPY	ETF	292.43	292.47	292.41	292.46	18090.0
2019-04-24 04:00:00	QQQ	ETF	190.08	190.19	190.07	190.19	8050.0
2019-04-24 04:30:00	QQQ	ETF	190.16	190.22	190.15	190.22	2460.0
2019-04-24 05:00:00	QQQ	ETF	190.26	190.38	190.26	190.38	1900.0
2019-04-24 05:30:00	QQQ	ETF	190.38	190.48	190.37	190.48	7709.0
2019-04-24 06:00:00	QQQ	ETF	190.54	190.6	190.52	190.58	14774.0
2019-04-24 06:30:00	QQQ	ETF	190.52	190.57	190.47	190.54	7293.0
2019-04-24 07:00:00	QQQ	ETF	190.55	190.56	190.42	190.5	38359.0
2019-04-24 07:30:00	QQQ	ETF	190.47	190.57	190.44	190.54	35638.0
2019-04-24 08:00:00	QQQ	ETF	190.5299	190.72	190.4599	190.63	48333.0
2019-04-24 08:30:00	QQQ	ETF	190.62	190.64	190.47	190.57	36681.0
2019-04-24 09:00:00	QQQ	ETF	190.48	190.54	190.39	190.44	23227.0
2019-04-24 09:30:00	QQQ	ETF	190.44	190.64	189.89	190.19	3047302.0
2019-04-24 10:00:00	QQQ	ETF	190.19	190.48	190.025	190.4101	1746514.0
2019-04-24 10:30:00	QQQ	ETF	190.42	190.63	190.205	190.62	1409210.0
2019-04-24 11:00:00	QQQ	ETF	190.62	190.71	190.4709	190.5	723459.0
2019-04-24 11:30:00	QQQ	ETF	190.51	190.69	190.1899	190.2	671903.0
2019-04-24 12:00:00	QQQ	ETF	190.21	190.26	190.05	190.19	680244.0
2019-04-24 12:30:00	QQQ	ETF	190.2	190.2079	189.795	189.84	596957.0

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

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