PREVIEW / etf_1min / 2020-03-31

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-03-31.parquet
  size:    4.4 MB
  rows:    234,247

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-31 04:00:00	SPY	ETF	262.74	263.0	262.74	262.93	2839.0
2020-03-31 04:01:00	SPY	ETF	262.87	262.87	262.5	262.55	3727.0
2020-03-31 04:02:00	SPY	ETF	262.71	262.91	262.71	262.91	2252.0
2020-03-31 04:03:00	SPY	ETF	262.98	263.04	262.89	262.89	6811.0
2020-03-31 04:04:00	SPY	ETF	262.76	262.76	262.59	262.69	984.0
2020-03-31 04:05:00	SPY	ETF	262.89	263.03	262.87	262.95	1928.0
2020-03-31 04:06:00	SPY	ETF	262.74	262.75	262.72	262.75	920.0
2020-03-31 04:07:00	SPY	ETF	263.12	263.12	263.1	263.1	525.0
2020-03-31 04:08:00	SPY	ETF	263.14	263.27	263.1	263.26	3664.0
2020-03-31 04:09:00	SPY	ETF	263.36	263.45	263.36	263.45	7104.0
2020-03-31 04:10:00	SPY	ETF	263.43	263.45	263.43	263.45	4100.0
2020-03-31 04:11:00	SPY	ETF	263.4	263.48	263.4	263.47	1480.0
2020-03-31 04:12:00	SPY	ETF	263.4	263.4	263.29	263.29	1080.0
2020-03-31 04:13:00	SPY	ETF	263.25	263.28	263.15	263.15	1630.0
2020-03-31 04:14:00	SPY	ETF	263.15	263.2	263.13	263.18	1536.0
2020-03-31 04:15:00	SPY	ETF	263.16	263.2	263.1	263.2	1440.0
2020-03-31 04:16:00	SPY	ETF	263.22	263.5	263.22	263.5	7316.0
2020-03-31 04:17:00	SPY	ETF	263.48	263.5	263.4	263.48	2110.0
2020-03-31 04:18:00	SPY	ETF	263.33	263.33	263.18	263.18	680.0
2020-03-31 04:19:00	SPY	ETF	263.05	263.05	263.04	263.04	1245.0
2020-03-31 04:20:00	SPY	ETF	263.23	263.23	263.15	263.15	625.0
2020-03-31 04:22:00	SPY	ETF	263.12	263.12	263.12	263.12	1137.0
2020-03-31 04:24:00	SPY	ETF	263.4	263.42	263.4	263.42	1110.0
2020-03-31 04:25:00	SPY	ETF	263.44	263.44	263.44	263.44	315.0
2020-03-31 04:27:00	SPY	ETF	263.47	263.47	263.47	263.47	1011.0
2020-03-31 04:28:00	SPY	ETF	263.66	263.79	263.66	263.79	800.0
2020-03-31 04:29:00	SPY	ETF	263.79	263.79	263.78	263.78	501.0
2020-03-31 04:31:00	SPY	ETF	263.68	263.73	263.6	263.6	4196.0
2020-03-31 04:32:00	SPY	ETF	263.63	263.63	263.61	263.61	5100.0
2020-03-31 04:33:00	SPY	ETF	263.61	263.67	263.57	263.66	3700.0
2020-03-31 04:35:00	SPY	ETF	263.79	263.79	263.76	263.79	1680.0
2020-03-31 04:36:00	SPY	ETF	263.79	263.79	263.42	263.42	3834.0
2020-03-31 04:37:00	SPY	ETF	263.29	263.32	263.21	263.28	3495.0
2020-03-31 04:38:00	SPY	ETF	263.26	263.38	263.26	263.38	680.0
2020-03-31 04:39:00	SPY	ETF	263.45	263.45	263.45	263.45	250.0
2020-03-31 04:40:00	SPY	ETF	263.46	263.46	263.46	263.46	100.0
2020-03-31 04:41:00	SPY	ETF	263.7	263.7	263.7	263.7	564.0
2020-03-31 04:42:00	SPY	ETF	263.84	263.9	263.84	263.87	900.0
2020-03-31 04:43:00	SPY	ETF	263.87	263.87	263.74	263.75	2771.0
2020-03-31 04:45:00	SPY	ETF	263.45	263.45	263.45	263.45	100.0
2020-03-31 04:46:00	SPY	ETF	263.37	263.37	263.25	263.25	1813.0
2020-03-31 04:47:00	SPY	ETF	263.29	263.29	263.19	263.19	740.0
2020-03-31 04:48:00	SPY	ETF	263.15	263.15	263.0	263.02	6250.0
2020-03-31 04:49:00	SPY	ETF	263.15	263.18	263.12	263.12	910.0
2020-03-31 04:50:00	SPY	ETF	263.27	263.27	263.27	263.27	245.0
2020-03-31 04:52:00	SPY	ETF	263.43	263.43	263.43	263.43	110.0
2020-03-31 04:54:00	SPY	ETF	263.5	263.5	263.44	263.44	513.0
2020-03-31 04:55:00	SPY	ETF	263.37	263.37	263.37	263.37	150.0
2020-03-31 04:57:00	SPY	ETF	263.41	263.41	263.32	263.32	1660.0
2020-03-31 04:58:00	SPY	ETF	263.3	263.3	263.3	263.3	500.0

> showing 50 of 234,247 rows — these rows as CSV

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