PREVIEW / etf_5min / 2019-09-23

all etf 5-min files

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

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-09-23 04:00:00	SPY	ETF	298.22	298.22	298.05	298.05	808.0
2019-09-23 04:05:00	SPY	ETF	297.89	298.0	297.87	297.96	8596.0
2019-09-23 04:10:00	SPY	ETF	298.0	298.14	297.89	297.89	2120.0
2019-09-23 04:15:00	SPY	ETF	297.76	297.76	297.41	297.57	1560.0
2019-09-23 04:20:00	SPY	ETF	297.52	297.64	297.5	297.5	3832.0
2019-09-23 04:25:00	SPY	ETF	297.48	297.69	297.48	297.69	19501.0
2019-09-23 04:30:00	SPY	ETF	297.54	297.54	297.29	297.34	4630.0
2019-09-23 04:35:00	SPY	ETF	297.29	297.32	297.29	297.32	833.0
2019-09-23 04:40:00	SPY	ETF	297.46	297.47	297.39	297.39	950.0
2019-09-23 04:45:00	SPY	ETF	297.42	297.48	297.24	297.27	11210.0
2019-09-23 04:50:00	SPY	ETF	297.34	297.34	297.16	297.22	2598.0
2019-09-23 04:55:00	SPY	ETF	297.24	297.25	297.24	297.24	860.0
2019-09-23 05:00:00	SPY	ETF	297.25	297.32	297.25	297.32	1900.0
2019-09-23 05:05:00	SPY	ETF	297.34	297.55	297.34	297.55	1305.0
2019-09-23 05:10:00	SPY	ETF	297.58	297.58	297.52	297.54	1800.0
2019-09-23 05:15:00	SPY	ETF	297.57	297.57	297.49	297.49	1525.0
2019-09-23 05:20:00	SPY	ETF	297.59	297.59	297.52	297.52	4835.0
2019-09-23 05:25:00	SPY	ETF	297.52	297.55	297.52	297.55	5500.0
2019-09-23 05:30:00	SPY	ETF	297.5	297.6	297.5	297.55	1200.0
2019-09-23 05:35:00	SPY	ETF	297.6	297.62	297.6	297.62	1900.0
2019-09-23 05:40:00	SPY	ETF	297.68	297.75	297.68	297.72	5275.0
2019-09-23 05:45:00	SPY	ETF	297.72	297.8	297.72	297.8	2450.0
2019-09-23 05:50:00	SPY	ETF	297.8	298.0	297.8	297.94	7730.0
2019-09-23 05:55:00	SPY	ETF	297.89	297.89	297.87	297.89	6000.0
2019-09-23 06:00:00	SPY	ETF	297.92	297.92	297.85	297.87	1125.0
2019-09-23 06:05:00	SPY	ETF	297.89	297.89	297.89	297.89	2250.0
2019-09-23 06:10:00	SPY	ETF	297.94	297.94	297.79	297.85	3065.0
2019-09-23 06:15:00	SPY	ETF	297.9	297.9	297.9	297.9	300.0
2019-09-23 06:20:00	SPY	ETF	297.97	297.97	297.92	297.92	2163.0
2019-09-23 06:30:00	SPY	ETF	297.97	297.99	297.92	297.93	4499.0
2019-09-23 06:35:00	SPY	ETF	297.95	297.95	297.9	297.9	9800.0
2019-09-23 06:40:00	SPY	ETF	297.9	298.0	297.9	297.99	1862.0
2019-09-23 06:45:00	SPY	ETF	297.94	297.94	297.81	297.81	1256.0
2019-09-23 06:50:00	SPY	ETF	297.82	297.82	297.82	297.82	500.0
2019-09-23 06:55:00	SPY	ETF	297.86	298.14	297.86	298.07	3100.0
2019-09-23 07:00:00	SPY	ETF	298.05	298.11	297.98	298.01	19994.0
2019-09-23 07:05:00	SPY	ETF	298.04	298.04	297.98	298.04	7725.0
2019-09-23 07:10:00	SPY	ETF	298.09	298.13	298.06	298.06	1805.0
2019-09-23 07:15:00	SPY	ETF	298.08	298.11	298.07	298.11	7558.0
2019-09-23 07:20:00	SPY	ETF	298.14	298.14	298.07	298.07	2850.0
2019-09-23 07:25:00	SPY	ETF	298.1	298.1	298.1	298.1	100.0
2019-09-23 07:30:00	SPY	ETF	298.09	298.1	298.0	298.04	3770.0
2019-09-23 07:35:00	SPY	ETF	298.0	298.0	297.97	298.0	11950.0
2019-09-23 07:40:00	SPY	ETF	298.0	298.0	297.98	297.98	17250.0
2019-09-23 07:45:00	SPY	ETF	297.98	297.99	297.9	297.93	8828.0
2019-09-23 07:50:00	SPY	ETF	297.91	297.91	297.8	297.8	37070.0
2019-09-23 07:55:00	SPY	ETF	297.8	297.85	297.8	297.82	7696.0
2019-09-23 08:00:00	SPY	ETF	298.0501	299.4	297.8	297.91	54596.0
2019-09-23 08:05:00	SPY	ETF	297.9	297.99	297.85	297.85	62324.0
2019-09-23 08:10:00	SPY	ETF	297.84	297.85	297.79	297.79	38708.0

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

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