PREVIEW / etf_5min / 2023-08-18

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-08-18.parquet
  size:    2.0 MB
  rows:    97,292

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
2023-08-18 04:00:00	SPY	ETF	435.87	436.35	435.87	436.27	12297.0
2023-08-18 04:05:00	SPY	ETF	436.27	436.37	436.13	436.13	4075.0
2023-08-18 04:10:00	SPY	ETF	436.06	436.31	436.06	436.31	1012.0
2023-08-18 04:15:00	SPY	ETF	436.3	436.31	436.06	436.06	3074.0
2023-08-18 04:20:00	SPY	ETF	436.06	436.18	436.01	436.01	1500.0
2023-08-18 04:25:00	SPY	ETF	436.02	436.02	435.8	435.83	4522.0
2023-08-18 04:30:00	SPY	ETF	435.9	436.14	435.84	436.14	3264.0
2023-08-18 04:35:00	SPY	ETF	435.88	435.88	435.85	435.85	1100.0
2023-08-18 04:40:00	SPY	ETF	435.92	436.0	435.92	436.0	9672.0
2023-08-18 04:45:00	SPY	ETF	435.93	435.93	435.77	435.86	1225.0
2023-08-18 04:50:00	SPY	ETF	435.81	436.04	435.81	436.03	2500.0
2023-08-18 04:55:00	SPY	ETF	436.13	436.19	436.13	436.19	10425.0
2023-08-18 05:00:00	SPY	ETF	436.15	436.26	436.08	436.08	7100.0
2023-08-18 05:05:00	SPY	ETF	435.89	435.89	435.69	435.69	400.0
2023-08-18 05:10:00	SPY	ETF	435.75	435.75	435.43	435.43	6499.0
2023-08-18 05:15:00	SPY	ETF	435.39	435.56	435.39	435.56	4109.0
2023-08-18 05:20:00	SPY	ETF	435.4	435.48	435.4	435.48	304.0
2023-08-18 05:25:00	SPY	ETF	435.39	435.41	435.3	435.3	1941.0
2023-08-18 05:30:00	SPY	ETF	435.3	435.4	435.29	435.39	4500.0
2023-08-18 05:35:00	SPY	ETF	435.5	435.5	435.38	435.5	6612.0
2023-08-18 05:40:00	SPY	ETF	435.75	435.76	435.72	435.76	1645.0
2023-08-18 05:45:00	SPY	ETF	435.53	435.53	435.53	435.53	100.0
2023-08-18 05:50:00	SPY	ETF	435.62	435.68	435.62	435.68	1300.0
2023-08-18 05:55:00	SPY	ETF	435.76	435.76	435.55	435.65	2925.0
2023-08-18 06:00:00	SPY	ETF	435.63	435.63	435.58	435.58	725.0
2023-08-18 06:05:00	SPY	ETF	435.64	435.74	435.64	435.7	1100.0
2023-08-18 06:10:00	SPY	ETF	435.71	435.92	435.66	435.92	1450.0
2023-08-18 06:15:00	SPY	ETF	435.88	435.91	435.79	435.79	4200.0
2023-08-18 06:20:00	SPY	ETF	435.92	436.04	435.82	435.82	5100.0
2023-08-18 06:25:00	SPY	ETF	435.84	435.87	435.69	435.69	2100.0
2023-08-18 06:30:00	SPY	ETF	435.74	435.74	435.5	435.57	8700.0
2023-08-18 06:35:00	SPY	ETF	435.51	435.54	435.39	435.52	10501.0
2023-08-18 06:40:00	SPY	ETF	435.52	435.55	435.4	435.4	8250.0
2023-08-18 06:45:00	SPY	ETF	435.37	435.37	435.35	435.35	200.0
2023-08-18 06:50:00	SPY	ETF	435.38	435.38	435.35	435.35	1945.0
2023-08-18 06:55:00	SPY	ETF	435.36	435.43	435.3	435.42	6110.0
2023-08-18 07:00:00	SPY	ETF	435.45	435.52	435.32	435.33	12229.0
2023-08-18 07:05:00	SPY	ETF	435.3	435.31	435.14	435.22	25089.0
2023-08-18 07:10:00	SPY	ETF	435.21	435.25	435.14	435.19	19239.0
2023-08-18 07:15:00	SPY	ETF	435.16	435.18	435.0	435.04	19685.0
2023-08-18 07:20:00	SPY	ETF	435.04	435.04	434.68	434.75	21076.0
2023-08-18 07:25:00	SPY	ETF	434.69	434.79	434.52	434.57	27108.0
2023-08-18 07:30:00	SPY	ETF	434.585	434.7	434.31	434.42	51249.0
2023-08-18 07:35:00	SPY	ETF	434.42	434.42	433.93	433.93	48505.0
2023-08-18 07:40:00	SPY	ETF	433.97	434.31	433.97	434.31	40358.0
2023-08-18 07:45:00	SPY	ETF	434.25	434.32	434.08	434.16	28698.0
2023-08-18 07:50:00	SPY	ETF	434.11	434.24	434.06	434.11	41098.0
2023-08-18 07:55:00	SPY	ETF	434.11	434.25	434.11	434.22	36818.0
2023-08-18 08:00:00	SPY	ETF	435.2119	436.77	433.97	434.51	230831.0
2023-08-18 08:05:00	SPY	ETF	434.53	434.55	434.3	434.44	53764.0

> showing 50 of 97,292 rows — these rows as CSV

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