PREVIEW / etf_30min / 2018-02-28

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-28.parquet
  size:    475 KB
  rows:    16,333

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
2018-02-28 04:00:00	SPY	ETF	275.32	275.35	275.09	275.25	2577.0
2018-02-28 04:30:00	SPY	ETF	275.3	275.42	275.23	275.3	5120.0
2018-02-28 05:00:00	SPY	ETF	275.44	275.46	275.28	275.28	3415.0
2018-02-28 05:30:00	SPY	ETF	275.29	275.29	274.84	274.94	8013.0
2018-02-28 06:00:00	SPY	ETF	275.05	275.2	275.05	275.1	15800.0
2018-02-28 06:30:00	SPY	ETF	275.05	275.05	274.65	274.75	45262.0
2018-02-28 07:00:00	SPY	ETF	274.72	274.99	274.58	274.58	125087.0
2018-02-28 07:30:00	SPY	ETF	274.6	275.02	274.58	274.99	82151.0
2018-02-28 08:00:00	SPY	ETF	274.98	275.28	274.5	274.87	273038.0
2018-02-28 08:30:00	SPY	ETF	274.91	275.46	274.89	275.19	406943.0
2018-02-28 09:00:00	SPY	ETF	275.27	275.71	275.26	275.64	678484.0
2018-02-28 09:30:00	SPY	ETF	275.68	276.17	274.97	276.17	6750602.0
2018-02-28 10:00:00	SPY	ETF	276.17	276.19	275.52	275.99	3880503.0
2018-02-28 10:30:00	SPY	ETF	275.99	276.12	274.4	274.82	5624136.0
2018-02-28 11:00:00	SPY	ETF	274.83	274.96	274.05	274.83	5618154.0
2018-02-28 11:30:00	SPY	ETF	274.82	274.915	273.78	274.605	5860134.0
2018-02-28 12:00:00	SPY	ETF	274.58	274.89	274.3	274.44	3461950.0
2018-02-28 12:30:00	SPY	ETF	274.42	275.42	274.2	275.16	4301358.0
2018-02-28 13:00:00	SPY	ETF	275.15	275.37	274.79	275.2	3263918.0
2018-02-28 13:30:00	SPY	ETF	275.19	275.58	274.74	275.57	3661021.0
2018-02-28 14:00:00	SPY	ETF	275.57	275.85	275.42	275.45	4542007.0
2018-02-28 14:30:00	SPY	ETF	275.46	275.48	273.79	273.9	6411593.0
2018-02-28 15:00:00	SPY	ETF	273.92	274.08	272.78	273.24	10700404.0
2018-02-28 15:30:00	SPY	ETF	273.241	273.61	271.31	271.33	26248837.0
2018-02-28 16:00:00	SPY	ETF	271.34	274.5281	271.25	271.94	15433809.0
2018-02-28 16:30:00	SPY	ETF	271.94	272.0	271.49	271.96	4485076.0
2018-02-28 17:00:00	SPY	ETF	271.95	274.4201	271.77	271.95	346910.0
2018-02-28 17:30:00	SPY	ETF	271.95	271.95	271.65	271.84	504854.0
2018-02-28 18:00:00	SPY	ETF	271.86	272.08	271.48	271.55	244719.0
2018-02-28 18:30:00	SPY	ETF	271.55	272.12	271.53	271.95	64668.0
2018-02-28 19:00:00	SPY	ETF	271.93	271.96	271.74	271.85	32896.0
2018-02-28 19:30:00	SPY	ETF	271.84	272.19	271.84	271.96	38634.0
2018-02-28 04:00:00	QQQ	ETF	168.67	168.79	168.67	168.78	13400.0
2018-02-28 04:30:00	QQQ	ETF	168.78	168.82	168.71	168.82	6516.0
2018-02-28 05:00:00	QQQ	ETF	168.79	168.83	168.74	168.78	1000.0
2018-02-28 05:30:00	QQQ	ETF	168.71	168.72	168.53	168.57	35700.0
2018-02-28 06:00:00	QQQ	ETF	168.67	168.76	168.67	168.75	5508.0
2018-02-28 06:30:00	QQQ	ETF	168.71	168.71	168.46	168.57	63429.0
2018-02-28 07:00:00	QQQ	ETF	168.54	168.7	168.48	168.48	32846.0
2018-02-28 07:30:00	QQQ	ETF	168.54	168.79	168.53	168.79	13794.0
2018-02-28 08:00:00	QQQ	ETF	168.79	168.96	168.32	168.87	137291.0
2018-02-28 08:30:00	QQQ	ETF	168.95	169.2	168.95	169.05	230397.0
2018-02-28 09:00:00	QQQ	ETF	169.12	169.27	169.09	169.21	97519.0
2018-02-28 09:30:00	QQQ	ETF	169.2	169.52	168.74	169.52	2648725.0
2018-02-28 10:00:00	QQQ	ETF	169.52	169.64	169.2	169.45	1806567.0
2018-02-28 10:30:00	QQQ	ETF	169.44	169.56	168.4	168.69	2254276.0
2018-02-28 11:00:00	QQQ	ETF	168.7	168.88	168.26	168.7936	2566363.0
2018-02-28 11:30:00	QQQ	ETF	168.79	168.86	167.92	168.537	2256816.0
2018-02-28 12:00:00	QQQ	ETF	168.53	168.7	168.31	168.455	949571.0
2018-02-28 12:30:00	QQQ	ETF	168.395	169.2293	168.3	169.12	1760712.0

> showing 50 of 16,333 rows — these rows as CSV

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