PREVIEW / etf_1min / 2021-07-28

all etf 1-min files

  file:    by_date/etf_1min/2021/2021-07-28.parquet
  size:    3.7 MB
  rows:    214,658

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
2021-07-28 04:00:00	SPY	ETF	439.0	439.0	438.83	438.83	351.0
2021-07-28 04:06:00	SPY	ETF	439.09	439.13	439.09	439.13	400.0
2021-07-28 04:13:00	SPY	ETF	439.12	439.12	439.1	439.1	400.0
2021-07-28 04:14:00	SPY	ETF	439.09	439.09	439.09	439.09	100.0
2021-07-28 04:17:00	SPY	ETF	439.26	439.26	439.26	439.26	128.0
2021-07-28 04:20:00	SPY	ETF	439.2	439.2	439.2	439.2	700.0
2021-07-28 04:21:00	SPY	ETF	439.3	439.3	439.3	439.3	100.0
2021-07-28 04:22:00	SPY	ETF	439.42	439.42	439.42	439.42	500.0
2021-07-28 04:23:00	SPY	ETF	439.41	439.42	439.38	439.42	740.0
2021-07-28 04:29:00	SPY	ETF	439.35	439.35	439.35	439.35	338.0
2021-07-28 04:30:00	SPY	ETF	439.47	439.51	439.47	439.51	845.0
2021-07-28 04:33:00	SPY	ETF	439.68	439.68	439.68	439.68	352.0
2021-07-28 04:34:00	SPY	ETF	439.64	439.64	439.64	439.64	500.0
2021-07-28 04:38:00	SPY	ETF	439.62	439.62	439.62	439.62	100.0
2021-07-28 04:40:00	SPY	ETF	439.77	439.77	439.77	439.77	100.0
2021-07-28 04:41:00	SPY	ETF	439.68	439.68	439.68	439.68	341.0
2021-07-28 04:42:00	SPY	ETF	439.62	439.62	439.61	439.61	500.0
2021-07-28 04:43:00	SPY	ETF	439.57	439.57	439.57	439.57	300.0
2021-07-28 04:46:00	SPY	ETF	439.69	439.7	439.69	439.7	1000.0
2021-07-28 04:50:00	SPY	ETF	439.67	439.7	439.67	439.7	511.0
2021-07-28 04:54:00	SPY	ETF	439.8	439.8	439.8	439.8	100.0
2021-07-28 04:55:00	SPY	ETF	439.92	439.92	439.92	439.92	200.0
2021-07-28 04:57:00	SPY	ETF	439.95	439.95	439.87	439.88	700.0
2021-07-28 04:58:00	SPY	ETF	439.92	439.92	439.92	439.92	200.0
2021-07-28 04:59:00	SPY	ETF	439.91	439.91	439.91	439.91	100.0
2021-07-28 05:00:00	SPY	ETF	439.9	439.9	439.9	439.9	100.0
2021-07-28 05:05:00	SPY	ETF	439.84	439.84	439.84	439.84	1800.0
2021-07-28 05:06:00	SPY	ETF	439.81	439.81	439.8	439.8	1600.0
2021-07-28 05:07:00	SPY	ETF	439.8	439.8	439.79	439.79	1100.0
2021-07-28 05:08:00	SPY	ETF	439.77	439.8	439.77	439.8	537.0
2021-07-28 05:09:00	SPY	ETF	439.75	439.75	439.75	439.75	300.0
2021-07-28 05:10:00	SPY	ETF	439.76	439.76	439.75	439.75	700.0
2021-07-28 05:12:00	SPY	ETF	439.73	439.73	439.73	439.73	100.0
2021-07-28 05:16:00	SPY	ETF	439.77	439.77	439.77	439.77	700.0
2021-07-28 05:17:00	SPY	ETF	439.85	439.85	439.76	439.76	490.0
2021-07-28 05:19:00	SPY	ETF	439.75	439.75	439.75	439.75	500.0
2021-07-28 05:31:00	SPY	ETF	439.82	439.82	439.82	439.82	100.0
2021-07-28 05:32:00	SPY	ETF	439.82	439.82	439.82	439.82	200.0
2021-07-28 05:39:00	SPY	ETF	439.6	439.6	439.56	439.56	2029.0
2021-07-28 05:40:00	SPY	ETF	439.7	439.7	439.7	439.7	400.0
2021-07-28 05:47:00	SPY	ETF	439.69	439.69	439.69	439.69	100.0
2021-07-28 05:54:00	SPY	ETF	439.76	439.78	439.76	439.78	400.0
2021-07-28 05:56:00	SPY	ETF	439.84	439.85	439.84	439.84	760.0
2021-07-28 05:57:00	SPY	ETF	439.83	439.83	439.8	439.8	400.0
2021-07-28 05:59:00	SPY	ETF	439.79	439.79	439.79	439.79	100.0
2021-07-28 06:12:00	SPY	ETF	439.41	439.41	439.41	439.41	500.0
2021-07-28 06:13:00	SPY	ETF	439.34	439.34	439.2	439.2	200.0
2021-07-28 06:14:00	SPY	ETF	439.15	439.15	439.1	439.1	2100.0
2021-07-28 06:15:00	SPY	ETF	439.02	439.02	438.96	438.96	600.0
2021-07-28 06:16:00	SPY	ETF	439.02	439.02	439.02	439.02	5000.0

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

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