PREVIEW / etf_1min / 2020-05-01

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-05-01.parquet
  size:    4.1 MB
  rows:    214,450

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-01 04:00:00	SPY	ETF	284.39	284.39	284.21	284.35	7160.0
2020-05-01 04:01:00	SPY	ETF	284.35	284.42	284.29	284.29	3778.0
2020-05-01 04:02:00	SPY	ETF	284.28	284.39	284.28	284.34	5188.0
2020-05-01 04:03:00	SPY	ETF	284.39	284.39	284.12	284.12	2705.0
2020-05-01 04:04:00	SPY	ETF	284.18	284.18	284.0	284.0	1116.0
2020-05-01 04:05:00	SPY	ETF	283.99	283.99	283.82	283.82	370.0
2020-05-01 04:06:00	SPY	ETF	283.76	283.79	283.74	283.74	2748.0
2020-05-01 04:07:00	SPY	ETF	283.79	283.84	283.68	283.84	2427.0
2020-05-01 04:08:00	SPY	ETF	283.84	284.07	283.84	284.07	1689.0
2020-05-01 04:09:00	SPY	ETF	284.08	284.14	284.08	284.14	690.0
2020-05-01 04:10:00	SPY	ETF	284.21	284.21	284.18	284.18	480.0
2020-05-01 04:12:00	SPY	ETF	284.22	284.22	284.18	284.18	4226.0
2020-05-01 04:13:00	SPY	ETF	284.14	284.23	284.14	284.23	726.0
2020-05-01 04:14:00	SPY	ETF	284.27	284.44	284.27	284.44	4025.0
2020-05-01 04:15:00	SPY	ETF	284.4	284.42	284.4	284.42	1159.0
2020-05-01 04:16:00	SPY	ETF	284.49	284.56	284.49	284.56	1150.0
2020-05-01 04:17:00	SPY	ETF	284.52	284.57	284.52	284.57	1527.0
2020-05-01 04:18:00	SPY	ETF	284.57	284.67	284.57	284.67	2050.0
2020-05-01 04:19:00	SPY	ETF	284.64	284.64	284.62	284.63	1995.0
2020-05-01 04:20:00	SPY	ETF	284.63	284.66	284.58	284.66	1774.0
2020-05-01 04:21:00	SPY	ETF	284.74	284.9	284.74	284.87	4691.0
2020-05-01 04:22:00	SPY	ETF	284.83	284.83	284.8	284.8	4730.0
2020-05-01 04:23:00	SPY	ETF	284.83	284.84	284.81	284.82	3392.0
2020-05-01 04:26:00	SPY	ETF	284.8	284.86	284.8	284.86	200.0
2020-05-01 04:28:00	SPY	ETF	284.85	284.85	284.85	284.85	595.0
2020-05-01 04:31:00	SPY	ETF	284.8	284.8	284.8	284.8	375.0
2020-05-01 04:32:00	SPY	ETF	284.83	284.98	284.82	284.98	605.0
2020-05-01 04:33:00	SPY	ETF	284.99	284.99	284.99	284.99	220.0
2020-05-01 04:34:00	SPY	ETF	284.98	285.0	284.98	285.0	1052.0
2020-05-01 04:35:00	SPY	ETF	284.84	284.98	284.83	284.98	1100.0
2020-05-01 04:36:00	SPY	ETF	285.06	285.09	285.04	285.04	314.0
2020-05-01 04:37:00	SPY	ETF	284.99	285.1	284.98	285.05	7908.0
2020-05-01 04:38:00	SPY	ETF	285.13	285.14	285.1	285.14	7815.0
2020-05-01 04:39:00	SPY	ETF	285.03	285.03	284.99	284.99	355.0
2020-05-01 04:40:00	SPY	ETF	284.88	284.9	284.85	284.85	12669.0
2020-05-01 04:41:00	SPY	ETF	284.77	284.8	284.74	284.8	1860.0
2020-05-01 04:43:00	SPY	ETF	284.6	284.6	284.55	284.55	2280.0
2020-05-01 04:44:00	SPY	ETF	284.72	284.72	284.72	284.72	320.0
2020-05-01 04:45:00	SPY	ETF	284.8	284.8	284.62	284.62	537.0
2020-05-01 04:50:00	SPY	ETF	284.95	285.11	284.94	285.09	4735.0
2020-05-01 04:51:00	SPY	ETF	285.05	285.13	285.05	285.13	4280.0
2020-05-01 04:52:00	SPY	ETF	285.23	285.26	285.23	285.26	15040.0
2020-05-01 04:53:00	SPY	ETF	285.2	285.21	285.2	285.21	240.0
2020-05-01 04:54:00	SPY	ETF	285.1	285.1	285.08	285.08	3650.0
2020-05-01 04:55:00	SPY	ETF	285.08	285.09	285.02	285.02	2110.0
2020-05-01 04:56:00	SPY	ETF	285.03	285.03	285.03	285.03	456.0
2020-05-01 04:57:00	SPY	ETF	285.06	285.06	285.06	285.06	500.0
2020-05-01 04:58:00	SPY	ETF	285.14	285.33	285.14	285.33	21053.0
2020-05-01 04:59:00	SPY	ETF	285.2	285.2	285.18	285.18	888.0
2020-05-01 05:00:00	SPY	ETF	285.24	285.24	285.21	285.21	1090.0

> showing 50 of 214,450 rows — these rows as CSV

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