PREVIEW / etf_1min / 2019-08-02

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-08-02.parquet
  size:    3.4 MB
  rows:    179,922

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-08-02 04:00:00	SPY	ETF	293.26	293.26	293.26	293.26	1351.0
2019-08-02 04:01:00	SPY	ETF	293.32	293.4	293.32	293.4	234.0
2019-08-02 04:02:00	SPY	ETF	293.48	293.48	293.48	293.48	300.0
2019-08-02 04:04:00	SPY	ETF	293.48	293.48	293.48	293.48	250.0
2019-08-02 04:05:00	SPY	ETF	293.61	293.61	293.61	293.61	404.0
2019-08-02 04:06:00	SPY	ETF	293.63	293.63	293.56	293.56	226.0
2019-08-02 04:07:00	SPY	ETF	293.48	293.48	293.48	293.48	100.0
2019-08-02 04:08:00	SPY	ETF	293.55	293.55	293.55	293.55	152.0
2019-08-02 04:09:00	SPY	ETF	293.63	293.63	293.63	293.63	150.0
2019-08-02 04:10:00	SPY	ETF	293.56	293.56	293.53	293.53	405.0
2019-08-02 04:13:00	SPY	ETF	293.63	293.63	293.63	293.63	420.0
2019-08-02 04:14:00	SPY	ETF	293.52	293.52	293.52	293.52	470.0
2019-08-02 04:18:00	SPY	ETF	293.3	293.3	293.3	293.3	264.0
2019-08-02 04:19:00	SPY	ETF	293.33	293.33	293.33	293.33	100.0
2019-08-02 04:22:00	SPY	ETF	293.3	293.3	293.3	293.3	164.0
2019-08-02 04:29:00	SPY	ETF	293.31	293.31	293.31	293.31	100.0
2019-08-02 04:37:00	SPY	ETF	293.5	293.5	293.5	293.5	200.0
2019-08-02 04:39:00	SPY	ETF	293.42	293.42	293.42	293.42	1500.0
2019-08-02 04:40:00	SPY	ETF	293.42	293.42	293.42	293.42	200.0
2019-08-02 04:50:00	SPY	ETF	293.54	293.54	293.54	293.54	500.0
2019-08-02 04:52:00	SPY	ETF	293.39	293.39	293.39	293.39	149.0
2019-08-02 04:53:00	SPY	ETF	293.24	293.24	293.1	293.1	959.0
2019-08-02 04:54:00	SPY	ETF	293.24	293.29	293.24	293.29	600.0
2019-08-02 04:58:00	SPY	ETF	293.24	293.24	293.24	293.24	200.0
2019-08-02 04:59:00	SPY	ETF	293.39	293.39	293.34	293.34	244.0
2019-08-02 05:01:00	SPY	ETF	293.39	293.39	293.39	293.39	205.0
2019-08-02 05:07:00	SPY	ETF	293.35	293.37	293.35	293.37	1676.0
2019-08-02 05:12:00	SPY	ETF	293.22	293.22	293.17	293.17	750.0
2019-08-02 05:13:00	SPY	ETF	293.17	293.17	293.14	293.14	604.0
2019-08-02 05:15:00	SPY	ETF	293.05	293.05	292.99	292.99	563.0
2019-08-02 05:17:00	SPY	ETF	293.05	293.05	293.05	293.05	505.0
2019-08-02 05:18:00	SPY	ETF	293.05	293.1	293.05	293.1	1195.0
2019-08-02 05:19:00	SPY	ETF	293.17	293.17	293.17	293.17	100.0
2019-08-02 05:21:00	SPY	ETF	293.29	293.29	293.29	293.29	100.0
2019-08-02 05:27:00	SPY	ETF	293.44	293.44	293.44	293.44	550.0
2019-08-02 05:28:00	SPY	ETF	293.5	293.5	293.5	293.5	800.0
2019-08-02 05:30:00	SPY	ETF	293.5	293.5	293.5	293.5	310.0
2019-08-02 05:32:00	SPY	ETF	293.49	293.6	293.49	293.6	624.0
2019-08-02 05:35:00	SPY	ETF	293.6	293.6	293.6	293.6	120.0
2019-08-02 05:39:00	SPY	ETF	293.6	293.6	293.6	293.6	315.0
2019-08-02 05:41:00	SPY	ETF	293.52	293.52	293.52	293.52	1400.0
2019-08-02 05:43:00	SPY	ETF	293.57	293.57	293.57	293.57	1000.0
2019-08-02 05:45:00	SPY	ETF	293.6	293.6	293.6	293.6	300.0
2019-08-02 05:49:00	SPY	ETF	293.57	293.57	293.57	293.57	200.0
2019-08-02 05:55:00	SPY	ETF	293.39	293.39	293.39	293.39	100.0
2019-08-02 05:56:00	SPY	ETF	293.39	293.39	293.39	293.39	250.0
2019-08-02 05:57:00	SPY	ETF	293.39	293.42	293.39	293.42	1000.0
2019-08-02 05:59:00	SPY	ETF	293.39	293.49	293.39	293.49	2960.0
2019-08-02 06:02:00	SPY	ETF	293.52	293.6	293.52	293.6	1410.0
2019-08-02 06:03:00	SPY	ETF	293.59	293.6	293.52	293.6	1800.0

> showing 50 of 179,922 rows — these rows as CSV

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