PREVIEW / etf_1min / 2019-10-17

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-10-17.parquet
  size:    3.0 MB
  rows:    157,700

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
2019-10-17 04:00:00	SPY	ETF	298.75	298.75	298.75	298.75	100.0
2019-10-17 04:03:00	SPY	ETF	298.67	298.75	298.67	298.69	2500.0
2019-10-17 04:04:00	SPY	ETF	298.7	298.7	298.7	298.7	350.0
2019-10-17 04:12:00	SPY	ETF	298.95	298.95	298.95	298.95	190.0
2019-10-17 04:17:00	SPY	ETF	298.88	298.88	298.88	298.88	400.0
2019-10-17 04:22:00	SPY	ETF	298.85	298.85	298.85	298.85	270.0
2019-10-17 04:26:00	SPY	ETF	298.8	298.8	298.8	298.8	1200.0
2019-10-17 04:34:00	SPY	ETF	298.78	298.78	298.78	298.78	900.0
2019-10-17 04:35:00	SPY	ETF	298.8	298.82	298.8	298.82	1300.0
2019-10-17 04:37:00	SPY	ETF	298.82	298.85	298.82	298.85	500.0
2019-10-17 04:38:00	SPY	ETF	298.95	298.95	298.95	298.95	2000.0
2019-10-17 04:39:00	SPY	ETF	299.0	299.22	299.0	299.22	886.0
2019-10-17 05:22:00	SPY	ETF	298.84	298.84	298.84	298.84	300.0
2019-10-17 05:28:00	SPY	ETF	299.06	299.06	299.06	299.06	130.0
2019-10-17 05:31:00	SPY	ETF	299.19	299.42	299.19	299.42	1741.0
2019-10-17 05:32:00	SPY	ETF	299.59	299.59	299.49	299.49	5243.0
2019-10-17 05:33:00	SPY	ETF	299.56	299.56	299.53	299.53	1626.0
2019-10-17 05:34:00	SPY	ETF	299.57	299.7	299.57	299.7	1803.0
2019-10-17 05:35:00	SPY	ETF	299.8	299.95	299.8	299.95	3225.0
2019-10-17 05:36:00	SPY	ETF	299.97	300.0	299.97	299.98	4001.0
2019-10-17 05:37:00	SPY	ETF	299.89	299.93	299.89	299.93	608.0
2019-10-17 05:38:00	SPY	ETF	300.05	300.05	300.05	300.05	179.0
2019-10-17 05:39:00	SPY	ETF	299.96	299.96	299.85	299.85	258.0
2019-10-17 05:40:00	SPY	ETF	299.8	299.8	299.58	299.8	6295.0
2019-10-17 05:43:00	SPY	ETF	299.82	299.82	299.82	299.82	100.0
2019-10-17 05:44:00	SPY	ETF	299.79	299.79	299.74	299.74	1225.0
2019-10-17 05:46:00	SPY	ETF	299.9	299.9	299.9	299.9	100.0
2019-10-17 05:47:00	SPY	ETF	299.8	299.8	299.8	299.8	573.0
2019-10-17 05:48:00	SPY	ETF	299.74	299.76	299.74	299.74	1600.0
2019-10-17 05:49:00	SPY	ETF	299.75	299.75	299.75	299.75	300.0
2019-10-17 05:50:00	SPY	ETF	299.82	299.82	299.76	299.81	967.0
2019-10-17 05:52:00	SPY	ETF	299.81	299.84	299.81	299.83	2110.0
2019-10-17 05:53:00	SPY	ETF	299.89	299.93	299.89	299.93	767.0
2019-10-17 05:54:00	SPY	ETF	299.95	299.96	299.95	299.96	470.0
2019-10-17 05:55:00	SPY	ETF	299.9	299.9	299.9	299.9	155.0
2019-10-17 05:58:00	SPY	ETF	299.95	299.95	299.92	299.92	2100.0
2019-10-17 05:59:00	SPY	ETF	299.82	299.82	299.82	299.82	202.0
2019-10-17 06:00:00	SPY	ETF	299.85	299.89	299.85	299.86	850.0
2019-10-17 06:01:00	SPY	ETF	299.95	299.95	299.91	299.91	1610.0
2019-10-17 06:04:00	SPY	ETF	299.85	299.85	299.81	299.81	1601.0
2019-10-17 06:06:00	SPY	ETF	299.94	299.94	299.94	299.94	750.0
2019-10-17 06:07:00	SPY	ETF	299.99	300.01	299.99	300.0	10300.0
2019-10-17 06:10:00	SPY	ETF	299.98	300.01	299.98	300.01	400.0
2019-10-17 06:11:00	SPY	ETF	300.1	300.1	300.1	300.1	2008.0
2019-10-17 06:12:00	SPY	ETF	299.96	299.96	299.96	299.96	301.0
2019-10-17 06:13:00	SPY	ETF	299.93	299.93	299.83	299.83	1190.0
2019-10-17 06:14:00	SPY	ETF	299.93	299.93	299.93	299.93	201.0
2019-10-17 06:16:00	SPY	ETF	299.98	299.98	299.98	299.98	1152.0
2019-10-17 06:18:00	SPY	ETF	299.9	299.9	299.9	299.9	200.0
2019-10-17 06:22:00	SPY	ETF	299.89	299.93	299.89	299.93	502.0

> showing 50 of 157,700 rows — these rows as CSV

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