PREVIEW / etf_30min / 2019-09-04

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-04.parquet
  size:    512 KB
  rows:    17,811

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-09-04 04:00:00	SPY	ETF	293.51	293.72	293.24	293.38	23706.0
2019-09-04 04:30:00	SPY	ETF	293.33	293.46	293.29	293.46	5655.0
2019-09-04 05:00:00	SPY	ETF	293.47	293.6	293.35	293.42	12824.0
2019-09-04 05:30:00	SPY	ETF	293.3	293.31	293.1	293.13	7570.0
2019-09-04 06:00:00	SPY	ETF	293.07	293.2	292.97	293.06	8235.0
2019-09-04 06:30:00	SPY	ETF	293.04	293.04	292.83	293.0	33369.0
2019-09-04 07:00:00	SPY	ETF	292.98	293.12	292.88	292.95	142979.0
2019-09-04 07:30:00	SPY	ETF	293.0	293.34	293.0	293.24	335860.0
2019-09-04 08:00:00	SPY	ETF	293.1799	293.45	291.59	293.3	191064.0
2019-09-04 08:30:00	SPY	ETF	293.35	293.4799	293.25	293.35	254937.0
2019-09-04 09:00:00	SPY	ETF	293.3	293.48	293.06	293.14	563783.0
2019-09-04 09:30:00	SPY	ETF	293.14	293.39	292.8027	292.95	6610608.0
2019-09-04 10:00:00	SPY	ETF	292.9415	293.15	292.31	292.7	3630565.0
2019-09-04 10:30:00	SPY	ETF	292.7	292.9	292.49	292.85	2048345.0
2019-09-04 11:00:00	SPY	ETF	292.86	293.25	292.68	293.21	2583345.0
2019-09-04 11:30:00	SPY	ETF	293.22	293.51	293.16	293.45	2456394.0
2019-09-04 12:00:00	SPY	ETF	293.44	293.51	293.2	293.26	2596608.0
2019-09-04 12:30:00	SPY	ETF	293.27	293.6	293.21	293.53	2229590.0
2019-09-04 13:00:00	SPY	ETF	293.52	293.6	293.32	293.53	1378876.0
2019-09-04 13:30:00	SPY	ETF	293.54	293.59	293.13	293.195	1643041.0
2019-09-04 14:00:00	SPY	ETF	293.2	293.41	293.05	293.4	1578323.0
2019-09-04 14:30:00	SPY	ETF	293.39	293.69	293.36	293.56	1759282.0
2019-09-04 15:00:00	SPY	ETF	293.56	293.89	293.56	293.75	2699545.0
2019-09-04 15:30:00	SPY	ETF	293.75	294.055	293.74	293.97	8926800.0
2019-09-04 16:00:00	SPY	ETF	293.98	294.05	293.88	294.03	2981861.0
2019-09-04 16:30:00	SPY	ETF	294.04	294.12	293.96	293.96	333064.0
2019-09-04 17:00:00	SPY	ETF	293.95	294.04	293.91	293.96	227564.0
2019-09-04 17:30:00	SPY	ETF	293.97	294.05	293.84	293.9	204134.0
2019-09-04 18:00:00	SPY	ETF	293.93	294.06	293.84	294.01	140681.0
2019-09-04 18:30:00	SPY	ETF	294.0	294.1	293.99	293.99	27573.0
2019-09-04 19:00:00	SPY	ETF	294.04	294.04	293.95	293.95	4075.0
2019-09-04 19:30:00	SPY	ETF	293.94	294.0	293.87	294.0	13155.0
2019-09-04 04:00:00	QQQ	ETF	188.28	188.5	188.12	188.28	37878.0
2019-09-04 04:30:00	QQQ	ETF	188.2	188.25	188.13	188.19	7486.0
2019-09-04 05:00:00	QQQ	ETF	188.26	188.38	188.14	188.16	14168.0
2019-09-04 05:30:00	QQQ	ETF	188.1	188.1	187.9	187.93	7000.0
2019-09-04 06:00:00	QQQ	ETF	187.8	187.86	187.66	187.72	14071.0
2019-09-04 06:30:00	QQQ	ETF	187.71	187.71	187.53	187.6	17412.0
2019-09-04 07:00:00	QQQ	ETF	187.6	187.64	187.45	187.48	51046.0
2019-09-04 07:30:00	QQQ	ETF	187.48	187.84	187.48	187.75	59312.0
2019-09-04 08:00:00	QQQ	ETF	187.55	188.48	186.75	187.6	112090.0
2019-09-04 08:30:00	QQQ	ETF	187.64	187.8	187.5	187.6	149553.0
2019-09-04 09:00:00	QQQ	ETF	187.6	187.65	187.37	187.41	590012.0
2019-09-04 09:30:00	QQQ	ETF	187.42	187.895	187.3	187.44	3007604.0
2019-09-04 10:00:00	QQQ	ETF	187.44	187.61	186.9	187.21	1817115.0
2019-09-04 10:30:00	QQQ	ETF	187.24	187.37	187.11	187.33	935128.0
2019-09-04 11:00:00	QQQ	ETF	187.34	187.6	187.29	187.58	1102834.0
2019-09-04 11:30:00	QQQ	ETF	187.58	187.84	187.56	187.785	1154272.0
2019-09-04 12:00:00	QQQ	ETF	187.78	187.87	187.53	187.64	813250.0
2019-09-04 12:30:00	QQQ	ETF	187.65	188.14	187.585	188.08	1009951.0

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

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