PREVIEW / etf_5min / 2023-03-09

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-03-09.parquet
  size:    2.0 MB
  rows:    97,539

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-03-09 04:00:00	SPY	ETF	398.18	398.22	397.89	397.91	6365.0
2023-03-09 04:05:00	SPY	ETF	397.97	398.01	397.93	398.01	3480.0
2023-03-09 04:10:00	SPY	ETF	398.03	398.07	398.03	398.07	1355.0
2023-03-09 04:15:00	SPY	ETF	397.94	397.97	397.94	397.97	309.0
2023-03-09 04:20:00	SPY	ETF	397.79	397.89	397.79	397.89	2200.0
2023-03-09 04:25:00	SPY	ETF	397.89	397.94	397.85	397.85	2175.0
2023-03-09 04:35:00	SPY	ETF	397.89	398.01	397.85	397.92	4916.0
2023-03-09 04:40:00	SPY	ETF	397.9	397.91	397.83	397.84	700.0
2023-03-09 04:45:00	SPY	ETF	397.8	397.8	397.54	397.7	2804.0
2023-03-09 04:50:00	SPY	ETF	397.55	397.69	397.55	397.59	1418.0
2023-03-09 04:55:00	SPY	ETF	397.62	397.62	397.48	397.52	7657.0
2023-03-09 05:00:00	SPY	ETF	397.48	397.54	397.48	397.49	2403.0
2023-03-09 05:05:00	SPY	ETF	397.54	397.56	397.49	397.53	1500.0
2023-03-09 05:10:00	SPY	ETF	397.64	397.69	397.62	397.67	4916.0
2023-03-09 05:15:00	SPY	ETF	397.6	397.64	397.57	397.64	900.0
2023-03-09 05:20:00	SPY	ETF	397.58	397.58	397.42	397.42	4398.0
2023-03-09 05:25:00	SPY	ETF	397.6	397.64	397.6	397.6	1210.0
2023-03-09 05:30:00	SPY	ETF	397.72	397.89	397.7	397.89	1862.0
2023-03-09 05:35:00	SPY	ETF	397.81	397.85	397.8	397.84	4100.0
2023-03-09 05:40:00	SPY	ETF	397.93	398.01	397.9	397.9	1450.0
2023-03-09 05:45:00	SPY	ETF	397.98	397.98	397.98	397.98	100.0
2023-03-09 05:50:00	SPY	ETF	397.9	398.0	397.9	398.0	4708.0
2023-03-09 05:55:00	SPY	ETF	397.99	398.07	397.98	398.05	1097.0
2023-03-09 06:00:00	SPY	ETF	398.06	398.09	398.05	398.09	3200.0
2023-03-09 06:05:00	SPY	ETF	398.21	398.25	398.19	398.25	5300.0
2023-03-09 06:10:00	SPY	ETF	398.26	398.27	398.2	398.2	535.0
2023-03-09 06:15:00	SPY	ETF	398.19	398.22	398.18	398.21	1030.0
2023-03-09 06:20:00	SPY	ETF	398.22	398.22	397.99	398.17	1504.0
2023-03-09 06:25:00	SPY	ETF	398.22	398.34	398.22	398.34	7440.0
2023-03-09 06:30:00	SPY	ETF	398.28	398.33	398.22	398.33	1616.0
2023-03-09 06:35:00	SPY	ETF	398.34	398.37	398.29	398.3	6653.0
2023-03-09 06:40:00	SPY	ETF	398.35	398.45	398.35	398.45	502.0
2023-03-09 06:45:00	SPY	ETF	398.42	398.45	398.28	398.28	7337.0
2023-03-09 06:50:00	SPY	ETF	398.31	398.36	398.31	398.32	3445.0
2023-03-09 06:55:00	SPY	ETF	398.27	398.3	398.27	398.28	11900.0
2023-03-09 07:00:00	SPY	ETF	398.38	398.41	398.15	398.15	17315.0
2023-03-09 07:05:00	SPY	ETF	398.15	398.15	397.89	397.96	30283.0
2023-03-09 07:10:00	SPY	ETF	398.01	398.06	397.89	397.89	1875.0
2023-03-09 07:15:00	SPY	ETF	397.9	398.06	397.8	398.04	14389.0
2023-03-09 07:20:00	SPY	ETF	398.0	398.0	397.85	397.91	9823.0
2023-03-09 07:25:00	SPY	ETF	397.97	398.0	397.92	397.98	11390.0
2023-03-09 07:30:00	SPY	ETF	398.0	398.04	397.5	397.64	62658.0
2023-03-09 07:35:00	SPY	ETF	397.64	397.8	397.64	397.8	6881.0
2023-03-09 07:40:00	SPY	ETF	397.84	397.86	397.67	397.68	44075.0
2023-03-09 07:45:00	SPY	ETF	397.77	397.79	397.72	397.73	5429.0
2023-03-09 07:50:00	SPY	ETF	397.8	398.12	397.8	398.12	24034.0
2023-03-09 07:55:00	SPY	ETF	398.16	398.16	397.88	397.91	37829.0
2023-03-09 08:00:00	SPY	ETF	397.91	398.61	397.5296	397.83	46861.0
2023-03-09 08:05:00	SPY	ETF	397.86	397.91	397.65	397.67	29153.0
2023-03-09 08:10:00	SPY	ETF	397.66	398.28	397.56	397.58	22682.0

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

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