PREVIEW / etf_5min / 2019-08-12

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-12.parquet
  size:    1.4 MB
  rows:    60,742

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-12 04:00:00	SPY	ETF	292.29	292.3	292.06	292.06	3704.0
2019-08-12 04:05:00	SPY	ETF	291.97	292.01	291.43	291.44	24130.0
2019-08-12 04:10:00	SPY	ETF	291.49	291.54	291.36	291.51	2284.0
2019-08-12 04:15:00	SPY	ETF	291.45	291.45	291.45	291.45	115.0
2019-08-12 04:20:00	SPY	ETF	291.31	291.31	291.09	291.26	6014.0
2019-08-12 04:25:00	SPY	ETF	291.19	291.19	291.01	291.14	1184.0
2019-08-12 04:30:00	SPY	ETF	290.83	290.85	290.83	290.85	2780.0
2019-08-12 04:35:00	SPY	ETF	291.0	291.0	290.96	290.96	1681.0
2019-08-12 04:40:00	SPY	ETF	290.98	290.98	290.62	290.7	3434.0
2019-08-12 04:45:00	SPY	ETF	290.7	290.73	290.67	290.67	450.0
2019-08-12 04:50:00	SPY	ETF	290.49	290.5	290.26	290.26	405.0
2019-08-12 04:55:00	SPY	ETF	290.5	290.54	290.5	290.54	3600.0
2019-08-12 05:00:00	SPY	ETF	290.6	290.6	290.27	290.3	2704.0
2019-08-12 05:05:00	SPY	ETF	290.38	290.5	290.38	290.5	3757.0
2019-08-12 05:10:00	SPY	ETF	290.48	290.48	290.4	290.4	525.0
2019-08-12 05:15:00	SPY	ETF	290.4	290.4	290.4	290.4	1000.0
2019-08-12 05:20:00	SPY	ETF	290.47	290.47	290.44	290.47	550.0
2019-08-12 05:25:00	SPY	ETF	290.4	290.57	290.4	290.5	3630.0
2019-08-12 05:30:00	SPY	ETF	290.64	290.64	290.59	290.59	600.0
2019-08-12 05:35:00	SPY	ETF	290.64	290.67	290.6	290.64	2310.0
2019-08-12 05:40:00	SPY	ETF	290.65	290.65	290.51	290.51	4610.0
2019-08-12 05:45:00	SPY	ETF	290.5	290.5	290.24	290.27	4704.0
2019-08-12 05:50:00	SPY	ETF	290.2	290.26	290.18	290.18	3268.0
2019-08-12 05:55:00	SPY	ETF	290.13	290.3	290.13	290.3	3010.0
2019-08-12 06:00:00	SPY	ETF	290.28	290.28	289.92	289.92	1768.0
2019-08-12 06:05:00	SPY	ETF	290.0	290.14	290.0	290.08	3263.0
2019-08-12 06:10:00	SPY	ETF	290.11	290.11	290.11	290.11	420.0
2019-08-12 06:15:00	SPY	ETF	290.22	290.33	290.22	290.27	3300.0
2019-08-12 06:25:00	SPY	ETF	290.28	290.28	289.86	289.95	3089.0
2019-08-12 06:30:00	SPY	ETF	289.9	289.9	289.55	289.55	2513.0
2019-08-12 06:35:00	SPY	ETF	289.6	289.78	289.52	289.6	3494.0
2019-08-12 06:40:00	SPY	ETF	289.53	289.58	289.35	289.35	8079.0
2019-08-12 06:45:00	SPY	ETF	289.38	289.56	289.38	289.55	11409.0
2019-08-12 06:50:00	SPY	ETF	289.6	289.91	289.6	289.86	11239.0
2019-08-12 06:55:00	SPY	ETF	289.91	290.02	289.87	289.98	5474.0
2019-08-12 07:00:00	SPY	ETF	290.01	290.11	289.97	290.06	4959.0
2019-08-12 07:05:00	SPY	ETF	290.12	290.12	289.95	289.97	16733.0
2019-08-12 07:10:00	SPY	ETF	289.97	290.07	289.9	289.9	15733.0
2019-08-12 07:15:00	SPY	ETF	289.9	289.93	289.5	289.5	38969.0
2019-08-12 07:20:00	SPY	ETF	289.57	289.6	289.14	289.14	30093.0
2019-08-12 07:25:00	SPY	ETF	289.17	289.45	289.05	289.45	31838.0
2019-08-12 07:30:00	SPY	ETF	289.44	289.53	289.34	289.52	13231.0
2019-08-12 07:35:00	SPY	ETF	289.5	289.87	289.43	289.87	34894.0
2019-08-12 07:40:00	SPY	ETF	289.85	289.9	289.66	289.77	39878.0
2019-08-12 07:45:00	SPY	ETF	289.75	289.91	289.65	289.91	18605.0
2019-08-12 07:50:00	SPY	ETF	289.91	289.91	289.72	289.8	29699.0
2019-08-12 07:55:00	SPY	ETF	289.7	289.71	289.52	289.63	13966.0
2019-08-12 08:00:00	SPY	ETF	289.65	292.75	289.13	290.03	103892.0
2019-08-12 08:05:00	SPY	ETF	290.04	290.34	290.0	290.16	70986.0
2019-08-12 08:10:00	SPY	ETF	290.15	291.62	289.98	290.0	45362.0

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

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