PREVIEW / etf_5min / 2019-09-12

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-09-12.parquet
  size:    1.5 MB
  rows:    64,123

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-09-12 04:00:00	SPY	ETF	301.15	301.22	301.13	301.14	1998.0
2019-09-12 04:05:00	SPY	ETF	301.14	301.14	301.14	301.14	531.0
2019-09-12 04:15:00	SPY	ETF	301.07	301.09	301.02	301.02	745.0
2019-09-12 04:20:00	SPY	ETF	301.1	301.1	301.1	301.1	200.0
2019-09-12 04:25:00	SPY	ETF	301.15	301.15	301.15	301.15	150.0
2019-09-12 04:30:00	SPY	ETF	301.19	301.19	301.15	301.15	1090.0
2019-09-12 04:35:00	SPY	ETF	301.13	301.14	301.1	301.14	508.0
2019-09-12 04:40:00	SPY	ETF	301.13	301.13	301.08	301.08	4000.0
2019-09-12 04:50:00	SPY	ETF	300.98	300.98	300.98	300.98	130.0
2019-09-12 04:55:00	SPY	ETF	300.98	300.98	300.95	300.95	900.0
2019-09-12 05:00:00	SPY	ETF	301.04	301.04	301.04	301.04	200.0
2019-09-12 05:05:00	SPY	ETF	301.05	301.05	301.0	301.0	1855.0
2019-09-12 05:10:00	SPY	ETF	300.98	300.98	300.98	300.98	400.0
2019-09-12 05:15:00	SPY	ETF	301.0	301.0	301.0	301.0	100.0
2019-09-12 05:20:00	SPY	ETF	301.02	301.02	300.99	300.99	1000.0
2019-09-12 05:25:00	SPY	ETF	300.98	300.98	300.98	300.98	100.0
2019-09-12 05:35:00	SPY	ETF	300.94	300.94	300.89	300.89	300.0
2019-09-12 05:40:00	SPY	ETF	300.93	300.94	300.93	300.94	1200.0
2019-09-12 05:45:00	SPY	ETF	300.94	300.94	300.89	300.9	2325.0
2019-09-12 05:55:00	SPY	ETF	300.89	300.93	300.89	300.93	200.0
2019-09-12 06:05:00	SPY	ETF	300.98	301.0	300.98	301.0	13377.0
2019-09-12 06:10:00	SPY	ETF	301.0	301.02	300.95	301.02	28420.0
2019-09-12 06:15:00	SPY	ETF	300.96	300.96	300.96	300.96	301.0
2019-09-12 06:20:00	SPY	ETF	300.94	301.0	300.94	301.0	5105.0
2019-09-12 06:25:00	SPY	ETF	300.98	300.98	300.78	300.78	5492.0
2019-09-12 06:30:00	SPY	ETF	300.93	300.93	300.88	300.89	1500.0
2019-09-12 06:35:00	SPY	ETF	300.95	300.95	300.85	300.85	2610.0
2019-09-12 06:40:00	SPY	ETF	300.85	300.93	300.85	300.87	3300.0
2019-09-12 06:45:00	SPY	ETF	300.83	300.88	300.83	300.83	6540.0
2019-09-12 06:50:00	SPY	ETF	300.86	300.86	300.85	300.85	215.0
2019-09-12 06:55:00	SPY	ETF	300.85	300.85	300.78	300.78	500.0
2019-09-12 07:00:00	SPY	ETF	300.82	300.92	300.79	300.91	28275.0
2019-09-12 07:05:00	SPY	ETF	300.92	300.95	300.91	300.95	3735.0
2019-09-12 07:10:00	SPY	ETF	300.92	300.97	300.85	300.9	32980.0
2019-09-12 07:15:00	SPY	ETF	300.91	300.92	300.91	300.92	3344.0
2019-09-12 07:20:00	SPY	ETF	300.91	300.97	300.9	300.95	21066.0
2019-09-12 07:25:00	SPY	ETF	300.93	301.0	300.88	300.93	28261.0
2019-09-12 07:30:00	SPY	ETF	300.9	301.01	300.89	301.0	112440.0
2019-09-12 07:35:00	SPY	ETF	301.0	301.11	301.0	301.06	78547.0
2019-09-12 07:40:00	SPY	ETF	301.04	301.11	301.0	301.02	108912.0
2019-09-12 07:45:00	SPY	ETF	301.0	301.55	300.54	301.42	347972.0
2019-09-12 07:50:00	SPY	ETF	301.43	301.57	301.21	301.42	147545.0
2019-09-12 07:55:00	SPY	ETF	301.43	301.43	301.23	301.25	28586.0
2019-09-12 08:00:00	SPY	ETF	300.8499	301.84	300.79	301.29	204404.0
2019-09-12 08:05:00	SPY	ETF	301.28	301.42	301.18	301.28	111093.0
2019-09-12 08:10:00	SPY	ETF	301.25	301.33	301.01	301.19	129026.0
2019-09-12 08:15:00	SPY	ETF	301.29	301.33	301.09	301.18	15591.0
2019-09-12 08:20:00	SPY	ETF	301.18	301.22	301.06	301.08	32521.0
2019-09-12 08:25:00	SPY	ETF	301.08	301.2	300.97	301.12	50088.0
2019-09-12 08:30:00	SPY	ETF	301.02	301.21	301.0	301.16	41177.0

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

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