PREVIEW / etf_1min / 2020-01-22

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-01-22.parquet
  size:    3.4 MB
  rows:    175,642

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-22 04:00:00	SPY	ETF	332.32	332.32	332.13	332.31	128736.0
2020-01-22 04:01:00	SPY	ETF	332.24	332.32	332.24	332.32	747.0
2020-01-22 04:02:00	SPY	ETF	332.3	332.39	332.29	332.39	2490.0
2020-01-22 04:03:00	SPY	ETF	332.35	332.35	332.27	332.27	380.0
2020-01-22 04:04:00	SPY	ETF	332.38	332.38	332.38	332.38	800.0
2020-01-22 04:06:00	SPY	ETF	332.44	332.44	332.41	332.41	700.0
2020-01-22 04:07:00	SPY	ETF	332.41	332.41	332.4	332.4	1015.0
2020-01-22 04:08:00	SPY	ETF	332.41	332.41	332.41	332.41	1020.0
2020-01-22 04:10:00	SPY	ETF	332.45	332.45	332.4	332.4	2100.0
2020-01-22 04:15:00	SPY	ETF	332.2	332.2	332.15	332.15	330.0
2020-01-22 04:23:00	SPY	ETF	332.32	332.32	332.32	332.32	100.0
2020-01-22 04:30:00	SPY	ETF	332.18	332.18	332.17	332.17	1948.0
2020-01-22 04:34:00	SPY	ETF	332.19	332.19	332.19	332.19	153.0
2020-01-22 04:38:00	SPY	ETF	332.25	332.25	332.25	332.25	300.0
2020-01-22 04:39:00	SPY	ETF	332.23	332.23	332.23	332.23	300.0
2020-01-22 04:40:00	SPY	ETF	332.21	332.25	332.21	332.25	3631.0
2020-01-22 04:41:00	SPY	ETF	332.28	332.28	332.27	332.27	501.0
2020-01-22 04:48:00	SPY	ETF	332.24	332.24	332.24	332.24	377.0
2020-01-22 04:50:00	SPY	ETF	332.36	332.36	332.34	332.34	703.0
2020-01-22 04:51:00	SPY	ETF	332.37	332.37	332.37	332.37	100.0
2020-01-22 04:55:00	SPY	ETF	332.4	332.4	332.4	332.4	701.0
2020-01-22 04:59:00	SPY	ETF	332.32	332.32	332.32	332.32	100.0
2020-01-22 05:01:00	SPY	ETF	332.3	332.3	332.3	332.3	360.0
2020-01-22 05:10:00	SPY	ETF	332.36	332.37	332.36	332.37	1300.0
2020-01-22 05:11:00	SPY	ETF	332.3	332.3	332.3	332.3	300.0
2020-01-22 05:12:00	SPY	ETF	332.4	332.4	332.4	332.4	300.0
2020-01-22 05:13:00	SPY	ETF	332.34	332.34	332.34	332.34	100.0
2020-01-22 05:14:00	SPY	ETF	332.34	332.34	332.34	332.34	400.0
2020-01-22 05:15:00	SPY	ETF	332.34	332.34	332.33	332.33	1560.0
2020-01-22 05:16:00	SPY	ETF	332.33	332.33	332.33	332.33	200.0
2020-01-22 05:17:00	SPY	ETF	332.31	332.31	332.31	332.31	577.0
2020-01-22 05:18:00	SPY	ETF	332.29	332.31	332.29	332.31	330.0
2020-01-22 05:20:00	SPY	ETF	332.34	332.34	332.34	332.34	400.0
2020-01-22 05:23:00	SPY	ETF	332.36	332.36	332.36	332.36	1010.0
2020-01-22 05:25:00	SPY	ETF	332.37	332.37	332.37	332.37	100.0
2020-01-22 05:26:00	SPY	ETF	332.39	332.4	332.39	332.4	1400.0
2020-01-22 05:27:00	SPY	ETF	332.38	332.38	332.38	332.38	100.0
2020-01-22 05:28:00	SPY	ETF	332.38	332.38	332.38	332.38	300.0
2020-01-22 05:29:00	SPY	ETF	332.36	332.36	332.36	332.36	500.0
2020-01-22 05:32:00	SPY	ETF	332.38	332.38	332.38	332.38	1100.0
2020-01-22 05:34:00	SPY	ETF	332.4	332.4	332.4	332.4	500.0
2020-01-22 05:36:00	SPY	ETF	332.4	332.4	332.4	332.4	100.0
2020-01-22 05:37:00	SPY	ETF	332.44	332.44	332.44	332.44	564.0
2020-01-22 05:38:00	SPY	ETF	332.45	332.45	332.45	332.45	100.0
2020-01-22 05:39:00	SPY	ETF	332.44	332.44	332.44	332.44	200.0
2020-01-22 05:43:00	SPY	ETF	332.37	332.37	332.37	332.37	185.0
2020-01-22 05:44:00	SPY	ETF	332.37	332.37	332.37	332.37	310.0
2020-01-22 05:45:00	SPY	ETF	332.35	332.35	332.35	332.35	110.0
2020-01-22 05:46:00	SPY	ETF	332.34	332.34	332.34	332.34	120.0
2020-01-22 05:52:00	SPY	ETF	332.37	332.37	332.37	332.37	174.0

> showing 50 of 175,642 rows — these rows as CSV

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