PREVIEW / etf_1min / 2019-08-12

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-08-12.parquet
  size:    3.1 MB
  rows:    161,217

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-08-12 04:01:00	SPY	ETF	292.29	292.29	292.29	292.29	1735.0
2019-08-12 04:02:00	SPY	ETF	292.3	292.3	292.24	292.24	1000.0
2019-08-12 04:03:00	SPY	ETF	292.19	292.19	292.19	292.19	869.0
2019-08-12 04:04:00	SPY	ETF	292.06	292.06	292.06	292.06	100.0
2019-08-12 04:05:00	SPY	ETF	291.97	291.97	291.97	291.97	503.0
2019-08-12 04:06:00	SPY	ETF	292.01	292.01	291.9	291.9	374.0
2019-08-12 04:07:00	SPY	ETF	291.85	291.86	291.75	291.75	5125.0
2019-08-12 04:08:00	SPY	ETF	291.75	291.75	291.43	291.43	16778.0
2019-08-12 04:09:00	SPY	ETF	291.5	291.5	291.44	291.44	1350.0
2019-08-12 04:10:00	SPY	ETF	291.49	291.49	291.36	291.36	500.0
2019-08-12 04:11:00	SPY	ETF	291.44	291.51	291.44	291.51	800.0
2019-08-12 04:12:00	SPY	ETF	291.46	291.49	291.46	291.49	409.0
2019-08-12 04:13:00	SPY	ETF	291.48	291.54	291.48	291.54	475.0
2019-08-12 04:14:00	SPY	ETF	291.51	291.51	291.51	291.51	100.0
2019-08-12 04:16:00	SPY	ETF	291.45	291.45	291.45	291.45	115.0
2019-08-12 04:20:00	SPY	ETF	291.31	291.31	291.31	291.31	2000.0
2019-08-12 04:21:00	SPY	ETF	291.29	291.29	291.29	291.29	2080.0
2019-08-12 04:22:00	SPY	ETF	291.18	291.18	291.18	291.18	200.0
2019-08-12 04:23:00	SPY	ETF	291.17	291.17	291.09	291.09	1634.0
2019-08-12 04:24:00	SPY	ETF	291.26	291.26	291.26	291.26	100.0
2019-08-12 04:25:00	SPY	ETF	291.19	291.19	291.01	291.06	725.0
2019-08-12 04:26:00	SPY	ETF	291.12	291.14	291.12	291.14	459.0
2019-08-12 04:33:00	SPY	ETF	290.83	290.83	290.83	290.83	2540.0
2019-08-12 04:34:00	SPY	ETF	290.85	290.85	290.85	290.85	240.0
2019-08-12 04:35:00	SPY	ETF	291.0	291.0	291.0	291.0	680.0
2019-08-12 04:36:00	SPY	ETF	290.96	290.96	290.96	290.96	1001.0
2019-08-12 04:40:00	SPY	ETF	290.98	290.98	290.98	290.98	125.0
2019-08-12 04:41:00	SPY	ETF	290.93	290.93	290.93	290.93	400.0
2019-08-12 04:43:00	SPY	ETF	290.78	290.78	290.62	290.62	2609.0
2019-08-12 04:44:00	SPY	ETF	290.65	290.7	290.65	290.7	300.0
2019-08-12 04:46:00	SPY	ETF	290.7	290.7	290.7	290.7	200.0
2019-08-12 04:47:00	SPY	ETF	290.73	290.73	290.73	290.73	150.0
2019-08-12 04:48:00	SPY	ETF	290.67	290.67	290.67	290.67	100.0
2019-08-12 04:50:00	SPY	ETF	290.49	290.5	290.49	290.5	300.0
2019-08-12 04:53:00	SPY	ETF	290.26	290.26	290.26	290.26	105.0
2019-08-12 04:57:00	SPY	ETF	290.5	290.53	290.5	290.53	500.0
2019-08-12 04:58:00	SPY	ETF	290.5	290.53	290.5	290.53	3000.0
2019-08-12 04:59:00	SPY	ETF	290.54	290.54	290.54	290.54	100.0
2019-08-12 05:00:00	SPY	ETF	290.6	290.6	290.5	290.5	300.0
2019-08-12 05:01:00	SPY	ETF	290.45	290.45	290.27	290.27	1104.0
2019-08-12 05:02:00	SPY	ETF	290.35	290.35	290.3	290.35	1200.0
2019-08-12 05:03:00	SPY	ETF	290.3	290.3	290.3	290.3	100.0
2019-08-12 05:05:00	SPY	ETF	290.38	290.45	290.38	290.45	2575.0
2019-08-12 05:06:00	SPY	ETF	290.42	290.42	290.42	290.42	580.0
2019-08-12 05:07:00	SPY	ETF	290.46	290.46	290.46	290.46	151.0
2019-08-12 05:08:00	SPY	ETF	290.46	290.46	290.46	290.46	151.0
2019-08-12 05:09:00	SPY	ETF	290.5	290.5	290.5	290.5	300.0
2019-08-12 05:10:00	SPY	ETF	290.48	290.48	290.48	290.48	100.0
2019-08-12 05:12:00	SPY	ETF	290.45	290.45	290.45	290.45	325.0
2019-08-12 05:13:00	SPY	ETF	290.4	290.4	290.4	290.4	100.0

> showing 50 of 161,217 rows — these rows as CSV

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