PREVIEW / etf_5min / 2020-07-13

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-07-13.parquet
  size:    1.7 MB
  rows:    79,528

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
2020-07-13 04:00:00	SPY	ETF	319.0	319.11	318.87	318.87	5752.0
2020-07-13 04:05:00	SPY	ETF	318.97	319.16	318.9	319.16	2416.0
2020-07-13 04:10:00	SPY	ETF	319.14	319.19	319.14	319.15	1376.0
2020-07-13 04:15:00	SPY	ETF	319.14	319.21	318.85	318.85	68825.0
2020-07-13 04:20:00	SPY	ETF	318.91	318.91	318.76	318.86	8767.0
2020-07-13 04:25:00	SPY	ETF	318.81	318.93	318.81	318.93	5544.0
2020-07-13 04:30:00	SPY	ETF	318.95	318.95	318.45	318.45	4983.0
2020-07-13 04:35:00	SPY	ETF	318.47	318.7	318.45	318.64	1305.0
2020-07-13 04:40:00	SPY	ETF	318.7	318.8	318.68	318.8	3197.0
2020-07-13 04:45:00	SPY	ETF	318.83	318.98	318.83	318.93	404.0
2020-07-13 04:50:00	SPY	ETF	318.95	318.95	318.95	318.95	573.0
2020-07-13 04:55:00	SPY	ETF	318.84	318.84	318.83	318.83	1320.0
2020-07-13 05:00:00	SPY	ETF	319.0	319.14	319.0	319.14	6300.0
2020-07-13 05:10:00	SPY	ETF	319.05	319.05	319.05	319.05	5320.0
2020-07-13 05:15:00	SPY	ETF	319.05	319.2	319.05	319.2	50480.0
2020-07-13 05:20:00	SPY	ETF	319.07	319.09	318.67	318.72	1483.0
2020-07-13 05:25:00	SPY	ETF	318.67	318.86	318.67	318.86	1560.0
2020-07-13 05:30:00	SPY	ETF	318.92	318.96	318.83	318.96	4106.0
2020-07-13 05:35:00	SPY	ETF	319.05	319.21	319.05	319.21	2610.0
2020-07-13 05:40:00	SPY	ETF	319.15	319.16	319.12	319.15	2070.0
2020-07-13 05:45:00	SPY	ETF	319.04	319.22	319.04	319.22	1442.0
2020-07-13 05:50:00	SPY	ETF	319.15	319.15	319.15	319.15	1500.0
2020-07-13 05:55:00	SPY	ETF	319.18	319.34	319.18	319.34	736.0
2020-07-13 06:00:00	SPY	ETF	319.28	319.3	319.25	319.3	2150.0
2020-07-13 06:05:00	SPY	ETF	319.27	319.42	319.02	319.42	7211.0
2020-07-13 06:10:00	SPY	ETF	319.37	319.37	319.15	319.22	2248.0
2020-07-13 06:15:00	SPY	ETF	319.39	319.42	319.39	319.39	2035.0
2020-07-13 06:20:00	SPY	ETF	319.37	319.37	319.3	319.3	317.0
2020-07-13 06:25:00	SPY	ETF	319.27	319.35	319.27	319.35	2300.0
2020-07-13 06:30:00	SPY	ETF	319.31	319.45	319.27	319.42	9231.0
2020-07-13 06:35:00	SPY	ETF	319.38	319.38	319.21	319.21	3265.0
2020-07-13 06:40:00	SPY	ETF	319.25	319.25	319.13	319.13	616.0
2020-07-13 06:45:00	SPY	ETF	319.14	319.23	319.14	319.23	6145.0
2020-07-13 06:50:00	SPY	ETF	319.35	319.78	319.35	319.7	5683.0
2020-07-13 06:55:00	SPY	ETF	319.73	319.83	319.73	319.78	8539.0
2020-07-13 07:00:00	SPY	ETF	319.74	319.92	319.7	319.9	29505.0
2020-07-13 07:05:00	SPY	ETF	319.92	320.19	319.88	320.19	21460.0
2020-07-13 07:10:00	SPY	ETF	320.15	320.51	320.1	320.34	24104.0
2020-07-13 07:15:00	SPY	ETF	320.35	320.35	320.13	320.15	15826.0
2020-07-13 07:20:00	SPY	ETF	320.15	320.17	320.09	320.14	13185.0
2020-07-13 07:25:00	SPY	ETF	320.15	320.25	320.14	320.2	8934.0
2020-07-13 07:30:00	SPY	ETF	320.22	320.28	320.12	320.2	25873.0
2020-07-13 07:35:00	SPY	ETF	320.22	320.25	320.15	320.16	21090.0
2020-07-13 07:40:00	SPY	ETF	320.16	320.22	320.15	320.18	10122.0
2020-07-13 07:45:00	SPY	ETF	320.26	320.33	320.11	320.12	34624.0
2020-07-13 07:50:00	SPY	ETF	320.27	320.35	320.19	320.35	23772.0
2020-07-13 07:55:00	SPY	ETF	320.3	320.31	320.12	320.25	12855.0
2020-07-13 08:00:00	SPY	ETF	320.29	320.4402	319.1704	320.13	124626.0
2020-07-13 08:05:00	SPY	ETF	320.13	320.2	320.12	320.15	10583.0
2020-07-13 08:10:00	SPY	ETF	320.18	320.24	320.13	320.13	7287.0

> showing 50 of 79,528 rows — these rows as CSV

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