PREVIEW / etf_30min / 2019-11-08

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-08.parquet
  size:    509 KB
  rows:    17,703

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-11-08 04:00:00	SPY	ETF	308.04	308.04	307.9	307.9	1570.0
2019-11-08 04:30:00	SPY	ETF	307.95	308.03	307.95	308.03	2374.0
2019-11-08 05:00:00	SPY	ETF	308.06	308.11	308.03	308.11	1300.0
2019-11-08 05:30:00	SPY	ETF	308.16	308.21	308.14	308.18	4440.0
2019-11-08 06:00:00	SPY	ETF	308.17	308.33	308.14	308.26	5740.0
2019-11-08 06:30:00	SPY	ETF	308.28	308.3	308.14	308.26	10608.0
2019-11-08 07:00:00	SPY	ETF	308.23	308.58	308.18	308.5	44925.0
2019-11-08 07:30:00	SPY	ETF	308.41	308.43	307.94	308.05	72776.0
2019-11-08 08:00:00	SPY	ETF	308.05	308.46	307.56	308.06	105956.0
2019-11-08 08:30:00	SPY	ETF	308.05	308.11	307.94	308.08	56348.0
2019-11-08 09:00:00	SPY	ETF	308.1	308.15	307.78	307.81	98885.0
2019-11-08 09:30:00	SPY	ETF	307.8	308.29	307.18	307.32	5249311.0
2019-11-08 10:00:00	SPY	ETF	307.33	308.01	307.03	308.01	4623213.0
2019-11-08 10:30:00	SPY	ETF	308.01	308.18	307.89	308.11	1762954.0
2019-11-08 11:00:00	SPY	ETF	308.11	308.265	307.76	307.86	2266898.0
2019-11-08 11:30:00	SPY	ETF	307.85	308.29	307.82	308.26	1952800.0
2019-11-08 12:00:00	SPY	ETF	308.26	308.42	308.22	308.3301	1160460.0
2019-11-08 12:30:00	SPY	ETF	308.33	308.44	308.2	308.31	1281266.0
2019-11-08 13:00:00	SPY	ETF	308.31	308.35	308.13	308.2373	1710872.0
2019-11-08 13:30:00	SPY	ETF	308.23	308.31	308.09	308.1	4295051.0
2019-11-08 14:00:00	SPY	ETF	308.1	308.18	308.02	308.05	1277689.0
2019-11-08 14:30:00	SPY	ETF	308.055	308.24	308.04	308.225	1101131.0
2019-11-08 15:00:00	SPY	ETF	308.22	308.6	308.21	308.575	2972781.0
2019-11-08 15:30:00	SPY	ETF	308.58	308.97	308.49	308.97	9459452.0
2019-11-08 16:00:00	SPY	ETF	308.98	309.06	308.79	308.79	7340204.0
2019-11-08 16:30:00	SPY	ETF	308.8	308.95	308.8	308.94	888906.0
2019-11-08 17:00:00	SPY	ETF	308.85	308.98	308.85	308.92	145874.0
2019-11-08 17:30:00	SPY	ETF	308.9	308.94	308.9	308.91	8069.0
2019-11-08 18:00:00	SPY	ETF	308.93	308.96	308.91	308.96	4178.0
2019-11-08 18:30:00	SPY	ETF	308.94	308.96	308.94	308.94	2150.0
2019-11-08 19:00:00	SPY	ETF	308.94	308.99	308.94	308.99	5062.0
2019-11-08 19:30:00	SPY	ETF	308.98	309.09	308.96	309.09	19018.0
2019-11-08 04:00:00	QQQ	ETF	200.15	200.18	199.99	200.04	4300.0
2019-11-08 04:30:00	QQQ	ETF	200.06	200.18	200.06	200.18	2068.0
2019-11-08 05:00:00	QQQ	ETF	200.19	200.24	200.19	200.24	1300.0
2019-11-08 05:30:00	QQQ	ETF	200.3	200.32	200.22	200.26	8896.0
2019-11-08 06:00:00	QQQ	ETF	200.34	200.39	200.25	200.35	5668.0
2019-11-08 06:30:00	QQQ	ETF	200.34	200.36	200.25	200.3	14890.0
2019-11-08 07:00:00	QQQ	ETF	200.3	200.63	200.27	200.5	33240.0
2019-11-08 07:30:00	QQQ	ETF	200.5	200.5	200.05	200.14	18959.0
2019-11-08 08:00:00	QQQ	ETF	200.27	200.55	199.7	200.12	52250.0
2019-11-08 08:30:00	QQQ	ETF	200.13	200.21	200.05	200.17	22099.0
2019-11-08 09:00:00	QQQ	ETF	200.14	200.23	199.98	200.05	39830.0
2019-11-08 09:30:00	QQQ	ETF	200.03	200.58	199.85	199.92	2178148.0
2019-11-08 10:00:00	QQQ	ETF	199.93	200.37	199.54	200.32	1903016.0
2019-11-08 10:30:00	QQQ	ETF	200.35	200.7	200.3	200.61	757375.0
2019-11-08 11:00:00	QQQ	ETF	200.61	200.8467	200.3439	200.43	809763.0
2019-11-08 11:30:00	QQQ	ETF	200.42	200.77	200.4	200.68	482631.0
2019-11-08 12:00:00	QQQ	ETF	200.68	200.81	200.6649	200.78	457969.0
2019-11-08 12:30:00	QQQ	ETF	200.77	200.91	200.6393	200.72	390908.0

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

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