PREVIEW / etf_1min / 2020-01-31

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-01-31.parquet
  size:    4.0 MB
  rows:    199,915

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
2020-01-31 04:00:00	SPY	ETF	327.33	327.34	327.21	327.34	946.0
2020-01-31 04:01:00	SPY	ETF	327.48	327.48	327.48	327.48	149.0
2020-01-31 04:02:00	SPY	ETF	327.44	327.44	327.44	327.44	160.0
2020-01-31 04:05:00	SPY	ETF	327.39	327.39	327.39	327.39	101.0
2020-01-31 04:06:00	SPY	ETF	327.29	327.29	327.29	327.29	789.0
2020-01-31 04:07:00	SPY	ETF	327.29	327.29	327.29	327.29	200.0
2020-01-31 04:09:00	SPY	ETF	327.4	327.4	327.38	327.38	300.0
2020-01-31 04:10:00	SPY	ETF	327.27	327.27	327.27	327.27	200.0
2020-01-31 04:13:00	SPY	ETF	327.33	327.33	327.33	327.33	350.0
2020-01-31 04:14:00	SPY	ETF	327.36	327.36	327.28	327.28	230.0
2020-01-31 04:15:00	SPY	ETF	327.28	327.28	327.28	327.28	100.0
2020-01-31 04:18:00	SPY	ETF	327.42	327.42	327.42	327.42	270.0
2020-01-31 04:19:00	SPY	ETF	327.42	327.45	327.42	327.45	303.0
2020-01-31 04:20:00	SPY	ETF	327.42	327.42	327.42	327.42	100.0
2020-01-31 04:22:00	SPY	ETF	327.42	327.42	327.42	327.42	321.0
2020-01-31 04:26:00	SPY	ETF	327.46	327.46	327.42	327.42	477.0
2020-01-31 04:28:00	SPY	ETF	327.42	327.42	327.42	327.42	492.0
2020-01-31 04:30:00	SPY	ETF	327.48	327.48	327.48	327.48	462.0
2020-01-31 04:31:00	SPY	ETF	327.44	327.44	327.44	327.44	325.0
2020-01-31 04:32:00	SPY	ETF	327.43	327.43	327.4	327.4	477.0
2020-01-31 04:33:00	SPY	ETF	327.32	327.32	327.28	327.28	1077.0
2020-01-31 04:34:00	SPY	ETF	327.26	327.26	327.23	327.23	1300.0
2020-01-31 04:35:00	SPY	ETF	327.16	327.16	327.16	327.16	500.0
2020-01-31 04:37:00	SPY	ETF	327.16	327.16	327.1	327.1	4295.0
2020-01-31 04:38:00	SPY	ETF	327.02	327.03	327.0	327.0	2107.0
2020-01-31 04:39:00	SPY	ETF	327.0	327.0	326.94	326.94	2581.0
2020-01-31 04:40:00	SPY	ETF	326.95	326.98	326.95	326.98	631.0
2020-01-31 04:41:00	SPY	ETF	327.08	327.08	327.08	327.08	601.0
2020-01-31 04:44:00	SPY	ETF	327.07	327.07	327.07	327.07	104.0
2020-01-31 04:48:00	SPY	ETF	327.11	327.11	327.11	327.11	701.0
2020-01-31 04:49:00	SPY	ETF	327.12	327.16	327.12	327.16	1010.0
2020-01-31 04:50:00	SPY	ETF	327.16	327.16	327.16	327.16	101.0
2020-01-31 04:53:00	SPY	ETF	327.14	327.14	327.14	327.14	500.0
2020-01-31 04:59:00	SPY	ETF	327.13	327.13	327.13	327.13	434.0
2020-01-31 05:00:00	SPY	ETF	327.11	327.11	327.11	327.11	1434.0
2020-01-31 05:02:00	SPY	ETF	326.89	327.0	326.89	327.0	4101.0
2020-01-31 05:04:00	SPY	ETF	327.16	327.16	327.16	327.16	1000.0
2020-01-31 05:06:00	SPY	ETF	327.16	327.16	327.16	327.16	301.0
2020-01-31 05:07:00	SPY	ETF	327.26	327.26	327.26	327.26	534.0
2020-01-31 05:08:00	SPY	ETF	327.26	327.26	327.26	327.26	311.0
2020-01-31 05:10:00	SPY	ETF	327.15	327.16	327.06	327.06	810.0
2020-01-31 05:11:00	SPY	ETF	327.04	327.09	326.98	326.99	2605.0
2020-01-31 05:12:00	SPY	ETF	327.01	327.01	327.01	327.01	1900.0
2020-01-31 05:13:00	SPY	ETF	326.9	326.9	326.85	326.85	203.0
2020-01-31 05:14:00	SPY	ETF	326.92	326.96	326.92	326.96	750.0
2020-01-31 05:15:00	SPY	ETF	326.98	326.98	326.98	326.98	377.0
2020-01-31 05:16:00	SPY	ETF	326.97	326.97	326.97	326.97	1000.0
2020-01-31 05:19:00	SPY	ETF	326.89	326.89	326.89	326.89	100.0
2020-01-31 05:20:00	SPY	ETF	326.83	326.85	326.81	326.83	1429.0
2020-01-31 05:21:00	SPY	ETF	326.83	326.83	326.76	326.76	3554.0

> showing 50 of 199,915 rows — these rows as CSV

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