PREVIEW / etf_1min / 2019-11-18

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-11-18.parquet
  size:    3.1 MB
  rows:    159,826

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-11-18 04:00:00	SPY	ETF	312.13	312.13	312.13	312.13	573.0
2019-11-18 04:09:00	SPY	ETF	312.19	312.22	312.19	312.22	700.0
2019-11-18 04:10:00	SPY	ETF	312.17	312.17	312.17	312.17	100.0
2019-11-18 04:12:00	SPY	ETF	312.19	312.22	312.19	312.22	300.0
2019-11-18 04:23:00	SPY	ETF	312.25	312.29	312.25	312.29	1195.0
2019-11-18 04:24:00	SPY	ETF	312.27	312.27	312.27	312.27	300.0
2019-11-18 04:26:00	SPY	ETF	312.22	312.22	312.22	312.22	1000.0
2019-11-18 04:28:00	SPY	ETF	312.24	312.24	312.24	312.24	300.0
2019-11-18 04:29:00	SPY	ETF	312.17	312.17	312.17	312.17	505.0
2019-11-18 04:30:00	SPY	ETF	312.17	312.17	312.17	312.17	500.0
2019-11-18 04:36:00	SPY	ETF	312.22	312.22	312.22	312.22	300.0
2019-11-18 04:38:00	SPY	ETF	312.19	312.21	312.19	312.21	1575.0
2019-11-18 04:39:00	SPY	ETF	312.24	312.24	312.24	312.24	800.0
2019-11-18 04:40:00	SPY	ETF	312.24	312.24	312.24	312.24	400.0
2019-11-18 04:46:00	SPY	ETF	312.2	312.2	312.2	312.2	300.0
2019-11-18 04:59:00	SPY	ETF	312.24	312.24	312.24	312.24	200.0
2019-11-18 05:04:00	SPY	ETF	312.32	312.32	312.32	312.32	250.0
2019-11-18 05:09:00	SPY	ETF	312.22	312.22	312.22	312.22	300.0
2019-11-18 05:24:00	SPY	ETF	312.32	312.32	312.32	312.32	200.0
2019-11-18 05:27:00	SPY	ETF	312.36	312.37	312.34	312.34	2625.0
2019-11-18 05:28:00	SPY	ETF	312.34	312.34	312.34	312.34	200.0
2019-11-18 05:31:00	SPY	ETF	312.37	312.37	312.37	312.37	360.0
2019-11-18 05:32:00	SPY	ETF	312.33	312.33	312.33	312.33	1000.0
2019-11-18 05:36:00	SPY	ETF	312.29	312.29	312.29	312.29	103.0
2019-11-18 05:39:00	SPY	ETF	312.24	312.29	312.24	312.24	2501.0
2019-11-18 05:40:00	SPY	ETF	312.27	312.27	312.27	312.27	200.0
2019-11-18 05:49:00	SPY	ETF	312.2	312.24	312.2	312.24	500.0
2019-11-18 05:56:00	SPY	ETF	312.2	312.2	312.17	312.17	373.0
2019-11-18 05:59:00	SPY	ETF	312.17	312.17	312.16	312.16	500.0
2019-11-18 06:04:00	SPY	ETF	312.14	312.14	312.14	312.14	301.0
2019-11-18 06:13:00	SPY	ETF	312.17	312.17	312.17	312.17	350.0
2019-11-18 06:17:00	SPY	ETF	312.13	312.13	312.09	312.11	4501.0
2019-11-18 06:20:00	SPY	ETF	312.14	312.14	312.1	312.11	5300.0
2019-11-18 06:29:00	SPY	ETF	312.21	312.22	312.21	312.21	2200.0
2019-11-18 06:35:00	SPY	ETF	312.19	312.19	312.19	312.19	100.0
2019-11-18 06:40:00	SPY	ETF	312.29	312.3	312.29	312.3	4480.0
2019-11-18 06:42:00	SPY	ETF	312.31	312.31	312.3	312.3	2507.0
2019-11-18 06:45:00	SPY	ETF	312.33	312.33	312.33	312.33	100.0
2019-11-18 06:47:00	SPY	ETF	312.33	312.33	312.33	312.33	100.0
2019-11-18 06:50:00	SPY	ETF	312.3	312.3	312.3	312.3	1513.0
2019-11-18 06:51:00	SPY	ETF	312.3	312.3	312.3	312.3	1900.0
2019-11-18 06:52:00	SPY	ETF	312.3	312.3	312.3	312.3	1600.0
2019-11-18 06:54:00	SPY	ETF	312.3	312.3	312.3	312.3	800.0
2019-11-18 07:00:00	SPY	ETF	312.3	312.3	312.23	312.23	522.0
2019-11-18 07:01:00	SPY	ETF	312.28	312.28	312.23	312.23	2135.0
2019-11-18 07:03:00	SPY	ETF	312.28	312.28	312.28	312.28	895.0
2019-11-18 07:05:00	SPY	ETF	312.28	312.3	312.28	312.3	5146.0
2019-11-18 07:06:00	SPY	ETF	312.33	312.35	312.3	312.3	1080.0
2019-11-18 07:07:00	SPY	ETF	312.32	312.32	312.32	312.32	503.0
2019-11-18 07:08:00	SPY	ETF	312.33	312.35	312.33	312.35	692.0

> showing 50 of 159,826 rows — these rows as CSV

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