PREVIEW / etf_5min / 2019-08-05

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-05.parquet
  size:    1.8 MB
  rows:    74,840

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-05 04:00:00	SPY	ETF	289.7	289.7	289.26	289.31	7468.0
2019-08-05 04:05:00	SPY	ETF	289.31	289.31	288.88	288.88	3760.0
2019-08-05 04:10:00	SPY	ETF	288.93	289.06	288.91	288.92	3010.0
2019-08-05 04:15:00	SPY	ETF	288.92	289.05	288.92	289.02	2250.0
2019-08-05 04:20:00	SPY	ETF	288.92	288.95	288.85	288.85	17415.0
2019-08-05 04:25:00	SPY	ETF	288.85	288.85	288.85	288.85	270.0
2019-08-05 04:30:00	SPY	ETF	288.8	289.08	288.67	289.08	1593.0
2019-08-05 04:35:00	SPY	ETF	289.04	289.11	288.95	289.08	3325.0
2019-08-05 04:40:00	SPY	ETF	289.16	289.18	289.08	289.08	4611.0
2019-08-05 04:45:00	SPY	ETF	289.14	289.14	289.05	289.05	1380.0
2019-08-05 04:50:00	SPY	ETF	288.93	288.93	288.93	288.93	195.0
2019-08-05 04:55:00	SPY	ETF	288.95	288.95	288.6	288.63	5249.0
2019-08-05 05:00:00	SPY	ETF	288.5	288.58	288.42	288.49	9899.0
2019-08-05 05:05:00	SPY	ETF	288.5	288.56	288.43	288.49	2957.0
2019-08-05 05:10:00	SPY	ETF	288.43	288.43	288.4	288.4	10006.0
2019-08-05 05:15:00	SPY	ETF	288.58	288.58	288.41	288.43	10630.0
2019-08-05 05:20:00	SPY	ETF	288.43	288.51	288.43	288.43	705.0
2019-08-05 05:25:00	SPY	ETF	288.46	289.3	288.31	288.98	17771.0
2019-08-05 05:30:00	SPY	ETF	289.08	289.39	289.08	289.19	10048.0
2019-08-05 05:35:00	SPY	ETF	289.08	289.43	289.08	289.39	10758.0
2019-08-05 05:40:00	SPY	ETF	289.4	289.75	289.38	289.48	25532.0
2019-08-05 05:45:00	SPY	ETF	289.54	289.68	289.54	289.63	3598.0
2019-08-05 05:50:00	SPY	ETF	289.61	289.61	289.41	289.41	19589.0
2019-08-05 05:55:00	SPY	ETF	289.5	289.5	289.5	289.5	300.0
2019-08-05 06:00:00	SPY	ETF	289.5	289.65	289.49	289.65	2827.0
2019-08-05 06:05:00	SPY	ETF	289.6	289.6	289.6	289.6	200.0
2019-08-05 06:10:00	SPY	ETF	289.56	289.66	289.41	289.46	11050.0
2019-08-05 06:15:00	SPY	ETF	289.44	289.45	289.03	289.06	48203.0
2019-08-05 06:20:00	SPY	ETF	289.22	289.22	289.12	289.14	10399.0
2019-08-05 06:25:00	SPY	ETF	289.05	289.05	289.0	289.05	12355.0
2019-08-05 06:30:00	SPY	ETF	289.04	289.09	288.91	288.99	13753.0
2019-08-05 06:35:00	SPY	ETF	289.0	289.02	288.97	288.98	15835.0
2019-08-05 06:40:00	SPY	ETF	288.98	289.1	288.95	288.99	1870.0
2019-08-05 06:45:00	SPY	ETF	288.95	288.95	288.85	288.85	2405.0
2019-08-05 06:50:00	SPY	ETF	288.85	288.9	288.85	288.86	33695.0
2019-08-05 06:55:00	SPY	ETF	288.98	289.05	288.85	288.93	7932.0
2019-08-05 07:00:00	SPY	ETF	288.93	288.98	288.6	288.68	143635.0
2019-08-05 07:05:00	SPY	ETF	288.7	288.7	288.55	288.55	41328.0
2019-08-05 07:10:00	SPY	ETF	288.55	288.8	288.38	288.74	77334.0
2019-08-05 07:15:00	SPY	ETF	288.69	288.8	288.4	288.41	15206.0
2019-08-05 07:20:00	SPY	ETF	288.5	288.56	288.25	288.26	20540.0
2019-08-05 07:25:00	SPY	ETF	288.25	288.45	288.24	288.29	17228.0
2019-08-05 07:30:00	SPY	ETF	288.3	289.0	288.3	289.0	88195.0
2019-08-05 07:35:00	SPY	ETF	289.0	289.07	288.75	288.84	149514.0
2019-08-05 07:40:00	SPY	ETF	288.76	288.98	288.58	288.86	31047.0
2019-08-05 07:45:00	SPY	ETF	288.88	289.1	288.88	289.0	59599.0
2019-08-05 07:50:00	SPY	ETF	289.01	289.04	288.73	289.01	25549.0
2019-08-05 07:55:00	SPY	ETF	289.01	289.19	288.98	289.01	37043.0
2019-08-05 08:00:00	SPY	ETF	289.04	292.62	288.28	288.77	95478.0
2019-08-05 08:05:00	SPY	ETF	288.86	289.03	288.84	288.94	62293.0

> showing 50 of 74,840 rows — these rows as CSV

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