PREVIEW / etf_1min / 2020-10-09

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-10-09.parquet
  size:    3.6 MB
  rows:    195,567

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-09 04:00:00	SPY	ETF	345.0	345.08	344.91	345.05	5820.0
2020-10-09 04:01:00	SPY	ETF	345.1	345.1	345.1	345.1	3000.0
2020-10-09 04:02:00	SPY	ETF	345.14	345.14	345.14	345.14	403.0
2020-10-09 04:05:00	SPY	ETF	345.14	345.14	345.14	345.14	109.0
2020-10-09 04:09:00	SPY	ETF	345.1	345.1	345.1	345.1	520.0
2020-10-09 04:10:00	SPY	ETF	344.96	344.96	344.9	344.94	730.0
2020-10-09 04:11:00	SPY	ETF	344.95	344.95	344.95	344.95	200.0
2020-10-09 04:18:00	SPY	ETF	344.9	344.9	344.9	344.9	200.0
2020-10-09 04:19:00	SPY	ETF	344.93	344.93	344.93	344.93	500.0
2020-10-09 04:21:00	SPY	ETF	344.95	344.95	344.94	344.94	500.0
2020-10-09 04:23:00	SPY	ETF	345.03	345.03	345.03	345.03	1000.0
2020-10-09 04:25:00	SPY	ETF	345.03	345.03	345.01	345.01	1400.0
2020-10-09 04:28:00	SPY	ETF	345.05	345.05	345.05	345.05	100.0
2020-10-09 04:29:00	SPY	ETF	345.0	345.0	345.0	345.0	502.0
2020-10-09 04:30:00	SPY	ETF	345.0	345.0	344.96	345.0	800.0
2020-10-09 04:31:00	SPY	ETF	345.01	345.01	345.0	345.0	1699.0
2020-10-09 04:32:00	SPY	ETF	345.01	345.01	345.01	345.01	500.0
2020-10-09 04:33:00	SPY	ETF	345.04	345.04	344.96	345.03	7810.0
2020-10-09 04:34:00	SPY	ETF	344.96	344.96	344.96	344.96	520.0
2020-10-09 04:35:00	SPY	ETF	344.86	344.89	344.86	344.87	1101.0
2020-10-09 04:36:00	SPY	ETF	344.89	344.91	344.86	344.89	4901.0
2020-10-09 04:37:00	SPY	ETF	344.87	344.89	344.86	344.89	5400.0
2020-10-09 04:38:00	SPY	ETF	344.87	344.89	344.87	344.89	1300.0
2020-10-09 04:39:00	SPY	ETF	344.9	344.9	344.9	344.9	500.0
2020-10-09 04:40:00	SPY	ETF	344.86	344.86	344.86	344.86	500.0
2020-10-09 04:42:00	SPY	ETF	344.85	344.85	344.85	344.85	600.0
2020-10-09 04:43:00	SPY	ETF	344.91	344.91	344.91	344.91	180.0
2020-10-09 04:45:00	SPY	ETF	344.94	344.94	344.94	344.94	400.0
2020-10-09 04:46:00	SPY	ETF	344.91	344.94	344.91	344.94	800.0
2020-10-09 04:54:00	SPY	ETF	345.09	345.24	345.09	345.21	11457.0
2020-10-09 04:55:00	SPY	ETF	345.28	345.28	345.28	345.28	259.0
2020-10-09 04:56:00	SPY	ETF	345.3	345.3	345.3	345.3	420.0
2020-10-09 04:57:00	SPY	ETF	345.23	345.25	345.23	345.23	694.0
2020-10-09 04:58:00	SPY	ETF	345.15	345.15	345.04	345.04	200.0
2020-10-09 04:59:00	SPY	ETF	345.04	345.04	345.04	345.04	585.0
2020-10-09 05:01:00	SPY	ETF	345.01	345.01	344.99	344.99	1541.0
2020-10-09 05:04:00	SPY	ETF	344.89	344.89	344.87	344.87	3066.0
2020-10-09 05:09:00	SPY	ETF	345.04	345.04	345.04	345.04	370.0
2020-10-09 05:10:00	SPY	ETF	344.99	344.99	344.99	344.99	500.0
2020-10-09 05:11:00	SPY	ETF	345.0	345.0	344.96	344.96	1800.0
2020-10-09 05:13:00	SPY	ETF	344.98	344.98	344.98	344.98	500.0
2020-10-09 05:14:00	SPY	ETF	344.95	344.95	344.95	344.95	168.0
2020-10-09 05:19:00	SPY	ETF	345.01	345.02	344.99	344.99	1500.0
2020-10-09 05:20:00	SPY	ETF	344.97	344.97	344.94	344.94	1500.0
2020-10-09 05:22:00	SPY	ETF	345.04	345.04	345.04	345.04	504.0
2020-10-09 05:23:00	SPY	ETF	345.01	345.02	345.01	345.02	724.0
2020-10-09 05:24:00	SPY	ETF	345.05	345.05	345.02	345.02	1850.0
2020-10-09 05:25:00	SPY	ETF	345.02	345.02	345.02	345.02	350.0
2020-10-09 05:26:00	SPY	ETF	345.05	345.05	345.05	345.05	300.0
2020-10-09 05:28:00	SPY	ETF	345.04	345.04	345.04	345.04	404.0

> showing 50 of 195,567 rows — these rows as CSV

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