PREVIEW / etf_5min / 2023-10-20

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-10-20.parquet
  size:    2.1 MB
  rows:    101,490

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-10-20 04:00:00	SPY	ETF	425.78	425.84	425.34	425.84	18311.0
2023-10-20 04:05:00	SPY	ETF	425.86	425.99	425.62	425.67	3199.0
2023-10-20 04:10:00	SPY	ETF	425.61	426.06	425.61	425.99	3150.0
2023-10-20 04:15:00	SPY	ETF	425.98	425.98	425.8	425.98	3053.0
2023-10-20 04:20:00	SPY	ETF	425.97	426.22	425.97	426.18	9592.0
2023-10-20 04:25:00	SPY	ETF	426.22	426.46	426.22	426.34	12214.0
2023-10-20 04:30:00	SPY	ETF	426.27	426.4	426.17	426.37	2750.0
2023-10-20 04:35:00	SPY	ETF	426.3	426.52	426.25	426.52	3976.0
2023-10-20 04:40:00	SPY	ETF	426.55	426.6	426.54	426.58	2346.0
2023-10-20 04:45:00	SPY	ETF	426.62	426.73	426.62	426.67	1063.0
2023-10-20 04:50:00	SPY	ETF	426.64	426.66	426.25	426.25	4824.0
2023-10-20 04:55:00	SPY	ETF	426.28	426.4	426.28	426.35	1965.0
2023-10-20 05:00:00	SPY	ETF	426.24	426.25	426.24	426.25	200.0
2023-10-20 05:05:00	SPY	ETF	426.16	426.16	426.09	426.1	931.0
2023-10-20 05:10:00	SPY	ETF	426.33	426.33	426.12	426.12	231.0
2023-10-20 05:15:00	SPY	ETF	426.2	426.3	426.2	426.3	2650.0
2023-10-20 05:20:00	SPY	ETF	426.01	426.01	425.89	425.89	1333.0
2023-10-20 05:25:00	SPY	ETF	425.9	425.91	425.6	425.6	2900.0
2023-10-20 05:30:00	SPY	ETF	425.34	425.5	425.32	425.48	3903.0
2023-10-20 05:35:00	SPY	ETF	425.66	425.66	425.48	425.51	2700.0
2023-10-20 05:40:00	SPY	ETF	425.44	425.56	425.44	425.56	1736.0
2023-10-20 05:45:00	SPY	ETF	425.46	425.46	425.27	425.27	1700.0
2023-10-20 05:50:00	SPY	ETF	425.56	425.81	425.56	425.7	4330.0
2023-10-20 05:55:00	SPY	ETF	425.78	425.87	425.61	425.61	1450.0
2023-10-20 06:00:00	SPY	ETF	425.69	425.7	425.69	425.7	1900.0
2023-10-20 06:05:00	SPY	ETF	425.68	425.71	425.68	425.71	1433.0
2023-10-20 06:10:00	SPY	ETF	425.59	425.59	425.47	425.47	3750.0
2023-10-20 06:15:00	SPY	ETF	425.47	425.48	425.43	425.45	1850.0
2023-10-20 06:20:00	SPY	ETF	425.27	425.27	425.25	425.25	1100.0
2023-10-20 06:25:00	SPY	ETF	425.29	425.35	425.18	425.22	2823.0
2023-10-20 06:30:00	SPY	ETF	425.22	425.41	425.22	425.36	2100.0
2023-10-20 06:35:00	SPY	ETF	425.36	425.63	425.36	425.63	16300.0
2023-10-20 06:40:00	SPY	ETF	425.46	425.46	425.28	425.41	3188.0
2023-10-20 06:45:00	SPY	ETF	425.42	425.42	425.22	425.39	3008.0
2023-10-20 06:50:00	SPY	ETF	425.43	425.44	425.37	425.41	800.0
2023-10-20 06:55:00	SPY	ETF	425.39	425.49	425.28	425.39	3422.0
2023-10-20 07:00:00	SPY	ETF	425.38	425.52	425.31	425.31	13325.0
2023-10-20 07:05:00	SPY	ETF	425.38	425.74	425.38	425.74	5428.0
2023-10-20 07:10:00	SPY	ETF	425.69	425.91	425.69	425.88	29464.0
2023-10-20 07:15:00	SPY	ETF	425.88	426.03	425.88	425.92	60128.0
2023-10-20 07:20:00	SPY	ETF	425.91	425.91	425.75	425.87	13338.0
2023-10-20 07:25:00	SPY	ETF	425.76	425.88	425.69	425.83	12383.0
2023-10-20 07:30:00	SPY	ETF	425.77	425.85	425.71	425.76	4515.0
2023-10-20 07:35:00	SPY	ETF	425.69	425.85	425.65	425.84	14730.0
2023-10-20 07:40:00	SPY	ETF	425.85	425.86	425.44	425.61	23554.0
2023-10-20 07:45:00	SPY	ETF	425.7	425.87	425.65	425.72	20038.0
2023-10-20 07:50:00	SPY	ETF	425.67	425.96	425.65	425.86	15219.0
2023-10-20 07:55:00	SPY	ETF	425.95	426.28	425.95	426.08	66942.0
2023-10-20 08:00:00	SPY	ETF	426.05	426.6304	424.89	425.79	86905.0
2023-10-20 08:05:00	SPY	ETF	425.8	425.81	425.57	425.64	50643.0

> showing 50 of 101,490 rows — these rows as CSV

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