PREVIEW / etf_1min / 2020-07-14

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-07-14.parquet
  size:    3.8 MB
  rows:    219,695

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-07-14 04:00:00	SPY	ETF	314.91	314.94	314.9	314.93	1472.0
2020-07-14 04:01:00	SPY	ETF	315.0	315.17	315.0	315.17	1200.0
2020-07-14 04:02:00	SPY	ETF	315.2	315.2	315.2	315.2	207.0
2020-07-14 04:03:00	SPY	ETF	315.3	315.3	315.3	315.3	175.0
2020-07-14 04:04:00	SPY	ETF	315.31	315.31	315.3	315.3	1292.0
2020-07-14 04:05:00	SPY	ETF	315.35	315.35	315.35	315.35	2555.0
2020-07-14 04:06:00	SPY	ETF	315.3	315.3	315.3	315.3	565.0
2020-07-14 04:07:00	SPY	ETF	315.41	315.5	315.41	315.5	349.0
2020-07-14 04:08:00	SPY	ETF	315.6	315.63	315.6	315.62	700.0
2020-07-14 04:09:00	SPY	ETF	315.65	315.65	315.65	315.65	121.0
2020-07-14 04:10:00	SPY	ETF	315.72	316.05	315.71	316.05	13934.0
2020-07-14 04:11:00	SPY	ETF	316.15	316.15	316.01	316.01	2700.0
2020-07-14 04:14:00	SPY	ETF	315.86	315.86	315.86	315.86	150.0
2020-07-14 04:15:00	SPY	ETF	316.01	316.01	316.01	316.01	225.0
2020-07-14 04:17:00	SPY	ETF	315.91	315.91	315.88	315.88	1203.0
2020-07-14 04:19:00	SPY	ETF	315.85	315.85	315.81	315.81	3186.0
2020-07-14 04:20:00	SPY	ETF	315.93	315.93	315.86	315.86	337.0
2020-07-14 04:27:00	SPY	ETF	315.79	315.83	315.79	315.83	945.0
2020-07-14 04:29:00	SPY	ETF	316.0	316.05	316.0	316.05	502.0
2020-07-14 04:30:00	SPY	ETF	316.03	316.03	316.03	316.03	117.0
2020-07-14 04:33:00	SPY	ETF	316.02	316.02	316.02	316.02	134.0
2020-07-14 04:34:00	SPY	ETF	315.92	315.92	315.92	315.92	114.0
2020-07-14 04:39:00	SPY	ETF	316.08	316.08	316.05	316.05	415.0
2020-07-14 04:40:00	SPY	ETF	316.1	316.1	316.1	316.1	145.0
2020-07-14 04:41:00	SPY	ETF	316.18	316.18	316.18	316.18	110.0
2020-07-14 04:45:00	SPY	ETF	316.25	316.25	316.23	316.23	1220.0
2020-07-14 04:47:00	SPY	ETF	316.11	316.12	316.11	316.12	2425.0
2020-07-14 04:50:00	SPY	ETF	316.06	316.06	316.03	316.03	206.0
2020-07-14 04:52:00	SPY	ETF	315.91	315.91	315.91	315.91	990.0
2020-07-14 04:53:00	SPY	ETF	315.98	315.98	315.98	315.98	110.0
2020-07-14 04:54:00	SPY	ETF	315.85	315.85	315.85	315.85	130.0
2020-07-14 04:55:00	SPY	ETF	315.86	315.86	315.86	315.86	100.0
2020-07-14 04:58:00	SPY	ETF	316.0	316.0	315.95	315.95	480.0
2020-07-14 04:59:00	SPY	ETF	315.93	315.93	315.93	315.93	550.0
2020-07-14 05:00:00	SPY	ETF	315.93	315.93	315.93	315.93	1886.0
2020-07-14 05:02:00	SPY	ETF	316.06	316.06	316.06	316.06	402.0
2020-07-14 05:06:00	SPY	ETF	315.98	315.98	315.85	315.85	515.0
2020-07-14 05:07:00	SPY	ETF	315.91	315.91	315.86	315.86	401.0
2020-07-14 05:08:00	SPY	ETF	315.93	315.93	315.93	315.93	300.0
2020-07-14 05:09:00	SPY	ETF	315.8	315.8	315.7	315.7	310.0
2020-07-14 05:10:00	SPY	ETF	315.65	315.65	315.5	315.58	921.0
2020-07-14 05:11:00	SPY	ETF	315.68	315.69	315.68	315.69	203.0
2020-07-14 05:12:00	SPY	ETF	315.71	315.78	315.71	315.78	2030.0
2020-07-14 05:13:00	SPY	ETF	315.81	315.81	315.81	315.81	715.0
2020-07-14 05:14:00	SPY	ETF	315.89	315.9	315.89	315.9	600.0
2020-07-14 05:18:00	SPY	ETF	316.25	316.25	316.25	316.25	245.0
2020-07-14 05:19:00	SPY	ETF	316.23	316.23	316.23	316.23	500.0
2020-07-14 05:21:00	SPY	ETF	316.13	316.15	316.1	316.15	1926.0
2020-07-14 05:22:00	SPY	ETF	316.12	316.12	316.12	316.12	150.0
2020-07-14 05:23:00	SPY	ETF	316.05	316.05	316.05	316.05	130.0

> showing 50 of 219,695 rows — these rows as CSV

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