PREVIEW / etf_1min / 2020-03-24

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-03-24.parquet
  size:    5.0 MB
  rows:    260,674

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-03-24 04:00:00	SPY	ETF	232.03	232.89	231.5	232.89	40649.0
2020-03-24 04:01:00	SPY	ETF	232.93	233.0	232.59	232.79	6996.0
2020-03-24 04:02:00	SPY	ETF	232.79	233.1	232.77	232.84	10665.0
2020-03-24 04:03:00	SPY	ETF	233.0	233.09	232.87	232.9	10843.0
2020-03-24 04:04:00	SPY	ETF	233.01	233.26	233.0	233.26	15459.0
2020-03-24 04:05:00	SPY	ETF	233.0	233.26	232.9	233.21	5558.0
2020-03-24 04:06:00	SPY	ETF	233.13	233.33	233.13	233.33	4042.0
2020-03-24 04:07:00	SPY	ETF	233.33	233.43	233.08	233.08	3387.0
2020-03-24 04:08:00	SPY	ETF	233.08	233.25	233.08	233.21	8888.0
2020-03-24 04:09:00	SPY	ETF	233.16	233.33	233.15	233.26	3765.0
2020-03-24 04:10:00	SPY	ETF	233.08	233.08	233.08	233.08	1200.0
2020-03-24 04:11:00	SPY	ETF	232.9	232.9	232.9	232.9	355.0
2020-03-24 04:12:00	SPY	ETF	232.9	233.12	232.9	233.12	1392.0
2020-03-24 04:13:00	SPY	ETF	233.27	233.28	233.27	233.28	452.0
2020-03-24 04:14:00	SPY	ETF	233.29	233.33	233.11	233.11	4010.0
2020-03-24 04:15:00	SPY	ETF	233.33	233.49	233.22	233.49	2375.0
2020-03-24 04:16:00	SPY	ETF	233.49	233.5	233.49	233.5	2557.0
2020-03-24 04:17:00	SPY	ETF	233.41	233.41	233.41	233.41	360.0
2020-03-24 04:18:00	SPY	ETF	233.4	233.4	232.94	232.96	3882.0
2020-03-24 04:20:00	SPY	ETF	232.87	233.0	232.54	233.0	2529.0
2020-03-24 04:21:00	SPY	ETF	232.96	232.96	232.75	232.75	335.0
2020-03-24 04:22:00	SPY	ETF	232.43	232.43	232.18	232.18	2087.0
2020-03-24 04:23:00	SPY	ETF	231.92	232.23	231.68	232.23	3854.0
2020-03-24 04:24:00	SPY	ETF	232.0	232.29	232.0	232.09	1001.0
2020-03-24 04:25:00	SPY	ETF	231.8	231.94	231.79	231.79	1931.0
2020-03-24 04:26:00	SPY	ETF	231.95	232.07	231.95	232.04	1805.0
2020-03-24 04:27:00	SPY	ETF	232.1	232.1	232.1	232.1	100.0
2020-03-24 04:28:00	SPY	ETF	231.97	231.97	231.66	231.66	1202.0
2020-03-24 04:29:00	SPY	ETF	231.78	231.78	231.6	231.6	1751.0
2020-03-24 04:30:00	SPY	ETF	231.5	231.62	231.5	231.62	1354.0
2020-03-24 04:31:00	SPY	ETF	231.63	231.63	231.63	231.63	468.0
2020-03-24 04:32:00	SPY	ETF	231.45	231.68	231.45	231.64	6415.0
2020-03-24 04:33:00	SPY	ETF	231.05	231.22	231.05	231.22	710.0
2020-03-24 04:34:00	SPY	ETF	231.22	231.27	231.22	231.27	1197.0
2020-03-24 04:35:00	SPY	ETF	231.22	231.59	231.22	231.59	1163.0
2020-03-24 04:36:00	SPY	ETF	231.8	231.92	231.8	231.92	579.0
2020-03-24 04:37:00	SPY	ETF	232.07	232.16	231.89	232.11	5928.0
2020-03-24 04:38:00	SPY	ETF	231.75	231.75	231.75	231.75	759.0
2020-03-24 04:39:00	SPY	ETF	231.97	232.1	231.97	232.1	2502.0
2020-03-24 04:40:00	SPY	ETF	232.3	232.3	232.16	232.18	830.0
2020-03-24 04:41:00	SPY	ETF	231.75	231.93	231.75	231.89	1905.0
2020-03-24 04:42:00	SPY	ETF	231.94	231.94	231.94	231.94	381.0
2020-03-24 04:43:00	SPY	ETF	231.74	232.07	231.74	232.07	1703.0
2020-03-24 04:44:00	SPY	ETF	232.22	232.37	232.22	232.23	1020.0
2020-03-24 04:45:00	SPY	ETF	232.22	232.24	232.16	232.24	4875.0
2020-03-24 04:46:00	SPY	ETF	232.2	232.2	232.16	232.16	361.0
2020-03-24 04:47:00	SPY	ETF	232.21	232.38	232.21	232.38	1599.0
2020-03-24 04:48:00	SPY	ETF	232.58	232.59	232.25	232.43	3355.0
2020-03-24 04:49:00	SPY	ETF	232.4	232.4	232.0	232.0	1201.0
2020-03-24 04:50:00	SPY	ETF	232.21	232.28	232.11	232.11	650.0

> showing 50 of 260,674 rows — these rows as CSV

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