PREVIEW / etf_5min / 2019-07-08

all etf 5-min files

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

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-07-08 04:00:00	SPY	ETF	297.61	297.61	297.6	297.6	535.0
2019-07-08 04:05:00	SPY	ETF	297.69	297.71	297.67	297.71	1690.0
2019-07-08 04:10:00	SPY	ETF	297.65	297.69	297.65	297.69	876.0
2019-07-08 04:15:00	SPY	ETF	297.72	297.77	297.72	297.77	1077.0
2019-07-08 04:25:00	SPY	ETF	297.67	297.67	297.67	297.67	300.0
2019-07-08 04:30:00	SPY	ETF	297.64	297.64	297.64	297.64	300.0
2019-07-08 04:35:00	SPY	ETF	297.66	297.66	297.66	297.66	400.0
2019-07-08 04:40:00	SPY	ETF	297.57	297.57	297.57	297.57	250.0
2019-07-08 04:45:00	SPY	ETF	297.54	297.54	297.51	297.51	986.0
2019-07-08 04:50:00	SPY	ETF	297.51	297.51	297.51	297.51	2100.0
2019-07-08 05:00:00	SPY	ETF	297.51	297.51	297.51	297.51	350.0
2019-07-08 05:05:00	SPY	ETF	297.5	297.5	297.5	297.5	1100.0
2019-07-08 05:10:00	SPY	ETF	297.27	297.27	297.26	297.26	2500.0
2019-07-08 05:15:00	SPY	ETF	297.22	297.22	297.22	297.22	1000.0
2019-07-08 05:20:00	SPY	ETF	297.26	297.26	297.18	297.18	1000.0
2019-07-08 05:25:00	SPY	ETF	297.2	297.2	297.2	297.2	510.0
2019-07-08 05:30:00	SPY	ETF	297.2	297.26	297.17	297.26	437.0
2019-07-08 05:35:00	SPY	ETF	297.33	297.33	297.28	297.28	1000.0
2019-07-08 05:40:00	SPY	ETF	297.4	297.4	297.4	297.4	100.0
2019-07-08 05:45:00	SPY	ETF	297.28	297.28	297.28	297.28	500.0
2019-07-08 05:55:00	SPY	ETF	297.35	297.37	297.35	297.37	500.0
2019-07-08 06:00:00	SPY	ETF	297.35	297.35	297.35	297.35	1000.0
2019-07-08 06:05:00	SPY	ETF	297.45	297.45	297.45	297.45	100.0
2019-07-08 06:15:00	SPY	ETF	297.35	297.4	297.35	297.4	200.0
2019-07-08 06:25:00	SPY	ETF	297.3	297.3	297.3	297.3	520.0
2019-07-08 06:30:00	SPY	ETF	297.3	297.3	297.3	297.3	500.0
2019-07-08 06:35:00	SPY	ETF	297.3	297.3	297.28	297.28	200.0
2019-07-08 06:40:00	SPY	ETF	297.25	297.25	297.25	297.25	100.0
2019-07-08 06:45:00	SPY	ETF	297.22	297.22	297.2	297.2	300.0
2019-07-08 06:50:00	SPY	ETF	297.2	297.2	297.2	297.2	100.0
2019-07-08 06:55:00	SPY	ETF	297.2	297.2	297.2	297.2	100.0
2019-07-08 07:00:00	SPY	ETF	297.22	297.32	297.22	297.32	4983.0
2019-07-08 07:05:00	SPY	ETF	297.34	297.47	297.31	297.44	17254.0
2019-07-08 07:10:00	SPY	ETF	297.44	297.52	297.42	297.42	4850.0
2019-07-08 07:15:00	SPY	ETF	297.4	297.47	297.38	297.44	3130.0
2019-07-08 07:20:00	SPY	ETF	297.4	297.44	297.4	297.44	6086.0
2019-07-08 07:25:00	SPY	ETF	297.41	297.45	297.41	297.45	550.0
2019-07-08 07:30:00	SPY	ETF	297.5	297.5	297.46	297.46	2236.0
2019-07-08 07:35:00	SPY	ETF	297.46	297.47	297.39	297.47	4711.0
2019-07-08 07:40:00	SPY	ETF	297.36	297.42	297.36	297.36	1245.0
2019-07-08 07:45:00	SPY	ETF	297.36	297.4	297.34	297.34	26020.0
2019-07-08 07:50:00	SPY	ETF	297.34	297.34	297.34	297.34	5300.0
2019-07-08 07:55:00	SPY	ETF	297.31	297.31	297.22	297.22	4995.0
2019-07-08 08:00:00	SPY	ETF	297.4	297.49	296.92	297.27	79804.0
2019-07-08 08:05:00	SPY	ETF	297.29	297.31	297.28	297.28	26380.0
2019-07-08 08:10:00	SPY	ETF	297.26	297.3	297.25	297.3	25228.0
2019-07-08 08:15:00	SPY	ETF	297.32	297.34	297.32	297.34	3300.0
2019-07-08 08:20:00	SPY	ETF	297.34	297.37	297.27	297.27	22935.0
2019-07-08 08:25:00	SPY	ETF	297.3	297.3	297.23	297.27	16469.0
2019-07-08 08:30:00	SPY	ETF	297.29	297.31	297.25	297.29	10770.0

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

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