PREVIEW / etf_1min / 2020-02-05

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-02-05.parquet
  size:    3.5 MB
  rows:    190,879

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-02-05 04:00:00	SPY	ETF	330.98	331.04	330.92	330.92	9842.0
2020-02-05 04:01:00	SPY	ETF	331.01	331.03	330.98	330.98	507.0
2020-02-05 04:02:00	SPY	ETF	330.92	330.92	330.92	330.92	110.0
2020-02-05 04:03:00	SPY	ETF	330.81	331.0	330.81	331.0	2352.0
2020-02-05 04:04:00	SPY	ETF	331.16	331.16	331.11	331.11	2709.0
2020-02-05 04:05:00	SPY	ETF	331.22	331.22	331.22	331.22	1960.0
2020-02-05 04:06:00	SPY	ETF	331.24	331.24	331.24	331.24	123.0
2020-02-05 04:07:00	SPY	ETF	331.56	331.56	331.56	331.56	435.0
2020-02-05 04:08:00	SPY	ETF	331.6	331.6	331.56	331.56	674.0
2020-02-05 04:09:00	SPY	ETF	331.51	331.74	331.51	331.7	1962.0
2020-02-05 04:10:00	SPY	ETF	331.58	331.59	331.58	331.58	2700.0
2020-02-05 04:11:00	SPY	ETF	331.58	331.58	331.58	331.58	200.0
2020-02-05 04:12:00	SPY	ETF	331.43	331.48	331.35	331.48	2210.0
2020-02-05 04:13:00	SPY	ETF	331.41	331.41	331.4	331.4	2575.0
2020-02-05 04:14:00	SPY	ETF	331.29	331.29	331.29	331.29	200.0
2020-02-05 04:15:00	SPY	ETF	331.33	331.33	331.33	331.33	150.0
2020-02-05 04:20:00	SPY	ETF	331.73	331.76	331.69	331.75	3200.0
2020-02-05 04:21:00	SPY	ETF	331.71	331.71	331.66	331.66	285.0
2020-02-05 04:22:00	SPY	ETF	331.61	331.61	331.61	331.61	580.0
2020-02-05 04:23:00	SPY	ETF	331.78	331.78	331.78	331.78	210.0
2020-02-05 04:24:00	SPY	ETF	331.71	331.78	331.71	331.78	800.0
2020-02-05 04:25:00	SPY	ETF	331.87	331.87	331.87	331.87	1091.0
2020-02-05 04:26:00	SPY	ETF	331.85	332.01	331.85	332.01	10773.0
2020-02-05 04:28:00	SPY	ETF	331.82	332.0	331.82	332.0	15350.0
2020-02-05 04:29:00	SPY	ETF	331.89	331.89	331.89	331.89	250.0
2020-02-05 04:30:00	SPY	ETF	331.9	331.98	331.9	331.98	400.0
2020-02-05 04:32:00	SPY	ETF	332.0	332.0	331.96	331.96	10799.0
2020-02-05 04:33:00	SPY	ETF	332.03	332.11	332.03	332.11	956.0
2020-02-05 04:34:00	SPY	ETF	332.12	332.12	332.12	332.12	100.0
2020-02-05 04:36:00	SPY	ETF	332.06	332.06	332.06	332.06	100.0
2020-02-05 04:37:00	SPY	ETF	332.12	332.15	332.1	332.15	2350.0
2020-02-05 04:38:00	SPY	ETF	332.09	332.1	332.09	332.1	400.0
2020-02-05 04:39:00	SPY	ETF	332.07	332.12	332.02	332.11	1350.0
2020-02-05 04:40:00	SPY	ETF	332.11	332.16	332.08	332.08	900.0
2020-02-05 04:41:00	SPY	ETF	332.23	332.23	332.23	332.23	220.0
2020-02-05 04:42:00	SPY	ETF	332.23	332.23	332.23	332.23	200.0
2020-02-05 04:43:00	SPY	ETF	332.2	332.2	332.2	332.2	1000.0
2020-02-05 04:44:00	SPY	ETF	332.25	332.25	332.25	332.25	1067.0
2020-02-05 04:46:00	SPY	ETF	332.2	332.2	332.17	332.17	1075.0
2020-02-05 04:47:00	SPY	ETF	332.2	332.23	332.19	332.19	700.0
2020-02-05 04:48:00	SPY	ETF	332.18	332.19	332.12	332.17	6950.0
2020-02-05 04:49:00	SPY	ETF	332.17	332.18	332.17	332.18	750.0
2020-02-05 04:50:00	SPY	ETF	332.25	332.25	332.24	332.24	642.0
2020-02-05 04:51:00	SPY	ETF	332.25	332.25	332.25	332.25	100.0
2020-02-05 04:52:00	SPY	ETF	332.47	332.52	332.47	332.52	828.0
2020-02-05 04:53:00	SPY	ETF	332.53	332.55	332.52	332.55	3950.0
2020-02-05 04:54:00	SPY	ETF	332.57	332.6	332.52	332.59	4287.0
2020-02-05 04:55:00	SPY	ETF	332.56	332.56	332.5	332.5	630.0
2020-02-05 04:56:00	SPY	ETF	332.45	332.47	332.45	332.45	5729.0
2020-02-05 04:57:00	SPY	ETF	332.4	332.4	332.4	332.4	3800.0

> showing 50 of 190,879 rows — these rows as CSV

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