PREVIEW / etf_5min / 2023-08-15

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-08-15.parquet
  size:    2.0 MB
  rows:    96,691

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-15 04:00:00	SPY	ETF	446.03	447.72	445.75	445.94	6974.0
2023-08-15 04:05:00	SPY	ETF	445.84	445.88	445.66	445.7	16600.0
2023-08-15 04:10:00	SPY	ETF	445.9	446.04	445.78	446.01	6419.0
2023-08-15 04:15:00	SPY	ETF	446.07	446.08	445.83	446.0	12206.0
2023-08-15 04:20:00	SPY	ETF	445.87	446.03	445.87	445.87	5199.0
2023-08-15 04:25:00	SPY	ETF	445.82	446.2	445.82	445.99	13368.0
2023-08-15 04:30:00	SPY	ETF	446.0	446.07	445.74	445.92	9190.0
2023-08-15 04:35:00	SPY	ETF	446.11	446.49	446.1	446.3	14298.0
2023-08-15 04:40:00	SPY	ETF	446.27	446.49	446.12	446.45	19886.0
2023-08-15 04:45:00	SPY	ETF	446.37	446.54	446.36	446.49	4350.0
2023-08-15 04:50:00	SPY	ETF	446.48	446.67	446.48	446.55	13709.0
2023-08-15 04:55:00	SPY	ETF	446.64	446.64	446.64	446.64	200.0
2023-08-15 05:00:00	SPY	ETF	446.55	446.55	446.34	446.38	32580.0
2023-08-15 05:05:00	SPY	ETF	446.27	446.3	446.18	446.3	24803.0
2023-08-15 05:10:00	SPY	ETF	446.38	446.38	446.05	446.05	4799.0
2023-08-15 05:15:00	SPY	ETF	445.94	446.2	445.94	446.2	3071.0
2023-08-15 05:20:00	SPY	ETF	446.3	446.51	446.3	446.51	2900.0
2023-08-15 05:25:00	SPY	ETF	446.47	446.6	446.39	446.39	2900.0
2023-08-15 05:30:00	SPY	ETF	446.36	446.41	446.36	446.41	400.0
2023-08-15 05:35:00	SPY	ETF	446.49	446.6	446.49	446.55	3100.0
2023-08-15 05:40:00	SPY	ETF	446.34	446.36	446.27	446.33	2400.0
2023-08-15 05:45:00	SPY	ETF	446.33	446.34	446.15	446.21	6442.0
2023-08-15 05:50:00	SPY	ETF	446.37	446.37	446.19	446.21	612.0
2023-08-15 05:55:00	SPY	ETF	446.21	446.27	446.16	446.17	3424.0
2023-08-15 06:00:00	SPY	ETF	446.13	446.39	445.99	445.99	6950.0
2023-08-15 06:05:00	SPY	ETF	445.94	446.01	445.84	445.9	4466.0
2023-08-15 06:10:00	SPY	ETF	445.88	445.89	445.74	445.89	1996.0
2023-08-15 06:15:00	SPY	ETF	445.84	445.9	445.33	445.39	15517.0
2023-08-15 06:20:00	SPY	ETF	445.4	445.42	445.15	445.15	15639.0
2023-08-15 06:25:00	SPY	ETF	445.19	445.38	445.19	445.3	10395.0
2023-08-15 06:30:00	SPY	ETF	445.22	445.34	445.13	445.3	8968.0
2023-08-15 06:35:00	SPY	ETF	445.42	445.5	445.42	445.45	79822.0
2023-08-15 06:40:00	SPY	ETF	445.45	445.46	445.26	445.26	26123.0
2023-08-15 06:45:00	SPY	ETF	445.32	445.58	445.32	445.4	1627.0
2023-08-15 06:50:00	SPY	ETF	445.5	445.5	445.44	445.44	400.0
2023-08-15 06:55:00	SPY	ETF	445.41	445.43	445.37	445.41	2156.0
2023-08-15 07:00:00	SPY	ETF	445.68	445.69	445.4	445.45	24274.0
2023-08-15 07:05:00	SPY	ETF	445.39	445.53	445.02	445.49	95595.0
2023-08-15 07:10:00	SPY	ETF	445.54	445.6	445.5	445.54	66409.0
2023-08-15 07:15:00	SPY	ETF	445.5	445.6	445.42	445.46	27625.0
2023-08-15 07:20:00	SPY	ETF	445.44	445.71	445.44	445.68	24750.0
2023-08-15 07:25:00	SPY	ETF	445.71	445.72	445.62	445.69	9242.0
2023-08-15 07:30:00	SPY	ETF	445.68	445.75	445.63	445.66	3868.0
2023-08-15 07:35:00	SPY	ETF	445.65	445.84	445.35	445.37	57100.0
2023-08-15 07:40:00	SPY	ETF	445.27	445.27	444.94	445.19	24055.0
2023-08-15 07:45:00	SPY	ETF	445.18	445.19	444.95	444.98	10866.0
2023-08-15 07:50:00	SPY	ETF	444.91	444.97	444.84	444.89	36182.0
2023-08-15 07:55:00	SPY	ETF	444.84	445.0	444.72	445.0	108068.0
2023-08-15 08:00:00	SPY	ETF	445.6792	448.92	444.69	444.89	92915.0
2023-08-15 08:05:00	SPY	ETF	444.97	445.14	444.92	445.03	37064.0

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

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