PREVIEW / etf_1min / 2020-04-24

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-04-24.parquet
  size:    3.8 MB
  rows:    202,490

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-04-24 04:00:00	SPY	ETF	278.25	278.27	277.98	278.02	2446.0
2020-04-24 04:01:00	SPY	ETF	277.92	277.92	277.68	277.75	4380.0
2020-04-24 04:02:00	SPY	ETF	277.82	277.82	277.68	277.68	1525.0
2020-04-24 04:03:00	SPY	ETF	277.64	277.65	277.57	277.58	3058.0
2020-04-24 04:04:00	SPY	ETF	277.65	277.65	277.61	277.61	400.0
2020-04-24 04:05:00	SPY	ETF	277.69	277.69	277.69	277.69	150.0
2020-04-24 04:06:00	SPY	ETF	277.69	277.71	277.69	277.71	306.0
2020-04-24 04:07:00	SPY	ETF	277.81	277.81	277.8	277.8	436.0
2020-04-24 04:08:00	SPY	ETF	277.68	277.68	277.65	277.65	1001.0
2020-04-24 04:09:00	SPY	ETF	277.71	277.71	277.71	277.71	110.0
2020-04-24 04:11:00	SPY	ETF	278.02	278.02	277.83	277.83	1030.0
2020-04-24 04:12:00	SPY	ETF	277.77	277.77	277.77	277.77	580.0
2020-04-24 04:13:00	SPY	ETF	277.7	277.7	277.7	277.7	600.0
2020-04-24 04:14:00	SPY	ETF	277.62	277.62	277.62	277.62	400.0
2020-04-24 04:15:00	SPY	ETF	277.62	277.62	277.57	277.57	1530.0
2020-04-24 04:16:00	SPY	ETF	277.48	277.48	277.42	277.42	295.0
2020-04-24 04:17:00	SPY	ETF	277.39	277.39	277.39	277.39	254.0
2020-04-24 04:18:00	SPY	ETF	277.32	277.32	277.22	277.22	456.0
2020-04-24 04:19:00	SPY	ETF	277.24	277.29	277.24	277.29	822.0
2020-04-24 04:20:00	SPY	ETF	277.23	277.23	277.23	277.23	585.0
2020-04-24 04:21:00	SPY	ETF	277.29	277.29	277.22	277.22	1700.0
2020-04-24 04:22:00	SPY	ETF	277.25	277.25	277.18	277.22	2069.0
2020-04-24 04:23:00	SPY	ETF	277.25	277.25	277.22	277.25	3300.0
2020-04-24 04:24:00	SPY	ETF	277.3	277.3	277.18	277.18	4615.0
2020-04-24 04:25:00	SPY	ETF	277.36	277.36	277.36	277.36	1020.0
2020-04-24 04:26:00	SPY	ETF	277.28	277.28	277.28	277.28	525.0
2020-04-24 04:27:00	SPY	ETF	277.33	277.33	277.33	277.33	1016.0
2020-04-24 04:29:00	SPY	ETF	277.39	277.47	277.39	277.43	1647.0
2020-04-24 04:31:00	SPY	ETF	277.43	277.43	277.43	277.43	801.0
2020-04-24 04:33:00	SPY	ETF	277.48	277.48	277.48	277.48	1000.0
2020-04-24 04:34:00	SPY	ETF	277.43	277.43	277.43	277.43	1000.0
2020-04-24 04:35:00	SPY	ETF	277.4	277.5	277.4	277.5	1675.0
2020-04-24 04:36:00	SPY	ETF	277.45	277.45	277.3	277.3	5520.0
2020-04-24 04:37:00	SPY	ETF	277.32	277.35	277.32	277.34	1100.0
2020-04-24 04:38:00	SPY	ETF	277.4	277.4	277.35	277.35	1164.0
2020-04-24 04:39:00	SPY	ETF	277.37	277.37	277.37	277.37	400.0
2020-04-24 04:40:00	SPY	ETF	277.55	277.55	277.52	277.52	1100.0
2020-04-24 04:41:00	SPY	ETF	277.57	277.57	277.54	277.54	850.0
2020-04-24 04:43:00	SPY	ETF	277.55	277.56	277.54	277.56	2135.0
2020-04-24 04:44:00	SPY	ETF	277.56	277.56	277.53	277.55	1400.0
2020-04-24 04:46:00	SPY	ETF	277.63	277.63	277.63	277.63	100.0
2020-04-24 04:47:00	SPY	ETF	277.6	277.6	277.6	277.6	1000.0
2020-04-24 04:50:00	SPY	ETF	277.69	277.69	277.69	277.69	545.0
2020-04-24 04:52:00	SPY	ETF	277.81	277.81	277.81	277.81	1055.0
2020-04-24 04:53:00	SPY	ETF	277.8	277.84	277.79	277.79	1106.0
2020-04-24 04:54:00	SPY	ETF	277.9	277.9	277.9	277.9	100.0
2020-04-24 04:55:00	SPY	ETF	277.93	277.93	277.89	277.89	1544.0
2020-04-24 04:56:00	SPY	ETF	277.89	277.89	277.89	277.89	140.0
2020-04-24 04:57:00	SPY	ETF	277.86	277.86	277.86	277.86	280.0
2020-04-24 04:59:00	SPY	ETF	277.86	277.86	277.86	277.86	1000.0

> showing 50 of 202,490 rows — these rows as CSV

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