PREVIEW / etf_5min / 2019-08-19

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-19.parquet
  size:    1.4 MB
  rows:    63,622

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-08-19 04:00:00	SPY	ETF	291.34	291.44	291.32	291.36	13692.0
2019-08-19 04:05:00	SPY	ETF	291.5	291.5	291.42	291.42	7875.0
2019-08-19 04:10:00	SPY	ETF	291.46	291.47	291.42	291.45	711.0
2019-08-19 04:20:00	SPY	ETF	291.52	291.52	291.52	291.52	100.0
2019-08-19 04:25:00	SPY	ETF	291.2	291.2	291.2	291.2	317.0
2019-08-19 04:30:00	SPY	ETF	291.16	291.16	291.14	291.14	414.0
2019-08-19 04:35:00	SPY	ETF	291.13	291.13	291.1	291.1	500.0
2019-08-19 04:40:00	SPY	ETF	291.07	291.07	291.05	291.07	1159.0
2019-08-19 04:45:00	SPY	ETF	291.0	291.06	291.0	291.06	2120.0
2019-08-19 04:50:00	SPY	ETF	291.06	291.06	291.06	291.06	1700.0
2019-08-19 05:05:00	SPY	ETF	291.14	291.14	291.14	291.14	400.0
2019-08-19 05:15:00	SPY	ETF	291.34	291.34	291.34	291.34	100.0
2019-08-19 05:20:00	SPY	ETF	291.31	291.31	291.29	291.29	625.0
2019-08-19 05:25:00	SPY	ETF	291.38	291.38	291.38	291.38	125.0
2019-08-19 05:30:00	SPY	ETF	291.39	291.39	291.35	291.35	900.0
2019-08-19 05:40:00	SPY	ETF	291.31	291.34	291.31	291.34	3975.0
2019-08-19 05:45:00	SPY	ETF	291.37	291.46	291.37	291.46	500.0
2019-08-19 05:50:00	SPY	ETF	291.51	291.54	291.44	291.44	3499.0
2019-08-19 05:55:00	SPY	ETF	291.46	291.49	291.46	291.49	400.0
2019-08-19 06:00:00	SPY	ETF	291.55	291.57	291.54	291.55	685.0
2019-08-19 06:05:00	SPY	ETF	291.68	291.73	291.68	291.73	1280.0
2019-08-19 06:15:00	SPY	ETF	291.59	291.69	291.59	291.69	4058.0
2019-08-19 06:20:00	SPY	ETF	291.64	291.64	291.64	291.64	100.0
2019-08-19 06:25:00	SPY	ETF	291.63	291.71	291.55	291.56	3100.0
2019-08-19 06:30:00	SPY	ETF	291.55	291.55	291.49	291.54	2654.0
2019-08-19 06:35:00	SPY	ETF	291.58	291.58	291.54	291.54	565.0
2019-08-19 06:40:00	SPY	ETF	291.65	291.74	291.65	291.74	666.0
2019-08-19 06:45:00	SPY	ETF	291.74	291.83	291.73	291.81	1756.0
2019-08-19 06:50:00	SPY	ETF	291.83	291.88	291.83	291.84	1840.0
2019-08-19 06:55:00	SPY	ETF	291.88	292.19	291.81	291.81	49315.0
2019-08-19 07:00:00	SPY	ETF	291.82	291.88	291.68	291.68	64284.0
2019-08-19 07:05:00	SPY	ETF	291.7	291.77	291.67	291.77	5152.0
2019-08-19 07:10:00	SPY	ETF	291.81	291.82	291.67	291.67	27518.0
2019-08-19 07:15:00	SPY	ETF	291.7	291.82	291.7	291.81	29447.0
2019-08-19 07:20:00	SPY	ETF	291.76	292.06	291.76	292.02	31896.0
2019-08-19 07:25:00	SPY	ETF	292.08	292.26	292.0	292.25	92466.0
2019-08-19 07:30:00	SPY	ETF	292.17	292.4	292.0	292.4	89116.0
2019-08-19 07:35:00	SPY	ETF	292.3	292.65	292.3	292.41	110118.0
2019-08-19 07:40:00	SPY	ETF	292.38	292.43	292.25	292.26	25088.0
2019-08-19 07:45:00	SPY	ETF	292.23	292.23	292.07	292.12	72942.0
2019-08-19 07:50:00	SPY	ETF	292.12	292.17	292.07	292.13	59750.0
2019-08-19 07:55:00	SPY	ETF	292.14	292.2	292.04	292.07	85394.0
2019-08-19 08:00:00	SPY	ETF	292.08	292.6299	290.46	292.0	116377.0
2019-08-19 08:05:00	SPY	ETF	292.0	292.0	291.85	291.92	79713.0
2019-08-19 08:10:00	SPY	ETF	291.93	292.05	291.85	291.91	63435.0
2019-08-19 08:15:00	SPY	ETF	291.89	291.95	291.79	291.79	33316.0
2019-08-19 08:20:00	SPY	ETF	291.79	291.91	291.79	291.87	20455.0
2019-08-19 08:25:00	SPY	ETF	291.84	291.89	291.7	291.8	32985.0
2019-08-19 08:30:00	SPY	ETF	291.81	292.05	291.81	292.04	27480.0
2019-08-19 08:35:00	SPY	ETF	292.0	292.17	291.99	292.08	60022.0

> showing 50 of 63,622 rows — these rows as CSV

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