PREVIEW / etf_5min / 2022-08-18

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-08-18.parquet
  size:    1.8 MB
  rows:    87,343

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-18 04:00:00	SPY	ETF	425.67	425.83	425.65	425.78	8057.0
2022-08-18 04:05:00	SPY	ETF	425.85	426.0	425.71	425.91	8474.0
2022-08-18 04:10:00	SPY	ETF	425.75	425.84	425.75	425.8	2164.0
2022-08-18 04:15:00	SPY	ETF	425.8	425.92	425.63	425.63	1326.0
2022-08-18 04:20:00	SPY	ETF	425.57	425.57	425.41	425.41	836.0
2022-08-18 04:25:00	SPY	ETF	425.55	425.55	425.5	425.5	300.0
2022-08-18 04:30:00	SPY	ETF	425.52	425.63	425.43	425.6	850.0
2022-08-18 04:35:00	SPY	ETF	425.68	425.68	425.57	425.57	239.0
2022-08-18 04:40:00	SPY	ETF	425.59	426.0	425.59	425.99	1512.0
2022-08-18 04:45:00	SPY	ETF	425.99	426.19	425.99	426.19	3270.0
2022-08-18 04:50:00	SPY	ETF	426.08	426.1	426.04	426.1	1750.0
2022-08-18 04:55:00	SPY	ETF	426.01	426.41	425.95	426.38	5815.0
2022-08-18 05:00:00	SPY	ETF	426.43	426.46	426.43	426.46	2192.0
2022-08-18 05:05:00	SPY	ETF	426.4	426.83	426.4	426.68	1523.0
2022-08-18 05:10:00	SPY	ETF	426.64	426.66	426.58	426.66	1640.0
2022-08-18 05:15:00	SPY	ETF	426.61	426.61	426.61	426.61	500.0
2022-08-18 05:20:00	SPY	ETF	426.65	426.76	426.65	426.76	416.0
2022-08-18 05:25:00	SPY	ETF	426.69	426.94	426.69	426.89	3644.0
2022-08-18 05:30:00	SPY	ETF	426.84	426.84	426.77	426.77	400.0
2022-08-18 05:35:00	SPY	ETF	426.99	427.0	426.99	426.99	1518.0
2022-08-18 05:40:00	SPY	ETF	427.07	427.16	427.03	427.03	5000.0
2022-08-18 05:45:00	SPY	ETF	427.05	427.23	427.05	427.17	800.0
2022-08-18 05:50:00	SPY	ETF	427.05	427.3	427.02	427.27	7484.0
2022-08-18 05:55:00	SPY	ETF	427.29	427.29	427.18	427.28	2252.0
2022-08-18 06:00:00	SPY	ETF	427.35	427.78	427.3	427.76	16557.0
2022-08-18 06:05:00	SPY	ETF	427.73	427.78	427.62	427.62	7230.0
2022-08-18 06:10:00	SPY	ETF	427.53	427.54	427.44	427.44	2084.0
2022-08-18 06:15:00	SPY	ETF	427.36	427.39	427.3	427.33	4310.0
2022-08-18 06:20:00	SPY	ETF	427.39	427.45	427.34	427.37	1060.0
2022-08-18 06:25:00	SPY	ETF	427.38	427.38	427.37	427.37	200.0
2022-08-18 06:30:00	SPY	ETF	427.4	427.4	427.4	427.4	100.0
2022-08-18 06:35:00	SPY	ETF	427.45	427.59	427.44	427.51	3493.0
2022-08-18 06:40:00	SPY	ETF	427.55	427.55	427.3	427.3	2300.0
2022-08-18 06:45:00	SPY	ETF	427.27	427.27	427.05	427.12	4326.0
2022-08-18 06:50:00	SPY	ETF	427.17	427.18	427.05	427.08	1600.0
2022-08-18 06:55:00	SPY	ETF	427.12	427.2	427.12	427.18	1925.0
2022-08-18 07:00:00	SPY	ETF	427.13	427.16	426.95	427.08	9114.0
2022-08-18 07:05:00	SPY	ETF	427.15	427.29	427.15	427.27	15774.0
2022-08-18 07:10:00	SPY	ETF	427.27	427.34	427.27	427.32	12099.0
2022-08-18 07:15:00	SPY	ETF	427.34	427.4	427.26	427.26	6578.0
2022-08-18 07:20:00	SPY	ETF	427.25	427.25	427.16	427.16	13230.0
2022-08-18 07:25:00	SPY	ETF	427.19	427.21	426.95	426.96	13089.0
2022-08-18 07:30:00	SPY	ETF	427.0	427.46	426.98	427.41	10748.0
2022-08-18 07:35:00	SPY	ETF	427.39	427.53	427.36	427.49	12691.0
2022-08-18 07:40:00	SPY	ETF	427.5	427.54	427.32	427.44	17656.0
2022-08-18 07:45:00	SPY	ETF	427.51	427.64	427.43	427.55	37816.0
2022-08-18 07:50:00	SPY	ETF	427.54	427.55	427.44	427.53	2544.0
2022-08-18 07:55:00	SPY	ETF	427.49	427.67	427.49	427.67	26028.0
2022-08-18 08:00:00	SPY	ETF	425.55	427.94	425.42	427.94	206049.0
2022-08-18 08:05:00	SPY	ETF	425.7335	428.35	425.4844	428.1	319422.0

> showing 50 of 87,343 rows — these rows as CSV

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