PREVIEW / etf_1min / 2020-01-07

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-01-07.parquet
  size:    3.4 MB
  rows:    177,030

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-01-07 04:00:00	SPY	ETF	324.1	324.13	324.1	324.13	1475.0
2020-01-07 04:02:00	SPY	ETF	324.1	324.1	324.1	324.1	425.0
2020-01-07 04:05:00	SPY	ETF	324.1	324.1	324.1	324.1	2015.0
2020-01-07 04:17:00	SPY	ETF	323.9	323.9	323.9	323.9	900.0
2020-01-07 04:18:00	SPY	ETF	323.92	323.96	323.92	323.92	900.0
2020-01-07 04:19:00	SPY	ETF	323.97	323.97	323.97	323.97	400.0
2020-01-07 04:20:00	SPY	ETF	323.95	323.95	323.95	323.95	2110.0
2020-01-07 04:23:00	SPY	ETF	323.95	323.95	323.95	323.95	1020.0
2020-01-07 04:32:00	SPY	ETF	324.06	324.06	324.06	324.06	800.0
2020-01-07 04:38:00	SPY	ETF	323.94	323.94	323.91	323.91	542.0
2020-01-07 04:42:00	SPY	ETF	323.9	323.9	323.9	323.9	500.0
2020-01-07 04:43:00	SPY	ETF	323.87	323.87	323.87	323.87	407.0
2020-01-07 04:47:00	SPY	ETF	323.61	323.61	323.61	323.61	200.0
2020-01-07 04:49:00	SPY	ETF	323.66	323.66	323.6	323.6	875.0
2020-01-07 04:56:00	SPY	ETF	323.81	323.81	323.81	323.81	100.0
2020-01-07 05:05:00	SPY	ETF	323.9	323.9	323.9	323.9	100.0
2020-01-07 05:09:00	SPY	ETF	323.91	323.91	323.91	323.91	500.0
2020-01-07 05:13:00	SPY	ETF	323.84	323.84	323.84	323.84	300.0
2020-01-07 05:15:00	SPY	ETF	323.86	323.86	323.86	323.86	100.0
2020-01-07 05:16:00	SPY	ETF	323.89	323.89	323.89	323.89	543.0
2020-01-07 05:18:00	SPY	ETF	323.89	323.89	323.89	323.89	500.0
2020-01-07 05:19:00	SPY	ETF	323.81	323.81	323.81	323.81	389.0
2020-01-07 05:25:00	SPY	ETF	323.66	323.66	323.64	323.64	244.0
2020-01-07 05:26:00	SPY	ETF	323.6	323.6	323.58	323.59	2358.0
2020-01-07 05:28:00	SPY	ETF	323.69	323.69	323.69	323.69	400.0
2020-01-07 05:30:00	SPY	ETF	323.61	323.61	323.61	323.61	204.0
2020-01-07 05:31:00	SPY	ETF	323.61	323.61	323.61	323.61	400.0
2020-01-07 05:35:00	SPY	ETF	323.63	323.65	323.63	323.65	503.0
2020-01-07 05:37:00	SPY	ETF	323.76	323.76	323.7	323.7	1300.0
2020-01-07 05:40:00	SPY	ETF	323.75	323.75	323.74	323.74	801.0
2020-01-07 05:42:00	SPY	ETF	323.64	323.64	323.64	323.64	640.0
2020-01-07 05:43:00	SPY	ETF	323.69	323.69	323.69	323.69	150.0
2020-01-07 05:44:00	SPY	ETF	323.64	323.64	323.64	323.64	304.0
2020-01-07 05:47:00	SPY	ETF	323.66	323.66	323.66	323.66	400.0
2020-01-07 05:48:00	SPY	ETF	323.69	323.69	323.69	323.69	100.0
2020-01-07 05:49:00	SPY	ETF	323.69	323.69	323.69	323.69	500.0
2020-01-07 05:54:00	SPY	ETF	323.81	323.81	323.81	323.81	500.0
2020-01-07 05:56:00	SPY	ETF	323.78	323.78	323.78	323.78	101.0
2020-01-07 05:57:00	SPY	ETF	323.78	323.78	323.78	323.78	566.0
2020-01-07 05:59:00	SPY	ETF	323.78	323.78	323.78	323.78	300.0
2020-01-07 06:00:00	SPY	ETF	323.76	323.76	323.76	323.76	300.0
2020-01-07 06:05:00	SPY	ETF	323.89	323.93	323.89	323.93	812.0
2020-01-07 06:06:00	SPY	ETF	323.9	323.9	323.9	323.9	200.0
2020-01-07 06:08:00	SPY	ETF	323.87	323.87	323.87	323.87	100.0
2020-01-07 06:10:00	SPY	ETF	323.85	323.85	323.85	323.85	500.0
2020-01-07 06:11:00	SPY	ETF	323.85	323.85	323.85	323.85	490.0
2020-01-07 06:14:00	SPY	ETF	323.75	323.75	323.75	323.75	401.0
2020-01-07 06:15:00	SPY	ETF	323.75	323.75	323.71	323.71	1606.0
2020-01-07 06:16:00	SPY	ETF	323.69	323.69	323.69	323.69	200.0
2020-01-07 06:22:00	SPY	ETF	323.66	323.66	323.66	323.66	300.0

> showing 50 of 177,030 rows — these rows as CSV

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