PREVIEW / etf_5min / 2019-04-29

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-04-29.parquet
  size:    1.4 MB
  rows:    59,718

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-04-29 04:00:00	SPY	ETF	293.56	293.56	293.56	293.56	100.0
2019-04-29 04:10:00	SPY	ETF	293.65	293.89	293.65	293.89	2410.0
2019-04-29 04:15:00	SPY	ETF	293.84	293.84	293.84	293.84	200.0
2019-04-29 04:20:00	SPY	ETF	293.84	293.85	293.84	293.85	300.0
2019-04-29 04:30:00	SPY	ETF	293.74	293.74	293.74	293.74	350.0
2019-04-29 04:50:00	SPY	ETF	293.71	293.71	293.64	293.64	1420.0
2019-04-29 04:55:00	SPY	ETF	293.69	293.69	293.69	293.69	100.0
2019-04-29 05:25:00	SPY	ETF	293.4	293.4	293.36	293.36	640.0
2019-04-29 05:30:00	SPY	ETF	293.46	293.46	293.46	293.46	350.0
2019-04-29 05:45:00	SPY	ETF	293.4	293.4	293.4	293.4	200.0
2019-04-29 05:50:00	SPY	ETF	293.4	293.42	293.4	293.42	321.0
2019-04-29 06:00:00	SPY	ETF	293.38	293.38	293.35	293.35	2111.0
2019-04-29 06:10:00	SPY	ETF	293.44	293.44	293.44	293.44	169.0
2019-04-29 06:20:00	SPY	ETF	293.46	293.46	293.45	293.45	250.0
2019-04-29 06:25:00	SPY	ETF	293.39	293.39	293.39	293.39	500.0
2019-04-29 06:30:00	SPY	ETF	293.35	293.35	293.28	293.28	3820.0
2019-04-29 06:35:00	SPY	ETF	293.36	293.36	293.36	293.36	250.0
2019-04-29 06:40:00	SPY	ETF	293.31	293.31	293.28	293.28	1900.0
2019-04-29 06:45:00	SPY	ETF	293.23	293.27	293.23	293.27	1455.0
2019-04-29 06:50:00	SPY	ETF	293.27	293.27	293.2	293.2	2400.0
2019-04-29 06:55:00	SPY	ETF	293.18	293.21	293.17	293.21	2718.0
2019-04-29 07:00:00	SPY	ETF	293.21	293.23	293.19	293.19	2533.0
2019-04-29 07:05:00	SPY	ETF	293.19	293.21	293.19	293.19	2105.0
2019-04-29 07:10:00	SPY	ETF	293.19	293.26	293.06	293.26	8278.0
2019-04-29 07:15:00	SPY	ETF	293.3	293.3	293.3	293.3	100.0
2019-04-29 07:20:00	SPY	ETF	293.3	293.3	293.3	293.3	4020.0
2019-04-29 07:25:00	SPY	ETF	293.19	293.21	293.12	293.12	3504.0
2019-04-29 07:30:00	SPY	ETF	293.19	293.29	293.19	293.27	2631.0
2019-04-29 07:35:00	SPY	ETF	293.29	293.31	293.25	293.31	1619.0
2019-04-29 07:40:00	SPY	ETF	293.3	293.31	293.3	293.31	1250.0
2019-04-29 07:45:00	SPY	ETF	293.31	293.31	293.3	293.3	251.0
2019-04-29 07:50:00	SPY	ETF	293.3	293.3	293.29	293.29	1165.0
2019-04-29 07:55:00	SPY	ETF	293.24	293.29	293.24	293.29	455.0
2019-04-29 08:00:00	SPY	ETF	293.19	293.57	293.14	293.31	9170.0
2019-04-29 08:05:00	SPY	ETF	293.31	293.36	293.31	293.36	940.0
2019-04-29 08:10:00	SPY	ETF	293.32	293.36	293.32	293.36	1030.0
2019-04-29 08:15:00	SPY	ETF	293.3	293.3	293.28	293.28	1512.0
2019-04-29 08:20:00	SPY	ETF	293.32	293.33	293.32	293.33	1401.0
2019-04-29 08:25:00	SPY	ETF	293.25	293.39	293.25	293.39	7550.0
2019-04-29 08:30:00	SPY	ETF	293.44	293.51	293.41	293.47	54988.0
2019-04-29 08:35:00	SPY	ETF	293.47	293.48	293.45	293.47	5307.0
2019-04-29 08:40:00	SPY	ETF	293.45	293.45	293.28	293.28	12364.0
2019-04-29 08:45:00	SPY	ETF	293.27	293.2999	293.22	293.22	17668.0
2019-04-29 08:50:00	SPY	ETF	293.23	293.35	293.23	293.35	12054.0
2019-04-29 08:55:00	SPY	ETF	293.37	293.45	293.37	293.45	11151.0
2019-04-29 09:00:00	SPY	ETF	293.47	293.47	293.39	293.39	11604.0
2019-04-29 09:05:00	SPY	ETF	293.38	293.46	293.37	293.43	11471.0
2019-04-29 09:10:00	SPY	ETF	293.43	293.49	293.43	293.48	6839.0
2019-04-29 09:15:00	SPY	ETF	293.49	293.6	293.49	293.56	28108.0
2019-04-29 09:20:00	SPY	ETF	293.58	293.58	293.52	293.54	27610.0

> showing 50 of 59,718 rows — these rows as CSV

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