PREVIEW / etf_1min / 2020-10-07

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-10-07.parquet
  size:    3.6 MB
  rows:    198,542

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-10-07 04:00:00	SPY	ETF	337.35	337.45	337.33	337.45	6407.0
2020-10-07 04:01:00	SPY	ETF	337.32	337.38	337.25	337.25	3009.0
2020-10-07 04:02:00	SPY	ETF	337.33	337.36	337.33	337.36	411.0
2020-10-07 04:04:00	SPY	ETF	337.3	337.3	337.3	337.3	221.0
2020-10-07 04:05:00	SPY	ETF	337.3	337.3	337.3	337.3	303.0
2020-10-07 04:06:00	SPY	ETF	337.41	337.41	337.37	337.37	1804.0
2020-10-07 04:07:00	SPY	ETF	337.3	337.3	337.22	337.22	3511.0
2020-10-07 04:09:00	SPY	ETF	337.11	337.11	337.11	337.11	462.0
2020-10-07 04:10:00	SPY	ETF	337.05	337.05	336.98	337.02	12953.0
2020-10-07 04:12:00	SPY	ETF	336.97	336.97	336.97	336.97	470.0
2020-10-07 04:13:00	SPY	ETF	337.02	337.02	337.02	337.02	2555.0
2020-10-07 04:14:00	SPY	ETF	337.08	337.08	337.08	337.08	150.0
2020-10-07 04:15:00	SPY	ETF	336.92	336.92	336.92	336.92	190.0
2020-10-07 04:16:00	SPY	ETF	337.0	337.0	337.0	337.0	1000.0
2020-10-07 04:17:00	SPY	ETF	337.11	337.11	337.1	337.1	903.0
2020-10-07 04:18:00	SPY	ETF	337.04	337.04	337.04	337.04	2521.0
2020-10-07 04:20:00	SPY	ETF	337.04	337.04	336.9	336.9	1300.0
2020-10-07 04:21:00	SPY	ETF	336.9	336.9	336.9	336.9	540.0
2020-10-07 04:22:00	SPY	ETF	336.95	336.95	336.95	336.95	100.0
2020-10-07 04:23:00	SPY	ETF	337.02	337.02	337.02	337.02	200.0
2020-10-07 04:24:00	SPY	ETF	337.07	337.07	337.07	337.07	300.0
2020-10-07 04:26:00	SPY	ETF	336.99	337.02	336.98	336.98	3000.0
2020-10-07 04:28:00	SPY	ETF	336.85	336.85	336.85	336.85	120.0
2020-10-07 04:31:00	SPY	ETF	336.85	336.85	336.85	336.85	256.0
2020-10-07 04:32:00	SPY	ETF	336.84	336.84	336.84	336.84	180.0
2020-10-07 04:36:00	SPY	ETF	337.02	337.09	337.02	337.04	2632.0
2020-10-07 04:38:00	SPY	ETF	337.11	337.11	337.11	337.11	207.0
2020-10-07 04:39:00	SPY	ETF	337.23	337.23	337.21	337.21	230.0
2020-10-07 04:40:00	SPY	ETF	337.14	337.14	337.14	337.14	150.0
2020-10-07 04:41:00	SPY	ETF	337.22	337.27	337.22	337.27	390.0
2020-10-07 04:42:00	SPY	ETF	337.0	337.0	337.0	337.0	1004.0
2020-10-07 04:44:00	SPY	ETF	337.07	337.07	337.07	337.07	180.0
2020-10-07 04:46:00	SPY	ETF	337.12	337.12	337.12	337.12	1000.0
2020-10-07 04:49:00	SPY	ETF	337.2	337.2	337.18	337.18	1800.0
2020-10-07 04:50:00	SPY	ETF	337.18	337.2	337.18	337.2	4500.0
2020-10-07 04:51:00	SPY	ETF	337.16	337.16	337.13	337.13	1102.0
2020-10-07 04:53:00	SPY	ETF	337.24	337.33	337.24	337.3	595.0
2020-10-07 04:55:00	SPY	ETF	337.25	337.25	337.24	337.24	500.0
2020-10-07 04:56:00	SPY	ETF	337.28	337.28	337.28	337.28	102.0
2020-10-07 04:58:00	SPY	ETF	337.33	337.33	337.33	337.33	102.0
2020-10-07 05:01:00	SPY	ETF	337.28	337.28	337.28	337.28	5000.0
2020-10-07 05:06:00	SPY	ETF	337.14	337.14	337.14	337.14	200.0
2020-10-07 05:11:00	SPY	ETF	337.11	337.11	337.11	337.11	190.0
2020-10-07 05:14:00	SPY	ETF	337.13	337.13	337.13	337.13	100.0
2020-10-07 05:17:00	SPY	ETF	337.08	337.13	337.08	337.13	800.0
2020-10-07 05:25:00	SPY	ETF	337.05	337.05	337.05	337.05	100.0
2020-10-07 05:26:00	SPY	ETF	337.0	337.0	337.0	337.0	111.0
2020-10-07 05:27:00	SPY	ETF	336.95	336.95	336.95	336.95	1000.0
2020-10-07 05:29:00	SPY	ETF	337.05	337.05	337.05	337.05	100.0
2020-10-07 05:30:00	SPY	ETF	337.0	337.0	337.0	337.0	483.0

> showing 50 of 198,542 rows — these rows as CSV

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