PREVIEW / etf_1min / 2020-01-02

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-01-02.parquet
  size:    3.8 MB
  rows:    194,441

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-02 04:00:00	SPY	ETF	323.52	323.67	323.52	323.56	9391.0
2020-01-02 04:01:00	SPY	ETF	323.68	323.69	323.61	323.61	905.0
2020-01-02 04:02:00	SPY	ETF	323.68	323.68	323.68	323.68	121.0
2020-01-02 04:03:00	SPY	ETF	323.69	323.69	323.69	323.69	127.0
2020-01-02 04:04:00	SPY	ETF	323.64	323.64	323.64	323.64	100.0
2020-01-02 04:06:00	SPY	ETF	323.71	323.76	323.71	323.76	398.0
2020-01-02 04:09:00	SPY	ETF	323.78	323.78	323.7	323.76	2935.0
2020-01-02 04:10:00	SPY	ETF	323.76	323.76	323.73	323.73	300.0
2020-01-02 04:14:00	SPY	ETF	323.81	323.83	323.81	323.81	3600.0
2020-01-02 04:18:00	SPY	ETF	323.76	323.76	323.76	323.76	100.0
2020-01-02 04:24:00	SPY	ETF	323.76	323.76	323.76	323.76	100.0
2020-01-02 04:25:00	SPY	ETF	323.75	323.77	323.75	323.77	500.0
2020-01-02 04:26:00	SPY	ETF	323.78	323.78	323.78	323.78	169.0
2020-01-02 04:27:00	SPY	ETF	323.75	323.76	323.75	323.76	605.0
2020-01-02 04:30:00	SPY	ETF	323.75	323.76	323.69	323.76	2170.0
2020-01-02 04:33:00	SPY	ETF	323.7	323.7	323.7	323.7	1360.0
2020-01-02 04:35:00	SPY	ETF	323.74	323.75	323.74	323.75	1104.0
2020-01-02 04:36:00	SPY	ETF	323.75	323.8	323.75	323.78	800.0
2020-01-02 04:37:00	SPY	ETF	323.78	323.78	323.76	323.78	1400.0
2020-01-02 04:41:00	SPY	ETF	323.78	323.86	323.78	323.86	1500.0
2020-01-02 04:43:00	SPY	ETF	323.71	323.71	323.71	323.71	200.0
2020-01-02 04:50:00	SPY	ETF	323.76	323.76	323.76	323.76	400.0
2020-01-02 04:56:00	SPY	ETF	323.83	323.83	323.83	323.83	150.0
2020-01-02 05:00:00	SPY	ETF	323.82	323.82	323.82	323.82	300.0
2020-01-02 05:01:00	SPY	ETF	323.83	323.84	323.83	323.84	304.0
2020-01-02 05:02:00	SPY	ETF	323.85	323.85	323.84	323.84	1200.0
2020-01-02 05:04:00	SPY	ETF	323.85	323.85	323.85	323.85	505.0
2020-01-02 05:17:00	SPY	ETF	323.85	323.85	323.85	323.85	200.0
2020-01-02 05:18:00	SPY	ETF	323.84	323.84	323.84	323.84	100.0
2020-01-02 05:25:00	SPY	ETF	323.93	323.93	323.93	323.93	330.0
2020-01-02 05:28:00	SPY	ETF	323.94	323.94	323.94	323.94	196.0
2020-01-02 05:29:00	SPY	ETF	323.94	323.96	323.94	323.96	3834.0
2020-01-02 05:31:00	SPY	ETF	323.96	323.98	323.96	323.98	300.0
2020-01-02 05:34:00	SPY	ETF	323.9	323.9	323.9	323.9	1020.0
2020-01-02 05:35:00	SPY	ETF	323.92	323.92	323.91	323.92	1100.0
2020-01-02 05:36:00	SPY	ETF	323.91	323.91	323.91	323.91	400.0
2020-01-02 05:37:00	SPY	ETF	323.92	323.92	323.92	323.92	500.0
2020-01-02 05:42:00	SPY	ETF	323.98	323.98	323.98	323.98	100.0
2020-01-02 05:43:00	SPY	ETF	323.96	323.96	323.96	323.96	300.0
2020-01-02 05:44:00	SPY	ETF	323.98	323.98	323.98	323.98	1155.0
2020-01-02 05:45:00	SPY	ETF	323.98	323.98	323.98	323.98	1695.0
2020-01-02 05:48:00	SPY	ETF	323.98	323.98	323.98	323.98	310.0
2020-01-02 05:50:00	SPY	ETF	323.98	323.98	323.96	323.96	600.0
2020-01-02 05:51:00	SPY	ETF	323.95	323.95	323.95	323.95	290.0
2020-01-02 05:53:00	SPY	ETF	323.92	323.92	323.92	323.92	100.0
2020-01-02 05:54:00	SPY	ETF	323.93	323.96	323.93	323.96	300.0
2020-01-02 05:59:00	SPY	ETF	323.91	323.91	323.91	323.91	100.0
2020-01-02 06:02:00	SPY	ETF	323.94	323.94	323.94	323.94	220.0
2020-01-02 06:04:00	SPY	ETF	323.84	323.86	323.84	323.86	300.0
2020-01-02 06:05:00	SPY	ETF	323.84	323.84	323.84	323.84	100.0

> showing 50 of 194,441 rows — these rows as CSV

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