PREVIEW / etf_5min / 2022-04-18

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-04-18.parquet
  size:    2.0 MB
  rows:    96,205

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-04-18 04:00:00	SPY	ETF	436.18	436.51	435.83	436.48	3759.0
2022-04-18 04:05:00	SPY	ETF	436.43	436.44	436.27	436.36	3286.0
2022-04-18 04:10:00	SPY	ETF	436.31	436.31	436.27	436.27	3945.0
2022-04-18 04:15:00	SPY	ETF	436.29	436.43	436.29	436.43	3590.0
2022-04-18 04:20:00	SPY	ETF	436.5	436.51	436.34	436.34	1992.0
2022-04-18 04:25:00	SPY	ETF	436.4	436.4	436.4	436.4	2097.0
2022-04-18 04:30:00	SPY	ETF	436.39	436.39	436.32	436.32	1099.0
2022-04-18 04:35:00	SPY	ETF	436.3	436.3	436.3	436.3	500.0
2022-04-18 04:40:00	SPY	ETF	436.3	436.33	436.3	436.33	600.0
2022-04-18 04:45:00	SPY	ETF	436.32	436.33	436.3	436.33	4744.0
2022-04-18 04:55:00	SPY	ETF	436.22	436.22	436.18	436.18	234.0
2022-04-18 05:00:00	SPY	ETF	436.11	436.12	436.03	436.03	1988.0
2022-04-18 05:10:00	SPY	ETF	436.06	436.06	435.92	435.92	700.0
2022-04-18 05:15:00	SPY	ETF	435.92	436.0	435.85	435.85	533.0
2022-04-18 05:20:00	SPY	ETF	435.82	435.82	435.32	435.36	6088.0
2022-04-18 05:25:00	SPY	ETF	435.41	435.57	435.41	435.57	1167.0
2022-04-18 05:30:00	SPY	ETF	435.55	435.56	435.55	435.56	250.0
2022-04-18 05:35:00	SPY	ETF	435.58	435.58	435.55	435.55	200.0
2022-04-18 05:45:00	SPY	ETF	435.56	435.56	435.56	435.56	448.0
2022-04-18 05:50:00	SPY	ETF	435.6	435.6	435.6	435.6	1885.0
2022-04-18 05:55:00	SPY	ETF	435.64	435.67	435.6	435.67	1599.0
2022-04-18 06:00:00	SPY	ETF	435.64	435.8	435.64	435.8	1291.0
2022-04-18 06:05:00	SPY	ETF	435.8	435.86	435.72	435.86	2544.0
2022-04-18 06:10:00	SPY	ETF	435.87	435.87	435.87	435.87	1100.0
2022-04-18 06:15:00	SPY	ETF	435.89	435.9	435.88	435.89	1899.0
2022-04-18 06:20:00	SPY	ETF	435.85	435.88	435.85	435.88	798.0
2022-04-18 06:25:00	SPY	ETF	435.92	436.27	435.92	436.15	2668.0
2022-04-18 06:30:00	SPY	ETF	436.16	436.16	436.11	436.11	200.0
2022-04-18 06:35:00	SPY	ETF	436.08	436.08	436.08	436.08	459.0
2022-04-18 06:40:00	SPY	ETF	436.08	436.16	436.05	436.16	2100.0
2022-04-18 06:45:00	SPY	ETF	436.12	436.15	436.12	436.15	599.0
2022-04-18 06:50:00	SPY	ETF	436.21	436.21	436.15	436.15	4000.0
2022-04-18 06:55:00	SPY	ETF	436.15	436.17	436.11	436.15	9132.0
2022-04-18 07:00:00	SPY	ETF	436.05	436.45	436.05	436.38	23698.0
2022-04-18 07:05:00	SPY	ETF	436.48	436.81	436.48	436.77	25538.0
2022-04-18 07:10:00	SPY	ETF	436.73	437.23	436.73	437.17	21614.0
2022-04-18 07:15:00	SPY	ETF	437.24	437.36	437.24	437.36	19760.0
2022-04-18 07:20:00	SPY	ETF	437.28	437.28	437.15	437.2	2177.0
2022-04-18 07:25:00	SPY	ETF	437.07	437.15	437.07	437.08	7814.0
2022-04-18 07:30:00	SPY	ETF	437.13	437.15	437.02	437.1	7245.0
2022-04-18 07:35:00	SPY	ETF	437.07	437.07	436.86	436.89	7767.0
2022-04-18 07:40:00	SPY	ETF	436.88	436.88	436.71	436.88	9578.0
2022-04-18 07:45:00	SPY	ETF	436.91	436.91	436.67	436.71	6113.0
2022-04-18 07:50:00	SPY	ETF	436.71	436.73	436.6	436.67	8955.0
2022-04-18 07:55:00	SPY	ETF	436.7	436.7	436.53	436.64	4400.0
2022-04-18 08:00:00	SPY	ETF	436.33	437.35	435.57	436.73	35756.0
2022-04-18 08:05:00	SPY	ETF	436.72	436.83	436.49	436.57	28449.0
2022-04-18 08:10:00	SPY	ETF	436.58	436.63	436.33	436.39	13551.0
2022-04-18 08:15:00	SPY	ETF	436.4	436.6	436.31	436.54	36736.0
2022-04-18 08:20:00	SPY	ETF	436.6	436.65	436.59	436.62	35921.0

> showing 50 of 96,205 rows — these rows as CSV

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