PREVIEW / etf_5min / 2018-11-02

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-11-02.parquet
  size:    1.5 MB
  rows:    64,222

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
2018-11-02 04:00:00	SPY	ETF	275.5	275.8	275.41	275.8	9345.0
2018-11-02 04:05:00	SPY	ETF	275.74	275.8	275.5	275.65	8885.0
2018-11-02 04:10:00	SPY	ETF	275.65	275.7	275.51	275.7	35760.0
2018-11-02 04:15:00	SPY	ETF	275.74	275.9	275.65	275.65	27190.0
2018-11-02 04:20:00	SPY	ETF	275.65	276.0	275.65	275.96	21610.0
2018-11-02 04:25:00	SPY	ETF	275.93	276.0	275.85	275.89	24500.0
2018-11-02 04:30:00	SPY	ETF	275.87	275.92	275.8	275.84	18645.0
2018-11-02 04:35:00	SPY	ETF	275.85	275.85	275.6	275.6	14800.0
2018-11-02 04:40:00	SPY	ETF	275.6	275.6	275.49	275.6	6000.0
2018-11-02 04:45:00	SPY	ETF	275.64	275.72	275.55	275.65	6145.0
2018-11-02 04:50:00	SPY	ETF	275.6	275.61	275.47	275.47	3335.0
2018-11-02 04:55:00	SPY	ETF	275.47	275.6	275.45	275.55	4360.0
2018-11-02 05:00:00	SPY	ETF	275.5	275.5	275.3	275.32	5108.0
2018-11-02 05:05:00	SPY	ETF	275.4	275.5	275.4	275.41	3142.0
2018-11-02 05:10:00	SPY	ETF	275.5	275.5	275.27	275.41	6450.0
2018-11-02 05:15:00	SPY	ETF	275.48	275.5	275.41	275.41	2701.0
2018-11-02 05:20:00	SPY	ETF	275.41	275.41	275.27	275.32	2929.0
2018-11-02 05:25:00	SPY	ETF	275.39	275.39	275.25	275.29	5020.0
2018-11-02 05:30:00	SPY	ETF	275.39	275.39	275.21	275.3	8053.0
2018-11-02 05:35:00	SPY	ETF	275.34	275.6	275.34	275.57	8378.0
2018-11-02 05:40:00	SPY	ETF	275.5	275.5	275.15	275.15	6290.0
2018-11-02 05:45:00	SPY	ETF	275.17	275.2	275.08	275.2	2957.0
2018-11-02 05:50:00	SPY	ETF	275.15	275.15	275.11	275.11	2760.0
2018-11-02 05:55:00	SPY	ETF	275.1	275.19	275.1	275.14	2246.0
2018-11-02 06:00:00	SPY	ETF	275.11	275.19	275.01	275.19	9288.0
2018-11-02 06:05:00	SPY	ETF	275.15	275.29	275.15	275.23	5936.0
2018-11-02 06:10:00	SPY	ETF	275.28	275.33	275.28	275.3	3000.0
2018-11-02 06:15:00	SPY	ETF	275.3	275.41	275.24	275.41	24075.0
2018-11-02 06:20:00	SPY	ETF	275.4	275.5	275.38	275.5	6400.0
2018-11-02 06:25:00	SPY	ETF	275.52	275.52	275.42	275.5	4875.0
2018-11-02 06:30:00	SPY	ETF	275.46	275.5	275.34	275.37	8917.0
2018-11-02 06:35:00	SPY	ETF	275.33	275.35	275.3	275.3	3879.0
2018-11-02 06:40:00	SPY	ETF	275.33	275.58	275.33	275.53	15900.0
2018-11-02 06:45:00	SPY	ETF	275.56	275.56	275.36	275.36	7441.0
2018-11-02 06:50:00	SPY	ETF	275.39	275.47	275.31	275.36	14799.0
2018-11-02 06:55:00	SPY	ETF	275.44	275.61	275.44	275.51	36412.0
2018-11-02 07:00:00	SPY	ETF	275.46	275.6	275.37	275.46	53096.0
2018-11-02 07:05:00	SPY	ETF	275.45	275.49	275.36	275.49	26045.0
2018-11-02 07:10:00	SPY	ETF	275.45	275.45	275.33	275.43	20434.0
2018-11-02 07:15:00	SPY	ETF	275.49	275.69	275.47	275.59	27626.0
2018-11-02 07:20:00	SPY	ETF	275.57	275.75	275.52	275.75	74830.0
2018-11-02 07:25:00	SPY	ETF	275.71	276.06	275.71	276.06	42228.0
2018-11-02 07:30:00	SPY	ETF	276.03	276.05	275.88	275.88	28462.0
2018-11-02 07:35:00	SPY	ETF	275.88	275.98	275.86	275.98	18285.0
2018-11-02 07:40:00	SPY	ETF	275.89	275.99	275.85	275.95	23217.0
2018-11-02 07:45:00	SPY	ETF	275.91	276.06	275.85	276.06	37218.0
2018-11-02 07:50:00	SPY	ETF	276.01	276.19	276.01	276.09	50984.0
2018-11-02 07:55:00	SPY	ETF	276.06	276.1	275.85	275.95	124795.0
2018-11-02 08:00:00	SPY	ETF	275.54	276.11	273.42	275.95	445842.0
2018-11-02 08:05:00	SPY	ETF	275.98	276.03	275.83	275.9	125502.0

> showing 50 of 64,222 rows — these rows as CSV

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