PREVIEW / etf_5min / 2019-07-23

all etf 5-min files

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

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-23 04:00:00	SPY	ETF	298.45	298.5	298.45	298.5	1262.0
2019-07-23 04:05:00	SPY	ETF	298.46	298.46	298.46	298.46	3000.0
2019-07-23 04:10:00	SPY	ETF	298.48	298.6	298.48	298.6	5379.0
2019-07-23 04:15:00	SPY	ETF	298.62	298.65	298.56	298.56	700.0
2019-07-23 04:20:00	SPY	ETF	298.53	298.62	298.53	298.58	1914.0
2019-07-23 04:25:00	SPY	ETF	298.58	298.58	298.56	298.56	338.0
2019-07-23 04:30:00	SPY	ETF	298.57	298.78	298.54	298.73	4976.0
2019-07-23 04:35:00	SPY	ETF	298.7	298.7	298.68	298.68	338.0
2019-07-23 04:40:00	SPY	ETF	298.66	298.7	298.65	298.7	638.0
2019-07-23 04:45:00	SPY	ETF	298.72	298.76	298.68	298.76	707.0
2019-07-23 04:50:00	SPY	ETF	298.8	298.8	298.8	298.8	100.0
2019-07-23 05:00:00	SPY	ETF	298.75	298.75	298.73	298.73	1338.0
2019-07-23 05:05:00	SPY	ETF	298.72	298.72	298.7	298.7	1338.0
2019-07-23 05:15:00	SPY	ETF	298.71	298.75	298.7	298.75	2094.0
2019-07-23 05:20:00	SPY	ETF	298.75	298.76	298.71	298.75	2375.0
2019-07-23 05:30:00	SPY	ETF	298.76	298.76	298.76	298.76	210.0
2019-07-23 05:35:00	SPY	ETF	298.76	298.76	298.75	298.75	400.0
2019-07-23 05:45:00	SPY	ETF	298.75	298.75	298.75	298.75	200.0
2019-07-23 05:55:00	SPY	ETF	298.74	298.74	298.74	298.74	100.0
2019-07-23 06:00:00	SPY	ETF	298.75	298.78	298.75	298.78	1462.0
2019-07-23 06:05:00	SPY	ETF	298.78	298.78	298.78	298.78	750.0
2019-07-23 06:10:00	SPY	ETF	298.78	298.88	298.78	298.88	3276.0
2019-07-23 06:15:00	SPY	ETF	298.93	298.93	298.92	298.92	5031.0
2019-07-23 06:20:00	SPY	ETF	298.9	298.92	298.88	298.92	2701.0
2019-07-23 06:25:00	SPY	ETF	298.91	298.98	298.91	298.98	3490.0
2019-07-23 06:30:00	SPY	ETF	298.93	298.93	298.93	298.93	3000.0
2019-07-23 06:35:00	SPY	ETF	298.93	298.98	298.9	298.9	8500.0
2019-07-23 06:45:00	SPY	ETF	298.87	298.87	298.87	298.87	100.0
2019-07-23 06:50:00	SPY	ETF	298.88	298.95	298.88	298.93	300.0
2019-07-23 06:55:00	SPY	ETF	298.89	298.9	298.88	298.9	1007.0
2019-07-23 07:00:00	SPY	ETF	298.9	298.97	298.9	298.94	8031.0
2019-07-23 07:05:00	SPY	ETF	298.94	298.97	298.94	298.97	2160.0
2019-07-23 07:10:00	SPY	ETF	298.98	299.02	298.93	299.02	18881.0
2019-07-23 07:15:00	SPY	ETF	298.99	298.99	298.95	298.95	3075.0
2019-07-23 07:20:00	SPY	ETF	298.93	299.07	298.93	299.07	19034.0
2019-07-23 07:25:00	SPY	ETF	299.0	299.0	298.98	298.98	847.0
2019-07-23 07:30:00	SPY	ETF	298.97	298.97	298.94	298.94	5044.0
2019-07-23 07:35:00	SPY	ETF	299.0	299.08	298.94	298.94	2849.0
2019-07-23 07:40:00	SPY	ETF	298.95	298.96	298.95	298.96	400.0
2019-07-23 07:45:00	SPY	ETF	298.96	298.96	298.91	298.92	1961.0
2019-07-23 07:50:00	SPY	ETF	298.93	298.93	298.85	298.88	11580.0
2019-07-23 07:55:00	SPY	ETF	298.9	298.91	298.9	298.91	386.0
2019-07-23 08:00:00	SPY	ETF	298.8999	299.05	297.9	298.99	15567.0
2019-07-23 08:05:00	SPY	ETF	299.0	299.2	299.0	299.17	20264.0
2019-07-23 08:10:00	SPY	ETF	299.17	299.22	299.13	299.16	11268.0
2019-07-23 08:15:00	SPY	ETF	299.17	299.2	299.15	299.16	6992.0
2019-07-23 08:20:00	SPY	ETF	299.17	299.18	299.09	299.09	14533.0
2019-07-23 08:25:00	SPY	ETF	299.1	299.15	299.1	299.12	2300.0
2019-07-23 08:30:00	SPY	ETF	299.12	299.12	299.12	299.12	100.0
2019-07-23 08:35:00	SPY	ETF	299.15	299.23	299.14	299.22	9536.0

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

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