PREVIEW / etf_5min / 2018-10-02

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-10-02.parquet
  size:    1.4 MB
  rows:    60,717

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-10-02 04:00:00	SPY	ETF	291.33	291.33	291.33	291.33	400.0
2018-10-02 04:05:00	SPY	ETF	291.28	291.28	291.25	291.25	2250.0
2018-10-02 04:10:00	SPY	ETF	291.25	291.29	291.25	291.25	2200.0
2018-10-02 04:15:00	SPY	ETF	291.25	291.25	291.25	291.25	250.0
2018-10-02 04:20:00	SPY	ETF	291.25	291.25	291.14	291.14	1350.0
2018-10-02 04:25:00	SPY	ETF	291.14	291.14	291.12	291.12	500.0
2018-10-02 04:30:00	SPY	ETF	291.01	291.01	291.0	291.0	5650.0
2018-10-02 04:40:00	SPY	ETF	291.05	291.05	290.89	290.89	1300.0
2018-10-02 04:45:00	SPY	ETF	290.92	290.92	290.8	290.8	1800.0
2018-10-02 04:50:00	SPY	ETF	290.69	290.81	290.69	290.81	250.0
2018-10-02 04:55:00	SPY	ETF	290.8	290.8	290.8	290.8	150.0
2018-10-02 05:00:00	SPY	ETF	290.6	290.6	290.6	290.6	300.0
2018-10-02 05:05:00	SPY	ETF	290.62	290.62	290.62	290.62	100.0
2018-10-02 05:10:00	SPY	ETF	290.57	290.57	290.54	290.54	1480.0
2018-10-02 05:15:00	SPY	ETF	290.62	290.64	290.62	290.64	500.0
2018-10-02 05:25:00	SPY	ETF	290.79	290.82	290.79	290.82	2152.0
2018-10-02 05:30:00	SPY	ETF	290.72	290.72	290.65	290.65	570.0
2018-10-02 05:35:00	SPY	ETF	290.67	290.67	290.64	290.64	1000.0
2018-10-02 05:40:00	SPY	ETF	290.7	290.7	290.7	290.7	150.0
2018-10-02 05:45:00	SPY	ETF	290.75	290.75	290.75	290.75	1000.0
2018-10-02 06:00:00	SPY	ETF	290.86	290.86	290.83	290.83	3300.0
2018-10-02 06:05:00	SPY	ETF	290.87	290.99	290.81	290.99	1903.0
2018-10-02 06:10:00	SPY	ETF	290.96	290.96	290.94	290.94	2810.0
2018-10-02 06:15:00	SPY	ETF	290.96	290.96	290.96	290.96	400.0
2018-10-02 06:25:00	SPY	ETF	290.89	290.89	290.89	290.89	271.0
2018-10-02 06:35:00	SPY	ETF	290.84	290.9	290.84	290.9	1300.0
2018-10-02 06:40:00	SPY	ETF	290.96	290.96	290.94	290.96	7000.0
2018-10-02 06:45:00	SPY	ETF	290.98	290.98	290.98	290.98	500.0
2018-10-02 06:50:00	SPY	ETF	291.06	291.1	291.06	291.1	7000.0
2018-10-02 06:55:00	SPY	ETF	291.15	291.15	291.15	291.15	100.0
2018-10-02 07:00:00	SPY	ETF	291.17	291.17	291.14	291.17	5280.0
2018-10-02 07:05:00	SPY	ETF	291.2	291.25	291.2	291.21	1400.0
2018-10-02 07:10:00	SPY	ETF	291.18	291.18	291.18	291.18	100.0
2018-10-02 07:15:00	SPY	ETF	291.09	291.09	291.09	291.09	455.0
2018-10-02 07:20:00	SPY	ETF	291.03	291.05	291.01	291.01	7753.0
2018-10-02 07:25:00	SPY	ETF	290.94	291.01	290.94	291.01	11000.0
2018-10-02 07:30:00	SPY	ETF	291.09	291.19	291.05	291.19	25805.0
2018-10-02 07:35:00	SPY	ETF	291.25	291.25	291.19	291.24	31125.0
2018-10-02 07:40:00	SPY	ETF	291.24	291.24	291.22	291.22	1250.0
2018-10-02 07:45:00	SPY	ETF	291.22	291.22	291.12	291.16	16571.0
2018-10-02 07:50:00	SPY	ETF	291.24	291.27	291.24	291.25	16450.0
2018-10-02 07:55:00	SPY	ETF	291.25	291.25	291.2	291.22	1600.0
2018-10-02 08:00:00	SPY	ETF	291.73	291.73	291.02	291.27	16065.0
2018-10-02 08:05:00	SPY	ETF	291.24	291.4	291.18	291.33	27446.0
2018-10-02 08:10:00	SPY	ETF	291.34	291.4	291.31	291.39	19683.0
2018-10-02 08:15:00	SPY	ETF	291.4	291.45	291.4	291.42	26995.0
2018-10-02 08:20:00	SPY	ETF	291.44	291.44	291.36	291.41	7650.0
2018-10-02 08:25:00	SPY	ETF	291.42	291.47	291.39	291.45	9948.0
2018-10-02 08:30:00	SPY	ETF	291.44	291.44	291.41	291.43	4611.0
2018-10-02 08:35:00	SPY	ETF	291.39	291.39	291.33	291.33	30480.0

> showing 50 of 60,717 rows — these rows as CSV

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