PREVIEW / etf_5min / 2022-08-17

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-08-17.parquet
  size:    1.9 MB
  rows:    92,549

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
2022-08-17 04:00:00	SPY	ETF	428.76	428.76	428.42	428.61	3889.0
2022-08-17 04:05:00	SPY	ETF	428.52	428.62	428.48	428.55	3470.0
2022-08-17 04:10:00	SPY	ETF	428.45	428.84	428.42	428.84	3196.0
2022-08-17 04:15:00	SPY	ETF	428.85	428.85	428.59	428.59	1525.0
2022-08-17 04:20:00	SPY	ETF	428.49	428.78	428.45	428.63	6200.0
2022-08-17 04:25:00	SPY	ETF	428.64	428.64	428.43	428.44	1583.0
2022-08-17 04:30:00	SPY	ETF	428.35	428.38	428.31	428.36	5680.0
2022-08-17 04:35:00	SPY	ETF	428.3	428.3	428.25	428.25	1670.0
2022-08-17 04:40:00	SPY	ETF	428.31	428.35	428.31	428.35	200.0
2022-08-17 04:45:00	SPY	ETF	428.25	428.25	428.15	428.23	919.0
2022-08-17 04:50:00	SPY	ETF	428.17	428.25	428.17	428.25	800.0
2022-08-17 04:55:00	SPY	ETF	428.11	428.11	428.06	428.08	672.0
2022-08-17 05:00:00	SPY	ETF	428.07	428.14	428.07	428.14	760.0
2022-08-17 05:05:00	SPY	ETF	428.3	428.3	428.29	428.29	250.0
2022-08-17 05:10:00	SPY	ETF	428.21	428.24	428.13	428.13	5107.0
2022-08-17 05:15:00	SPY	ETF	428.12	428.12	428.05	428.06	1710.0
2022-08-17 05:20:00	SPY	ETF	428.06	428.14	428.06	428.06	910.0
2022-08-17 05:25:00	SPY	ETF	428.35	428.35	428.2	428.22	2777.0
2022-08-17 05:30:00	SPY	ETF	428.09	428.09	427.97	427.97	1110.0
2022-08-17 05:35:00	SPY	ETF	428.06	428.07	428.02	428.03	3000.0
2022-08-17 05:40:00	SPY	ETF	428.08	428.12	428.05	428.1	3095.0
2022-08-17 05:45:00	SPY	ETF	427.9	427.91	427.79	427.79	1861.0
2022-08-17 05:50:00	SPY	ETF	427.7	427.75	427.45	427.46	12322.0
2022-08-17 05:55:00	SPY	ETF	427.48	427.58	427.39	427.58	4584.0
2022-08-17 06:00:00	SPY	ETF	427.44	427.44	427.35	427.36	4280.0
2022-08-17 06:05:00	SPY	ETF	427.48	427.51	427.43	427.43	1600.0
2022-08-17 06:10:00	SPY	ETF	427.4	427.45	427.25	427.32	12779.0
2022-08-17 06:15:00	SPY	ETF	427.33	427.36	427.2	427.2	1800.0
2022-08-17 06:20:00	SPY	ETF	427.23	427.25	427.07	427.07	1698.0
2022-08-17 06:25:00	SPY	ETF	427.07	427.1	426.88	427.1	12925.0
2022-08-17 06:30:00	SPY	ETF	427.05	427.15	426.57	427.14	36053.0
2022-08-17 06:35:00	SPY	ETF	427.01	427.08	426.96	427.0	4799.0
2022-08-17 06:40:00	SPY	ETF	427.02	427.02	426.62	426.73	16570.0
2022-08-17 06:45:00	SPY	ETF	426.75	426.83	426.64	426.67	15498.0
2022-08-17 06:50:00	SPY	ETF	426.76	426.81	426.71	426.75	3119.0
2022-08-17 06:55:00	SPY	ETF	426.77	426.93	426.64	426.92	6646.0
2022-08-17 07:00:00	SPY	ETF	426.97	427.1	426.75	426.8	37982.0
2022-08-17 07:05:00	SPY	ETF	426.86	426.86	426.6	426.67	23332.0
2022-08-17 07:10:00	SPY	ETF	426.72	426.75	426.55	426.56	6941.0
2022-08-17 07:15:00	SPY	ETF	426.5	426.62	426.16	426.37	22102.0
2022-08-17 07:20:00	SPY	ETF	426.4	426.61	426.35	426.57	8110.0
2022-08-17 07:25:00	SPY	ETF	426.54	426.56	426.31	426.36	9022.0
2022-08-17 07:30:00	SPY	ETF	426.35	426.37	426.03	426.37	24620.0
2022-08-17 07:35:00	SPY	ETF	426.34	426.43	426.06	426.3	37486.0
2022-08-17 07:40:00	SPY	ETF	426.25	426.28	426.14	426.21	26322.0
2022-08-17 07:45:00	SPY	ETF	426.25	426.25	426.13	426.18	12325.0
2022-08-17 07:50:00	SPY	ETF	426.21	426.34	426.14	426.29	22797.0
2022-08-17 07:55:00	SPY	ETF	426.34	426.36	426.25	426.35	46206.0
2022-08-17 08:00:00	SPY	ETF	427.1416	429.25	426.03	426.52	432091.0
2022-08-17 08:05:00	SPY	ETF	429.3782	429.8654	426.4	426.51	234250.0

> showing 50 of 92,549 rows — these rows as CSV

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