PREVIEW / etf_5min / 2020-06-09

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-06-09.parquet
  size:    1.7 MB
  rows:    77,519

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-06-09 04:00:00	SPY	ETF	321.14	321.37	321.14	321.3	13587.0
2020-06-09 04:05:00	SPY	ETF	321.21	321.21	320.53	320.53	18903.0
2020-06-09 04:10:00	SPY	ETF	320.51	320.69	320.45	320.45	26657.0
2020-06-09 04:15:00	SPY	ETF	320.42	320.42	319.9	320.04	13187.0
2020-06-09 04:20:00	SPY	ETF	320.08	320.41	320.08	320.31	10577.0
2020-06-09 04:25:00	SPY	ETF	320.2	320.2	319.98	320.16	7937.0
2020-06-09 04:30:00	SPY	ETF	320.2	320.39	319.83	319.89	7648.0
2020-06-09 04:35:00	SPY	ETF	319.92	320.04	319.61	319.64	20151.0
2020-06-09 04:40:00	SPY	ETF	319.69	319.74	319.33	319.34	10210.0
2020-06-09 04:45:00	SPY	ETF	319.36	320.13	319.34	320.0	13017.0
2020-06-09 04:50:00	SPY	ETF	319.91	320.22	319.91	320.01	4076.0
2020-06-09 04:55:00	SPY	ETF	319.88	319.88	319.67	319.67	1857.0
2020-06-09 05:00:00	SPY	ETF	319.82	320.2	319.82	320.19	19418.0
2020-06-09 05:05:00	SPY	ETF	320.14	320.14	319.83	320.06	7819.0
2020-06-09 05:10:00	SPY	ETF	320.0	320.0	319.72	319.78	6017.0
2020-06-09 05:15:00	SPY	ETF	319.82	320.06	319.7	319.88	13036.0
2020-06-09 05:20:00	SPY	ETF	320.03	320.19	319.95	320.15	11270.0
2020-06-09 05:25:00	SPY	ETF	320.2	320.49	320.15	320.35	14023.0
2020-06-09 05:30:00	SPY	ETF	320.4	320.46	320.2	320.2	25022.0
2020-06-09 05:35:00	SPY	ETF	320.26	320.26	320.1	320.1	3491.0
2020-06-09 05:40:00	SPY	ETF	320.1	320.21	320.1	320.21	1423.0
2020-06-09 05:45:00	SPY	ETF	320.2	320.2	319.73	319.76	29459.0
2020-06-09 05:50:00	SPY	ETF	319.74	319.85	319.74	319.77	22581.0
2020-06-09 05:55:00	SPY	ETF	319.77	319.78	319.54	319.71	29256.0
2020-06-09 06:00:00	SPY	ETF	319.77	319.9	319.72	319.72	7745.0
2020-06-09 06:05:00	SPY	ETF	319.74	319.97	319.66	319.91	13050.0
2020-06-09 06:10:00	SPY	ETF	319.93	320.0	319.34	319.39	6457.0
2020-06-09 06:15:00	SPY	ETF	319.55	319.76	319.51	319.64	12200.0
2020-06-09 06:20:00	SPY	ETF	319.7	319.91	319.64	319.66	13262.0
2020-06-09 06:25:00	SPY	ETF	319.64	319.64	319.41	319.41	9034.0
2020-06-09 06:30:00	SPY	ETF	319.51	319.89	319.51	319.89	7886.0
2020-06-09 06:35:00	SPY	ETF	319.91	320.07	319.86	319.97	21449.0
2020-06-09 06:40:00	SPY	ETF	320.0	320.2	319.95	320.11	14433.0
2020-06-09 06:45:00	SPY	ETF	320.13	320.13	319.9	319.96	7656.0
2020-06-09 06:50:00	SPY	ETF	320.01	320.23	320.01	320.21	66814.0
2020-06-09 06:55:00	SPY	ETF	320.24	320.35	320.23	320.25	63942.0
2020-06-09 07:00:00	SPY	ETF	320.27	320.44	320.16	320.16	60230.0
2020-06-09 07:05:00	SPY	ETF	320.16	320.38	320.15	320.29	35274.0
2020-06-09 07:10:00	SPY	ETF	320.29	320.34	320.18	320.26	26096.0
2020-06-09 07:15:00	SPY	ETF	320.28	320.31	319.9	320.05	49239.0
2020-06-09 07:20:00	SPY	ETF	320.07	320.35	320.07	320.25	38899.0
2020-06-09 07:25:00	SPY	ETF	320.24	320.28	319.92	320.0	48617.0
2020-06-09 07:30:00	SPY	ETF	320.04	320.14	319.9	319.99	48501.0
2020-06-09 07:35:00	SPY	ETF	320.0	320.34	319.94	320.21	87204.0
2020-06-09 07:40:00	SPY	ETF	320.22	320.46	320.22	320.35	38209.0
2020-06-09 07:45:00	SPY	ETF	320.41	320.86	320.39	320.82	85405.0
2020-06-09 07:50:00	SPY	ETF	320.78	320.81	320.61	320.61	71414.0
2020-06-09 07:55:00	SPY	ETF	320.65	320.72	320.51	320.52	26060.0
2020-06-09 08:00:00	SPY	ETF	320.51	323.24	319.4704	320.42	153350.0
2020-06-09 08:05:00	SPY	ETF	320.47	320.54	320.3	320.4	52248.0

> showing 50 of 77,519 rows — these rows as CSV

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