PREVIEW / etf_5min / 2023-09-18

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-09-18.parquet
  size:    1.9 MB
  rows:    92,616

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-09-18 04:00:00	SPY	ETF	444.0	444.18	444.0	444.05	5540.0
2023-09-18 04:05:00	SPY	ETF	444.0	444.09	443.97	444.08	2626.0
2023-09-18 04:10:00	SPY	ETF	444.14	444.15	444.11	444.11	537.0
2023-09-18 04:15:00	SPY	ETF	444.11	444.11	443.93	443.93	2758.0
2023-09-18 04:20:00	SPY	ETF	443.95	444.02	443.95	443.98	2516.0
2023-09-18 04:25:00	SPY	ETF	443.97	443.97	443.92	443.92	200.0
2023-09-18 04:30:00	SPY	ETF	443.87	443.96	443.87	443.96	2099.0
2023-09-18 04:35:00	SPY	ETF	443.95	444.16	443.94	444.16	1598.0
2023-09-18 04:40:00	SPY	ETF	444.12	444.17	444.0	444.0	2263.0
2023-09-18 04:45:00	SPY	ETF	443.95	443.98	443.92	443.98	390.0
2023-09-18 04:50:00	SPY	ETF	444.08	444.08	444.04	444.05	846.0
2023-09-18 04:55:00	SPY	ETF	444.0	444.0	443.85	443.85	824.0
2023-09-18 05:00:00	SPY	ETF	443.85	443.98	443.85	443.87	1420.0
2023-09-18 05:05:00	SPY	ETF	443.87	444.04	443.87	444.04	712.0
2023-09-18 05:10:00	SPY	ETF	443.95	443.95	443.87	443.9	889.0
2023-09-18 05:15:00	SPY	ETF	443.88	443.95	443.84	443.9	1723.0
2023-09-18 05:20:00	SPY	ETF	443.89	443.9	443.74	443.75	3699.0
2023-09-18 05:25:00	SPY	ETF	443.76	443.79	443.73	443.75	1327.0
2023-09-18 05:30:00	SPY	ETF	443.74	443.81	443.74	443.81	900.0
2023-09-18 05:35:00	SPY	ETF	443.71	443.71	443.69	443.69	3131.0
2023-09-18 05:40:00	SPY	ETF	443.73	443.73	443.73	443.73	270.0
2023-09-18 05:45:00	SPY	ETF	443.72	443.87	443.72	443.82	471.0
2023-09-18 05:50:00	SPY	ETF	443.73	443.73	443.73	443.73	725.0
2023-09-18 05:55:00	SPY	ETF	443.83	443.83	443.81	443.81	500.0
2023-09-18 06:05:00	SPY	ETF	443.78	443.78	443.78	443.78	262.0
2023-09-18 06:10:00	SPY	ETF	443.62	443.62	443.62	443.62	400.0
2023-09-18 06:15:00	SPY	ETF	443.71	443.71	443.71	443.71	374.0
2023-09-18 06:20:00	SPY	ETF	443.68	443.8	443.68	443.8	1005.0
2023-09-18 06:25:00	SPY	ETF	443.9	443.93	443.86	443.89	1562.0
2023-09-18 06:30:00	SPY	ETF	443.89	443.94	443.86	443.93	2507.0
2023-09-18 06:35:00	SPY	ETF	443.96	443.96	443.81	443.81	930.0
2023-09-18 06:40:00	SPY	ETF	443.82	443.82	443.79	443.79	4491.0
2023-09-18 06:45:00	SPY	ETF	443.85	443.85	443.83	443.83	840.0
2023-09-18 06:50:00	SPY	ETF	443.82	444.01	443.8	444.01	8099.0
2023-09-18 06:55:00	SPY	ETF	443.92	443.92	443.8	443.85	1942.0
2023-09-18 07:00:00	SPY	ETF	443.85	443.94	443.84	443.84	6278.0
2023-09-18 07:05:00	SPY	ETF	443.8	443.8	443.63	443.63	6827.0
2023-09-18 07:10:00	SPY	ETF	443.6	443.67	443.53	443.63	7656.0
2023-09-18 07:15:00	SPY	ETF	443.61	443.7	443.58	443.65	3743.0
2023-09-18 07:20:00	SPY	ETF	443.64	443.68	443.5	443.5	7906.0
2023-09-18 07:25:00	SPY	ETF	443.51	443.51	443.44	443.45	2486.0
2023-09-18 07:30:00	SPY	ETF	443.4	443.41	443.09	443.11	13730.0
2023-09-18 07:35:00	SPY	ETF	443.07	443.12	442.81	442.82	15846.0
2023-09-18 07:40:00	SPY	ETF	442.76	442.879	442.64	442.73	16911.0
2023-09-18 07:45:00	SPY	ETF	442.73	442.73	442.43	442.44	16698.0
2023-09-18 07:50:00	SPY	ETF	442.45	442.52	442.35	442.47	16895.0
2023-09-18 07:55:00	SPY	ETF	442.48	442.67	442.47	442.63	24690.0
2023-09-18 08:00:00	SPY	ETF	442.61	444.28	442.39	442.86	72866.0
2023-09-18 08:05:00	SPY	ETF	442.87	442.87	442.44	442.64	56189.0
2023-09-18 08:10:00	SPY	ETF	442.59	442.78	442.53	442.69	9956.0

> showing 50 of 92,616 rows — these rows as CSV

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