PREVIEW / etf_1min / 2020-04-09

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-04-09.parquet
  size:    4.8 MB
  rows:    251,691

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-09 04:00:00	SPY	ETF	276.56	277.06	276.56	277.02	25011.0
2020-04-09 04:01:00	SPY	ETF	276.92	276.94	276.7	276.77	6641.0
2020-04-09 04:02:00	SPY	ETF	276.74	276.84	276.74	276.84	7705.0
2020-04-09 04:03:00	SPY	ETF	276.87	276.89	276.87	276.89	1983.0
2020-04-09 04:04:00	SPY	ETF	276.67	276.74	276.67	276.74	1475.0
2020-04-09 04:05:00	SPY	ETF	276.78	276.94	276.78	276.93	3795.0
2020-04-09 04:06:00	SPY	ETF	276.93	276.93	276.63	276.63	3897.0
2020-04-09 04:07:00	SPY	ETF	276.62	276.7	276.6	276.69	1950.0
2020-04-09 04:08:00	SPY	ETF	276.74	276.74	276.74	276.74	150.0
2020-04-09 04:09:00	SPY	ETF	276.75	276.78	276.64	276.64	3200.0
2020-04-09 04:10:00	SPY	ETF	276.45	276.45	276.45	276.45	903.0
2020-04-09 04:11:00	SPY	ETF	276.3	276.3	276.15	276.15	1808.0
2020-04-09 04:12:00	SPY	ETF	276.44	276.44	276.44	276.44	277.0
2020-04-09 04:13:00	SPY	ETF	276.12	276.17	276.1	276.17	2125.0
2020-04-09 04:14:00	SPY	ETF	276.27	276.28	276.23	276.28	876.0
2020-04-09 04:15:00	SPY	ETF	276.18	276.18	276.0	276.0	1506.0
2020-04-09 04:16:00	SPY	ETF	276.1	276.17	276.08	276.14	2655.0
2020-04-09 04:17:00	SPY	ETF	276.12	276.12	275.8	275.8	2195.0
2020-04-09 04:18:00	SPY	ETF	275.86	275.93	275.86	275.93	1000.0
2020-04-09 04:19:00	SPY	ETF	275.98	275.98	275.96	275.96	250.0
2020-04-09 04:20:00	SPY	ETF	275.84	275.9	275.84	275.87	1706.0
2020-04-09 04:21:00	SPY	ETF	275.97	275.97	275.95	275.97	530.0
2020-04-09 04:22:00	SPY	ETF	276.0	276.0	276.0	276.0	2303.0
2020-04-09 04:23:00	SPY	ETF	275.9	275.98	275.9	275.97	5306.0
2020-04-09 04:24:00	SPY	ETF	275.86	275.86	275.57	275.57	5750.0
2020-04-09 04:25:00	SPY	ETF	275.49	275.49	275.47	275.47	516.0
2020-04-09 04:26:00	SPY	ETF	275.51	275.52	275.47	275.47	4101.0
2020-04-09 04:27:00	SPY	ETF	275.49	275.49	275.25	275.25	1420.0
2020-04-09 04:28:00	SPY	ETF	275.23	275.23	275.18	275.21	2085.0
2020-04-09 04:29:00	SPY	ETF	275.12	275.16	274.94	274.94	5508.0
2020-04-09 04:30:00	SPY	ETF	274.97	275.19	274.96	275.17	8410.0
2020-04-09 04:31:00	SPY	ETF	275.14	275.22	275.14	275.22	2780.0
2020-04-09 04:32:00	SPY	ETF	275.22	275.24	275.13	275.15	5903.0
2020-04-09 04:33:00	SPY	ETF	275.18	275.18	275.08	275.12	300.0
2020-04-09 04:34:00	SPY	ETF	275.25	275.25	275.23	275.23	807.0
2020-04-09 04:36:00	SPY	ETF	274.96	275.03	274.8	275.03	3361.0
2020-04-09 04:37:00	SPY	ETF	274.98	274.98	274.98	274.98	170.0
2020-04-09 04:38:00	SPY	ETF	274.9	274.9	274.55	274.55	1831.0
2020-04-09 04:39:00	SPY	ETF	274.5	274.5	274.16	274.16	970.0
2020-04-09 04:40:00	SPY	ETF	274.42	274.45	274.33	274.33	6010.0
2020-04-09 04:41:00	SPY	ETF	274.41	274.55	274.41	274.53	2828.0
2020-04-09 04:42:00	SPY	ETF	274.55	274.55	274.5	274.54	6396.0
2020-04-09 04:43:00	SPY	ETF	274.65	274.7	274.55	274.55	5727.0
2020-04-09 04:44:00	SPY	ETF	274.55	274.55	274.41	274.41	2995.0
2020-04-09 04:45:00	SPY	ETF	274.47	274.81	274.47	274.81	668.0
2020-04-09 04:46:00	SPY	ETF	274.81	274.81	274.77	274.77	4143.0
2020-04-09 04:47:00	SPY	ETF	274.77	274.77	274.77	274.77	385.0
2020-04-09 04:48:00	SPY	ETF	274.8	274.8	274.72	274.74	1300.0
2020-04-09 04:49:00	SPY	ETF	274.69	274.69	274.65	274.65	1514.0
2020-04-09 04:50:00	SPY	ETF	274.69	274.69	274.69	274.69	104.0

> showing 50 of 251,691 rows — these rows as CSV

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