PREVIEW / etf_1min / 2020-04-20

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-04-20.parquet
  size:    4.3 MB
  rows:    224,853

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-20 04:00:00	SPY	ETF	285.84	285.84	285.54	285.54	7377.0
2020-04-20 04:01:00	SPY	ETF	285.52	285.56	285.51	285.51	2713.0
2020-04-20 04:02:00	SPY	ETF	285.51	285.6	285.51	285.6	341.0
2020-04-20 04:03:00	SPY	ETF	285.57	285.64	285.57	285.64	870.0
2020-04-20 04:04:00	SPY	ETF	285.56	285.61	285.5	285.5	2295.0
2020-04-20 04:05:00	SPY	ETF	285.5	285.5	285.47	285.47	390.0
2020-04-20 04:06:00	SPY	ETF	285.47	285.47	285.4	285.4	1700.0
2020-04-20 04:07:00	SPY	ETF	285.47	285.59	285.4	285.59	2290.0
2020-04-20 04:08:00	SPY	ETF	285.61	285.67	285.54	285.55	4090.0
2020-04-20 04:09:00	SPY	ETF	285.4	285.46	285.36	285.46	1000.0
2020-04-20 04:10:00	SPY	ETF	285.32	285.41	285.32	285.41	4001.0
2020-04-20 04:11:00	SPY	ETF	285.34	285.34	285.32	285.33	2002.0
2020-04-20 04:12:00	SPY	ETF	285.3	285.35	285.3	285.35	1458.0
2020-04-20 04:13:00	SPY	ETF	285.3	285.3	285.29	285.29	786.0
2020-04-20 04:14:00	SPY	ETF	285.3	285.37	285.27	285.37	3685.0
2020-04-20 04:15:00	SPY	ETF	285.22	285.22	285.18	285.18	4312.0
2020-04-20 04:16:00	SPY	ETF	285.2	285.32	285.2	285.32	1600.0
2020-04-20 04:17:00	SPY	ETF	285.32	285.38	285.32	285.38	1570.0
2020-04-20 04:18:00	SPY	ETF	285.28	285.4	285.28	285.4	898.0
2020-04-20 04:19:00	SPY	ETF	285.24	285.24	285.24	285.24	180.0
2020-04-20 04:20:00	SPY	ETF	285.39	285.4	285.39	285.39	1222.0
2020-04-20 04:21:00	SPY	ETF	285.22	285.22	285.19	285.19	460.0
2020-04-20 04:22:00	SPY	ETF	285.13	285.15	285.13	285.15	500.0
2020-04-20 04:23:00	SPY	ETF	285.06	285.06	284.91	284.91	5533.0
2020-04-20 04:24:00	SPY	ETF	284.99	284.99	284.86	284.86	1127.0
2020-04-20 04:25:00	SPY	ETF	284.85	284.86	284.69	284.69	7678.0
2020-04-20 04:26:00	SPY	ETF	284.7	284.7	284.7	284.7	225.0
2020-04-20 04:27:00	SPY	ETF	284.69	284.8	284.69	284.7	3730.0
2020-04-20 04:28:00	SPY	ETF	284.78	284.9	284.75	284.9	7104.0
2020-04-20 04:29:00	SPY	ETF	284.7	284.7	284.67	284.67	4055.0
2020-04-20 04:30:00	SPY	ETF	284.62	284.7	284.62	284.7	4530.0
2020-04-20 04:31:00	SPY	ETF	284.77	284.81	284.77	284.81	2123.0
2020-04-20 04:32:00	SPY	ETF	284.78	284.78	284.6	284.6	911.0
2020-04-20 04:33:00	SPY	ETF	284.57	284.68	284.57	284.68	1190.0
2020-04-20 04:34:00	SPY	ETF	284.72	284.74	284.72	284.74	2851.0
2020-04-20 04:35:00	SPY	ETF	284.79	284.82	284.79	284.82	1193.0
2020-04-20 04:37:00	SPY	ETF	284.82	284.84	284.82	284.84	1330.0
2020-04-20 04:38:00	SPY	ETF	284.84	284.84	284.84	284.84	440.0
2020-04-20 04:39:00	SPY	ETF	284.87	284.87	284.87	284.87	147.0
2020-04-20 04:41:00	SPY	ETF	284.87	284.87	284.87	284.87	1630.0
2020-04-20 04:42:00	SPY	ETF	284.91	284.95	284.9	284.9	1110.0
2020-04-20 04:43:00	SPY	ETF	284.97	284.97	284.95	284.95	1500.0
2020-04-20 04:44:00	SPY	ETF	284.9	284.9	284.9	284.9	390.0
2020-04-20 04:45:00	SPY	ETF	284.88	284.88	284.88	284.88	109.0
2020-04-20 04:46:00	SPY	ETF	285.12	285.12	285.12	285.12	545.0
2020-04-20 04:48:00	SPY	ETF	285.01	285.01	285.0	285.0	5500.0
2020-04-20 04:50:00	SPY	ETF	284.9	284.9	284.9	284.9	500.0
2020-04-20 04:52:00	SPY	ETF	284.99	284.99	284.99	284.99	1000.0
2020-04-20 04:55:00	SPY	ETF	284.94	284.94	284.94	284.94	110.0
2020-04-20 04:57:00	SPY	ETF	285.1	285.1	285.09	285.09	1454.0

> showing 50 of 224,853 rows — these rows as CSV

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