PREVIEW / etf_1min / 2020-02-19

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-02-19.parquet
  size:    3.4 MB
  rows:    177,036

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-19 04:00:00	SPY	ETF	337.35	337.44	337.35	337.44	248.0
2020-02-19 04:02:00	SPY	ETF	337.4	337.4	337.4	337.4	120.0
2020-02-19 04:07:00	SPY	ETF	337.45	337.45	337.42	337.42	1820.0
2020-02-19 04:08:00	SPY	ETF	337.42	337.42	337.42	337.42	1000.0
2020-02-19 04:09:00	SPY	ETF	337.42	337.42	337.42	337.42	200.0
2020-02-19 04:10:00	SPY	ETF	337.47	337.47	337.38	337.38	4322.0
2020-02-19 04:11:00	SPY	ETF	337.42	337.43	337.42	337.43	1520.0
2020-02-19 04:14:00	SPY	ETF	337.42	337.43	337.42	337.43	1100.0
2020-02-19 04:16:00	SPY	ETF	337.5	337.5	337.5	337.5	170.0
2020-02-19 04:17:00	SPY	ETF	337.54	337.54	337.5	337.5	1900.0
2020-02-19 04:20:00	SPY	ETF	337.49	337.49	337.49	337.49	110.0
2020-02-19 04:23:00	SPY	ETF	337.5	337.5	337.49	337.49	1476.0
2020-02-19 04:25:00	SPY	ETF	337.53	337.53	337.53	337.53	101.0
2020-02-19 04:26:00	SPY	ETF	337.52	337.52	337.5	337.5	842.0
2020-02-19 04:28:00	SPY	ETF	337.5	337.5	337.5	337.5	493.0
2020-02-19 04:32:00	SPY	ETF	337.52	337.52	337.52	337.52	100.0
2020-02-19 04:36:00	SPY	ETF	337.5	337.5	337.43	337.43	625.0
2020-02-19 04:38:00	SPY	ETF	337.42	337.42	337.42	337.42	500.0
2020-02-19 04:39:00	SPY	ETF	337.39	337.39	337.39	337.39	350.0
2020-02-19 04:41:00	SPY	ETF	337.44	337.44	337.44	337.44	200.0
2020-02-19 04:47:00	SPY	ETF	337.34	337.34	337.34	337.34	1610.0
2020-02-19 04:54:00	SPY	ETF	337.39	337.39	337.37	337.37	3036.0
2020-02-19 04:55:00	SPY	ETF	337.38	337.38	337.38	337.38	2000.0
2020-02-19 04:56:00	SPY	ETF	337.38	337.38	337.38	337.38	800.0
2020-02-19 05:19:00	SPY	ETF	337.42	337.42	337.42	337.42	500.0
2020-02-19 05:29:00	SPY	ETF	337.45	337.45	337.45	337.45	390.0
2020-02-19 05:49:00	SPY	ETF	337.4	337.4	337.4	337.4	222.0
2020-02-19 05:54:00	SPY	ETF	337.42	337.42	337.42	337.42	200.0
2020-02-19 05:58:00	SPY	ETF	337.43	337.43	337.43	337.43	100.0
2020-02-19 06:00:00	SPY	ETF	337.45	337.45	337.45	337.45	100.0
2020-02-19 06:01:00	SPY	ETF	337.43	337.43	337.43	337.43	500.0
2020-02-19 06:03:00	SPY	ETF	337.42	337.42	337.42	337.42	1600.0
2020-02-19 06:09:00	SPY	ETF	337.3	337.3	337.3	337.3	224.0
2020-02-19 06:10:00	SPY	ETF	337.4	337.4	337.4	337.4	125.0
2020-02-19 06:11:00	SPY	ETF	337.4	337.4	337.4	337.4	400.0
2020-02-19 06:16:00	SPY	ETF	337.41	337.41	337.41	337.41	300.0
2020-02-19 06:19:00	SPY	ETF	337.37	337.37	337.37	337.37	100.0
2020-02-19 06:21:00	SPY	ETF	337.37	337.37	337.37	337.37	500.0
2020-02-19 06:23:00	SPY	ETF	337.37	337.4	337.37	337.4	1378.0
2020-02-19 06:24:00	SPY	ETF	337.4	337.41	337.4	337.41	6400.0
2020-02-19 06:25:00	SPY	ETF	337.4	337.4	337.4	337.4	2500.0
2020-02-19 06:45:00	SPY	ETF	337.3	337.3	337.3	337.3	187.0
2020-02-19 06:50:00	SPY	ETF	337.37	337.37	337.37	337.37	272.0
2020-02-19 06:55:00	SPY	ETF	337.44	337.45	337.44	337.45	2020.0
2020-02-19 06:56:00	SPY	ETF	337.45	337.45	337.43	337.43	1180.0
2020-02-19 06:57:00	SPY	ETF	337.5	337.5	337.5	337.5	2055.0
2020-02-19 06:58:00	SPY	ETF	337.5	337.5	337.47	337.47	260.0
2020-02-19 06:59:00	SPY	ETF	337.47	337.5	337.47	337.5	2110.0
2020-02-19 07:00:00	SPY	ETF	337.46	337.48	337.45	337.45	3486.0
2020-02-19 07:02:00	SPY	ETF	337.47	337.47	337.47	337.47	267.0

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

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