PREVIEW / etf_1min / 2020-08-21

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-08-21.parquet
  size:    3.5 MB
  rows:    193,363

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-08-21 04:00:00	SPY	ETF	338.35	338.35	338.15	338.15	841.0
2020-08-21 04:01:00	SPY	ETF	338.13	338.13	338.09	338.09	1529.0
2020-08-21 04:02:00	SPY	ETF	338.06	338.06	338.01	338.01	568.0
2020-08-21 04:03:00	SPY	ETF	338.0	338.04	338.0	338.04	1674.0
2020-08-21 04:04:00	SPY	ETF	338.01	338.01	338.01	338.01	100.0
2020-08-21 04:05:00	SPY	ETF	338.04	338.04	338.04	338.04	402.0
2020-08-21 04:06:00	SPY	ETF	338.11	338.11	338.11	338.11	412.0
2020-08-21 04:07:00	SPY	ETF	338.09	338.09	338.09	338.09	420.0
2020-08-21 04:10:00	SPY	ETF	338.06	338.06	338.06	338.06	503.0
2020-08-21 04:11:00	SPY	ETF	338.05	338.05	338.05	338.05	207.0
2020-08-21 04:12:00	SPY	ETF	337.94	337.94	337.94	337.94	500.0
2020-08-21 04:13:00	SPY	ETF	337.96	337.97	337.96	337.97	710.0
2020-08-21 04:22:00	SPY	ETF	338.0	338.0	338.0	338.0	1271.0
2020-08-21 04:23:00	SPY	ETF	338.05	338.05	338.04	338.04	700.0
2020-08-21 04:24:00	SPY	ETF	338.02	338.05	338.0	338.05	1602.0
2020-08-21 04:25:00	SPY	ETF	338.0	338.05	338.0	338.05	685.0
2020-08-21 04:30:00	SPY	ETF	337.9	338.01	337.89	338.0	1347.0
2020-08-21 04:31:00	SPY	ETF	337.95	337.95	337.75	337.75	1959.0
2020-08-21 04:32:00	SPY	ETF	337.81	337.81	337.77	337.77	207.0
2020-08-21 04:33:00	SPY	ETF	337.73	337.77	337.72	337.77	722.0
2020-08-21 04:34:00	SPY	ETF	337.81	337.85	337.81	337.85	202.0
2020-08-21 04:35:00	SPY	ETF	337.86	337.86	337.86	337.86	120.0
2020-08-21 04:36:00	SPY	ETF	337.89	337.89	337.77	337.77	1502.0
2020-08-21 04:37:00	SPY	ETF	337.81	337.81	337.81	337.81	101.0
2020-08-21 04:38:00	SPY	ETF	337.79	337.79	337.76	337.76	322.0
2020-08-21 04:39:00	SPY	ETF	337.73	337.77	337.69	337.77	739.0
2020-08-21 04:40:00	SPY	ETF	337.79	337.79	337.65	337.65	4828.0
2020-08-21 04:42:00	SPY	ETF	337.66	337.69	337.66	337.69	600.0
2020-08-21 04:43:00	SPY	ETF	337.73	337.73	337.73	337.73	102.0
2020-08-21 04:45:00	SPY	ETF	337.69	337.86	337.69	337.86	1005.0
2020-08-21 04:46:00	SPY	ETF	337.85	337.9	337.85	337.9	202.0
2020-08-21 04:48:00	SPY	ETF	337.81	337.81	337.73	337.73	403.0
2020-08-21 04:49:00	SPY	ETF	337.69	337.69	337.65	337.69	803.0
2020-08-21 04:50:00	SPY	ETF	337.73	337.73	337.69	337.69	201.0
2020-08-21 04:51:00	SPY	ETF	337.71	337.73	337.67	337.73	1450.0
2020-08-21 04:52:00	SPY	ETF	337.69	337.69	337.69	337.69	111.0
2020-08-21 04:54:00	SPY	ETF	337.73	337.77	337.73	337.77	212.0
2020-08-21 04:56:00	SPY	ETF	337.81	337.85	337.81	337.85	201.0
2020-08-21 04:57:00	SPY	ETF	337.85	337.85	337.85	337.85	122.0
2020-08-21 05:00:00	SPY	ETF	337.81	337.81	337.69	337.69	404.0
2020-08-21 05:01:00	SPY	ETF	337.73	337.77	337.73	337.77	202.0
2020-08-21 05:02:00	SPY	ETF	337.81	337.85	337.81	337.85	233.0
2020-08-21 05:05:00	SPY	ETF	337.95	337.99	337.94	337.99	401.0
2020-08-21 05:10:00	SPY	ETF	338.05	338.05	338.05	338.05	103.0
2020-08-21 05:14:00	SPY	ETF	338.05	338.05	338.05	338.05	345.0
2020-08-21 05:16:00	SPY	ETF	337.96	337.96	337.91	337.91	259.0
2020-08-21 05:19:00	SPY	ETF	338.06	338.06	338.06	338.06	1001.0
2020-08-21 05:20:00	SPY	ETF	338.05	338.08	338.05	338.08	215.0
2020-08-21 05:21:00	SPY	ETF	338.09	338.09	338.09	338.09	102.0
2020-08-21 05:22:00	SPY	ETF	338.09	338.09	338.09	338.09	400.0

> showing 50 of 193,363 rows — these rows as CSV

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