PREVIEW / etf_5min / 2021-07-19

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-07-19.parquet
  size:    2.0 MB
  rows:    94,279

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
2021-07-19 04:00:00	SPY	ETF	429.28	429.88	429.28	429.85	14565.0
2021-07-19 04:05:00	SPY	ETF	429.69	429.75	429.63	429.63	5795.0
2021-07-19 04:10:00	SPY	ETF	429.5	429.97	429.5	429.97	510.0
2021-07-19 04:15:00	SPY	ETF	429.93	429.93	429.75	429.75	5000.0
2021-07-19 04:20:00	SPY	ETF	429.81	429.92	429.78	429.92	1330.0
2021-07-19 04:25:00	SPY	ETF	429.48	429.52	429.48	429.52	300.0
2021-07-19 04:30:00	SPY	ETF	429.41	429.41	429.15	429.15	1500.0
2021-07-19 04:35:00	SPY	ETF	429.05	429.05	428.46	428.46	13062.0
2021-07-19 04:40:00	SPY	ETF	428.65	428.7	428.5	428.5	4300.0
2021-07-19 04:45:00	SPY	ETF	428.49	428.49	428.22	428.47	2599.0
2021-07-19 04:50:00	SPY	ETF	428.34	428.45	428.19	428.35	7600.0
2021-07-19 04:55:00	SPY	ETF	428.14	428.25	428.09	428.25	1900.0
2021-07-19 05:00:00	SPY	ETF	428.13	428.44	428.13	428.42	2800.0
2021-07-19 05:05:00	SPY	ETF	428.46	428.64	428.4	428.4	32600.0
2021-07-19 05:10:00	SPY	ETF	428.31	428.31	428.14	428.15	500.0
2021-07-19 05:15:00	SPY	ETF	428.28	428.48	428.27	428.4	2300.0
2021-07-19 05:20:00	SPY	ETF	428.36	428.36	428.35	428.35	1000.0
2021-07-19 05:25:00	SPY	ETF	428.4	428.5	428.38	428.38	10500.0
2021-07-19 05:30:00	SPY	ETF	428.26	428.35	428.15	428.31	600.0
2021-07-19 05:35:00	SPY	ETF	428.18	428.25	428.18	428.24	2200.0
2021-07-19 05:40:00	SPY	ETF	428.36	428.86	428.36	428.7	2896.0
2021-07-19 05:45:00	SPY	ETF	428.69	428.75	428.54	428.63	1500.0
2021-07-19 05:55:00	SPY	ETF	428.76	428.76	428.7	428.7	10500.0
2021-07-19 06:00:00	SPY	ETF	428.8	428.8	428.42	428.42	3086.0
2021-07-19 06:05:00	SPY	ETF	428.32	428.39	428.05	428.05	6683.0
2021-07-19 06:10:00	SPY	ETF	428.1	428.13	428.0	428.1	8057.0
2021-07-19 06:15:00	SPY	ETF	427.97	428.2	427.92	428.17	4105.0
2021-07-19 06:20:00	SPY	ETF	428.17	428.3	428.16	428.22	4677.0
2021-07-19 06:25:00	SPY	ETF	428.3	428.35	428.27	428.27	1004.0
2021-07-19 06:30:00	SPY	ETF	428.32	428.35	428.23	428.27	4197.0
2021-07-19 06:35:00	SPY	ETF	428.42	428.42	428.0	428.05	10693.0
2021-07-19 06:40:00	SPY	ETF	428.06	428.15	427.93	427.99	10823.0
2021-07-19 06:45:00	SPY	ETF	427.99	428.29	427.9	428.17	5625.0
2021-07-19 06:50:00	SPY	ETF	428.1	428.1	427.91	428.1	3950.0
2021-07-19 06:55:00	SPY	ETF	428.14	428.14	428.0	428.07	6701.0
2021-07-19 07:00:00	SPY	ETF	428.11	428.34	427.8	427.85	47213.0
2021-07-19 07:05:00	SPY	ETF	427.9	428.0	427.76	427.78	22816.0
2021-07-19 07:10:00	SPY	ETF	427.73	427.84	427.63	427.63	22349.0
2021-07-19 07:15:00	SPY	ETF	427.65	427.86	427.61	427.77	12186.0
2021-07-19 07:20:00	SPY	ETF	427.79	427.82	427.75	427.75	25142.0
2021-07-19 07:25:00	SPY	ETF	427.69	427.75	427.2	427.2	52972.0
2021-07-19 07:30:00	SPY	ETF	427.18	427.18	426.51	426.53	49700.0
2021-07-19 07:35:00	SPY	ETF	426.57	426.86	426.57	426.73	101342.0
2021-07-19 07:40:00	SPY	ETF	426.64	426.7	426.34	426.43	95876.0
2021-07-19 07:45:00	SPY	ETF	426.39	426.79	426.26	426.78	112102.0
2021-07-19 07:50:00	SPY	ETF	426.75	426.77	426.38	426.61	89873.0
2021-07-19 07:55:00	SPY	ETF	426.61	426.97	426.61	426.96	111322.0
2021-07-19 08:00:00	SPY	ETF	426.98	430.3	426.21	426.65	135492.0
2021-07-19 08:05:00	SPY	ETF	426.67	426.82	426.32	426.34	143583.0
2021-07-19 08:10:00	SPY	ETF	426.39	426.52	426.27	426.39	23863.0

> showing 50 of 94,279 rows — these rows as CSV

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