PREVIEW / etf_30min / 2019-07-11

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-11.parquet
  size:    499 KB
  rows:    17,442

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-07-11 04:00:00	SPY	ETF	299.26	299.36	299.26	299.27	1700.0
2019-07-11 04:30:00	SPY	ETF	299.24	299.24	299.24	299.24	100.0
2019-07-11 05:00:00	SPY	ETF	299.21	299.61	299.18	299.49	21762.0
2019-07-11 05:30:00	SPY	ETF	299.5	299.6	299.47	299.55	8205.0
2019-07-11 06:00:00	SPY	ETF	299.55	299.56	299.26	299.26	14040.0
2019-07-11 06:30:00	SPY	ETF	299.22	299.48	299.12	299.48	22163.0
2019-07-11 07:00:00	SPY	ETF	299.47	299.52	299.33	299.33	46597.0
2019-07-11 07:30:00	SPY	ETF	299.38	299.4	299.26	299.35	60242.0
2019-07-11 08:00:00	SPY	ETF	299.37	299.54	299.29	299.45	115003.0
2019-07-11 08:30:00	SPY	ETF	299.45	299.46	298.91	299.22	284816.0
2019-07-11 09:00:00	SPY	ETF	299.19	299.42	299.19	299.34	242765.0
2019-07-11 09:30:00	SPY	ETF	299.32	299.58	299.01	299.285	4782734.0
2019-07-11 10:00:00	SPY	ETF	299.3	299.46	298.79	298.87	3856143.0
2019-07-11 10:30:00	SPY	ETF	298.87	298.94	298.52	298.79	2776045.0
2019-07-11 11:00:00	SPY	ETF	298.78	299.39	298.7	299.31	3570691.0
2019-07-11 11:30:00	SPY	ETF	299.32	299.4999	299.24	299.44	2095830.0
2019-07-11 12:00:00	SPY	ETF	299.445	299.52	299.22	299.32	4537571.0
2019-07-11 12:30:00	SPY	ETF	299.315	299.38	299.19	299.34	1502616.0
2019-07-11 13:00:00	SPY	ETF	299.35	299.38	298.69	298.72	3005411.0
2019-07-11 13:30:00	SPY	ETF	298.7199	298.83	298.29	298.4965	5722307.0
2019-07-11 14:00:00	SPY	ETF	298.49	298.61	298.2	298.385	2220114.0
2019-07-11 14:30:00	SPY	ETF	298.39	298.84	298.35	298.7947	2051872.0
2019-07-11 15:00:00	SPY	ETF	298.795	298.88	298.71	298.75	1341182.0
2019-07-11 15:30:00	SPY	ETF	298.755	299.33	298.741	299.3	8115371.0
2019-07-11 16:00:00	SPY	ETF	299.29	299.46	299.24	299.37	3491773.0
2019-07-11 16:30:00	SPY	ETF	299.38	299.39	299.3	299.35	184545.0
2019-07-11 17:00:00	SPY	ETF	299.35	299.37	299.15	299.24	147229.0
2019-07-11 17:30:00	SPY	ETF	299.26	299.31	299.23	299.25	25597.0
2019-07-11 18:00:00	SPY	ETF	299.26	299.38	299.24	299.32	58823.0
2019-07-11 18:30:00	SPY	ETF	299.3	299.36	299.21	299.27	8948.0
2019-07-11 19:00:00	SPY	ETF	299.25	299.25	299.17	299.24	21719.0
2019-07-11 19:30:00	SPY	ETF	299.22	299.52	299.22	299.48	27758.0
2019-07-11 04:00:00	QQQ	ETF	193.06	193.15	193.04	193.08	8135.0
2019-07-11 04:30:00	QQQ	ETF	193.09	193.09	193.09	193.09	100.0
2019-07-11 05:00:00	QQQ	ETF	193.05	193.41	193.05	193.32	23002.0
2019-07-11 05:30:00	QQQ	ETF	193.38	193.4	193.3	193.4	6239.0
2019-07-11 06:00:00	QQQ	ETF	193.36	193.36	193.14	193.16	16433.0
2019-07-11 06:30:00	QQQ	ETF	192.99	193.24	192.98	193.24	10842.0
2019-07-11 07:00:00	QQQ	ETF	193.23	193.3	193.07	193.1	22310.0
2019-07-11 07:30:00	QQQ	ETF	193.12	193.12	192.98	193.12	44178.0
2019-07-11 08:00:00	QQQ	ETF	193.24	193.38	192.56	193.27	79659.0
2019-07-11 08:30:00	QQQ	ETF	193.2	193.2	192.59	192.91	194446.0
2019-07-11 09:00:00	QQQ	ETF	192.868	193.13	192.868	192.9	97665.0
2019-07-11 09:30:00	QQQ	ETF	192.89	193.14	192.67	193.06	2092815.0
2019-07-11 10:00:00	QQQ	ETF	193.08	193.26	192.69	192.77	2167108.0
2019-07-11 10:30:00	QQQ	ETF	192.77	192.835	192.46	192.78	1014948.0
2019-07-11 11:00:00	QQQ	ETF	192.77	193.24	192.7	193.16	1222874.0
2019-07-11 11:30:00	QQQ	ETF	193.16	193.28	193.04	193.22	863766.0
2019-07-11 12:00:00	QQQ	ETF	193.23	193.34	192.97	193.09	716345.0
2019-07-11 12:30:00	QQQ	ETF	193.09	193.2	193.01	193.12	510368.0

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

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