PREVIEW / etf_30min / 2019-10-28

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-28.parquet
  size:    514 KB
  rows:    17,955

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-10-28 04:00:00	SPY	ETF	302.14	302.47	302.11	302.13	10130.0
2019-10-28 04:30:00	SPY	ETF	302.13	302.2	302.13	302.15	3549.0
2019-10-28 05:00:00	SPY	ETF	302.08	302.1	302.0	302.09	5200.0
2019-10-28 05:30:00	SPY	ETF	302.1	302.19	302.06	302.19	4800.0
2019-10-28 06:00:00	SPY	ETF	302.17	302.27	302.16	302.26	5565.0
2019-10-28 06:30:00	SPY	ETF	302.3	302.4	302.22	302.29	17985.0
2019-10-28 07:00:00	SPY	ETF	302.25	302.53	302.25	302.51	27763.0
2019-10-28 07:30:00	SPY	ETF	302.49	302.49	302.42	302.44	16591.0
2019-10-28 08:00:00	SPY	ETF	302.46	302.56	302.13	302.44	47703.0
2019-10-28 08:30:00	SPY	ETF	302.43	302.96	302.43	302.94	198025.0
2019-10-28 09:00:00	SPY	ETF	302.94	303.04	302.78	302.93	245863.0
2019-10-28 09:30:00	SPY	ETF	302.94	303.66	302.91	303.51	4998402.0
2019-10-28 10:00:00	SPY	ETF	303.52	303.72	303.41	303.6	2310766.0
2019-10-28 10:30:00	SPY	ETF	303.6	303.85	303.27	303.3336	2811581.0
2019-10-28 11:00:00	SPY	ETF	303.3415	303.47	303.11	303.28	1954645.0
2019-10-28 11:30:00	SPY	ETF	303.29	303.45	303.05	303.29	2132896.0
2019-10-28 12:00:00	SPY	ETF	303.3076	303.54	303.17	303.41	1319056.0
2019-10-28 12:30:00	SPY	ETF	303.41	303.43	303.15	303.19	1257608.0
2019-10-28 13:00:00	SPY	ETF	303.2	303.46	303.17	303.41	1224196.0
2019-10-28 13:30:00	SPY	ETF	303.4	303.53	303.28	303.44	1948244.0
2019-10-28 14:00:00	SPY	ETF	303.43	303.57	303.37	303.46	1522954.0
2019-10-28 14:30:00	SPY	ETF	303.46	303.61	303.41	303.51	3028887.0
2019-10-28 15:00:00	SPY	ETF	303.5	303.695	303.43	303.67	3090816.0
2019-10-28 15:30:00	SPY	ETF	303.66	303.68	303.26	303.36	8023724.0
2019-10-28 16:00:00	SPY	ETF	303.35	303.4484	303.1	303.21	4078341.0
2019-10-28 16:30:00	SPY	ETF	303.21	303.5	303.17	303.29	317889.0
2019-10-28 17:00:00	SPY	ETF	303.36	303.36	303.25	303.26	18052.0
2019-10-28 17:30:00	SPY	ETF	303.22	303.35	303.22	303.35	14024.0
2019-10-28 18:00:00	SPY	ETF	303.39	303.39	303.26	303.32	4208.0
2019-10-28 18:30:00	SPY	ETF	303.26	303.34	303.25	303.31	38422.0
2019-10-28 19:00:00	SPY	ETF	303.31	303.4	303.26	303.4	3262.0
2019-10-28 19:30:00	SPY	ETF	303.4	303.51	303.38	303.5	17289.0
2019-10-28 04:00:00	QQQ	ETF	196.08	196.57	196.04	196.26	5925.0
2019-10-28 04:30:00	QQQ	ETF	196.27	196.29	196.22	196.23	4800.0
2019-10-28 05:00:00	QQQ	ETF	196.2	196.2	196.09	196.12	13400.0
2019-10-28 05:30:00	QQQ	ETF	196.07	196.19	196.07	196.19	2465.0
2019-10-28 06:00:00	QQQ	ETF	196.18	196.24	196.15	196.19	11551.0
2019-10-28 06:30:00	QQQ	ETF	196.2	196.25	196.13	196.16	10550.0
2019-10-28 07:00:00	QQQ	ETF	196.14	196.44	196.14	196.38	46206.0
2019-10-28 07:30:00	QQQ	ETF	196.37	196.37	196.27	196.32	41966.0
2019-10-28 08:00:00	QQQ	ETF	196.32	196.45	195.64	196.35	76417.0
2019-10-28 08:30:00	QQQ	ETF	196.33	196.65	196.33	196.64	256985.0
2019-10-28 09:00:00	QQQ	ETF	196.6	196.74	196.53	196.56	144918.0
2019-10-28 09:30:00	QQQ	ETF	196.56	197.15	196.55	196.99	2088180.0
2019-10-28 10:00:00	QQQ	ETF	196.99	197.3799	196.91	197.24	1135313.0
2019-10-28 10:30:00	QQQ	ETF	197.24	197.4199	197.07	197.2	897961.0
2019-10-28 11:00:00	QQQ	ETF	197.205	197.39	197.12	197.2981	463687.0
2019-10-28 11:30:00	QQQ	ETF	197.31	197.57	197.18	197.4525	1072358.0
2019-10-28 12:00:00	QQQ	ETF	197.46	197.68	197.31	197.58	681255.0
2019-10-28 12:30:00	QQQ	ETF	197.58	197.6062	197.3517	197.42	442797.0

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

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