PREVIEW / etf_1min / 2020-05-07

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-05-07.parquet
  size:    3.7 MB
  rows:    207,411

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-05-07 04:00:00	SPY	ETF	286.7	286.96	286.7	286.9	10416.0
2020-05-07 04:01:00	SPY	ETF	286.83	286.93	286.79	286.79	3210.0
2020-05-07 04:02:00	SPY	ETF	286.85	286.85	286.85	286.85	4011.0
2020-05-07 04:03:00	SPY	ETF	286.8	286.8	286.75	286.75	451.0
2020-05-07 04:04:00	SPY	ETF	286.73	286.73	286.72	286.72	1195.0
2020-05-07 04:05:00	SPY	ETF	286.73	286.76	286.71	286.74	1378.0
2020-05-07 04:06:00	SPY	ETF	286.75	286.8	286.75	286.8	7618.0
2020-05-07 04:08:00	SPY	ETF	286.79	286.79	286.72	286.72	1545.0
2020-05-07 04:09:00	SPY	ETF	286.87	286.9	286.87	286.9	1345.0
2020-05-07 04:10:00	SPY	ETF	286.87	286.87	286.87	286.87	145.0
2020-05-07 04:11:00	SPY	ETF	286.79	286.79	286.72	286.72	857.0
2020-05-07 04:12:00	SPY	ETF	286.83	286.83	286.82	286.83	2230.0
2020-05-07 04:13:00	SPY	ETF	286.83	286.83	286.82	286.82	3307.0
2020-05-07 04:14:00	SPY	ETF	286.9	286.9	286.9	286.9	345.0
2020-05-07 04:15:00	SPY	ETF	287.0	287.1	287.0	287.08	2747.0
2020-05-07 04:16:00	SPY	ETF	287.04	287.08	287.04	287.08	795.0
2020-05-07 04:17:00	SPY	ETF	286.99	287.04	286.99	287.04	690.0
2020-05-07 04:18:00	SPY	ETF	286.96	287.04	286.96	287.04	479.0
2020-05-07 04:21:00	SPY	ETF	286.94	286.94	286.94	286.94	153.0
2020-05-07 04:22:00	SPY	ETF	286.94	287.05	286.94	287.05	4867.0
2020-05-07 04:23:00	SPY	ETF	287.05	287.05	287.05	287.05	2296.0
2020-05-07 04:26:00	SPY	ETF	286.9	286.91	286.89	286.89	5545.0
2020-05-07 04:27:00	SPY	ETF	287.04	287.05	287.04	287.05	1630.0
2020-05-07 04:28:00	SPY	ETF	286.99	287.0	286.99	287.0	1045.0
2020-05-07 04:29:00	SPY	ETF	287.1	287.13	287.1	287.13	1190.0
2020-05-07 04:30:00	SPY	ETF	287.11	287.2	287.11	287.2	2715.0
2020-05-07 04:31:00	SPY	ETF	287.28	287.32	287.28	287.28	1695.0
2020-05-07 04:32:00	SPY	ETF	287.26	287.26	287.21	287.26	1965.0
2020-05-07 04:33:00	SPY	ETF	287.24	287.25	287.24	287.25	2680.0
2020-05-07 04:35:00	SPY	ETF	287.16	287.21	287.16	287.21	1495.0
2020-05-07 04:36:00	SPY	ETF	287.17	287.17	287.16	287.16	2587.0
2020-05-07 04:37:00	SPY	ETF	287.21	287.21	287.2	287.2	3119.0
2020-05-07 04:38:00	SPY	ETF	287.25	287.25	287.1	287.1	8545.0
2020-05-07 04:39:00	SPY	ETF	287.09	287.09	287.02	287.02	1540.0
2020-05-07 04:40:00	SPY	ETF	286.95	287.0	286.95	287.0	4587.0
2020-05-07 04:41:00	SPY	ETF	287.01	287.01	287.0	287.0	4046.0
2020-05-07 04:42:00	SPY	ETF	286.94	287.02	286.91	287.02	4145.0
2020-05-07 04:43:00	SPY	ETF	286.98	286.98	286.95	286.95	4000.0
2020-05-07 04:44:00	SPY	ETF	286.93	286.93	286.93	286.93	295.0
2020-05-07 04:47:00	SPY	ETF	287.18	287.18	287.18	287.18	615.0
2020-05-07 04:48:00	SPY	ETF	287.3	287.35	287.3	287.35	5463.0
2020-05-07 04:49:00	SPY	ETF	287.26	287.3	287.26	287.3	2345.0
2020-05-07 04:50:00	SPY	ETF	287.4	287.4	287.4	287.4	1454.0
2020-05-07 04:52:00	SPY	ETF	287.37	287.37	287.37	287.37	145.0
2020-05-07 04:53:00	SPY	ETF	287.35	287.35	287.35	287.35	240.0
2020-05-07 04:56:00	SPY	ETF	287.24	287.24	287.22	287.22	4270.0
2020-05-07 04:58:00	SPY	ETF	287.33	287.4	287.33	287.37	1006.0
2020-05-07 04:59:00	SPY	ETF	287.28	287.28	287.28	287.28	645.0
2020-05-07 05:00:00	SPY	ETF	287.31	287.36	287.31	287.35	1645.0
2020-05-07 05:02:00	SPY	ETF	287.34	287.34	287.34	287.34	261.0

> showing 50 of 207,411 rows — these rows as CSV

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