PREVIEW / etf_5min / 2023-07-03

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-03.parquet
  size:    1.3 MB
  rows:    59,510

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-07-03 04:00:00	SPY	ETF	443.5	443.64	443.5	443.63	3820.0
2023-07-03 04:05:00	SPY	ETF	443.65	443.68	443.57	443.58	3819.0
2023-07-03 04:10:00	SPY	ETF	443.63	443.75	443.63	443.74	9433.0
2023-07-03 04:15:00	SPY	ETF	443.65	443.67	443.64	443.67	831.0
2023-07-03 04:20:00	SPY	ETF	443.72	443.72	443.58	443.6	900.0
2023-07-03 04:25:00	SPY	ETF	443.6	443.67	443.6	443.67	604.0
2023-07-03 04:30:00	SPY	ETF	443.69	443.79	443.69	443.79	614.0
2023-07-03 04:35:00	SPY	ETF	443.81	443.85	443.76	443.85	3380.0
2023-07-03 04:40:00	SPY	ETF	443.83	443.83	443.8	443.8	500.0
2023-07-03 04:45:00	SPY	ETF	443.84	443.84	443.77	443.77	1283.0
2023-07-03 04:50:00	SPY	ETF	443.77	443.8	443.77	443.8	382.0
2023-07-03 04:55:00	SPY	ETF	443.69	443.71	443.67	443.71	2359.0
2023-07-03 05:00:00	SPY	ETF	443.71	443.71	443.67	443.69	960.0
2023-07-03 05:05:00	SPY	ETF	443.61	443.61	443.61	443.61	962.0
2023-07-03 05:10:00	SPY	ETF	443.66	443.66	443.59	443.59	3900.0
2023-07-03 05:15:00	SPY	ETF	443.65	443.69	443.65	443.69	545.0
2023-07-03 05:20:00	SPY	ETF	443.67	443.67	443.59	443.61	400.0
2023-07-03 05:25:00	SPY	ETF	443.65	443.65	443.63	443.63	271.0
2023-07-03 05:30:00	SPY	ETF	443.57	443.63	443.55	443.57	5734.0
2023-07-03 05:35:00	SPY	ETF	443.56	443.62	443.56	443.6	303.0
2023-07-03 05:40:00	SPY	ETF	443.51	443.51	443.51	443.51	446.0
2023-07-03 05:45:00	SPY	ETF	443.52	443.58	443.52	443.58	300.0
2023-07-03 05:50:00	SPY	ETF	443.59	443.62	443.52	443.52	2455.0
2023-07-03 05:55:00	SPY	ETF	443.58	443.58	443.58	443.58	142.0
2023-07-03 06:00:00	SPY	ETF	443.6	443.65	443.6	443.65	1375.0
2023-07-03 06:05:00	SPY	ETF	443.52	443.61	443.31	443.58	37714.0
2023-07-03 06:10:00	SPY	ETF	443.59	443.65	443.56	443.57	36894.0
2023-07-03 06:15:00	SPY	ETF	443.57	443.82	443.57	443.81	49744.0
2023-07-03 06:20:00	SPY	ETF	443.74	443.89	443.74	443.82	42114.0
2023-07-03 06:25:00	SPY	ETF	443.93	443.95	443.93	443.95	800.0
2023-07-03 06:30:00	SPY	ETF	443.9	443.92	443.9	443.92	600.0
2023-07-03 06:35:00	SPY	ETF	443.93	443.93	443.91	443.91	1178.0
2023-07-03 06:40:00	SPY	ETF	443.87	443.91	443.86	443.86	1103.0
2023-07-03 06:45:00	SPY	ETF	443.8	443.8	443.68	443.7	7100.0
2023-07-03 06:50:00	SPY	ETF	443.77	443.8	443.75	443.8	900.0
2023-07-03 06:55:00	SPY	ETF	443.8	443.82	443.61	443.61	3926.0
2023-07-03 07:00:00	SPY	ETF	443.62	443.68	443.55	443.68	5284.0
2023-07-03 07:05:00	SPY	ETF	443.63	443.63	443.54	443.56	4035.0
2023-07-03 07:10:00	SPY	ETF	443.58	443.6	443.44	443.51	3298.0
2023-07-03 07:15:00	SPY	ETF	443.49	443.51	443.46	443.48	1267.0
2023-07-03 07:20:00	SPY	ETF	443.51	443.57	443.51	443.55	2291.0
2023-07-03 07:25:00	SPY	ETF	443.58	443.58	443.521	443.521	700.0
2023-07-03 07:30:00	SPY	ETF	443.5	443.5	443.31	443.31	3428.0
2023-07-03 07:35:00	SPY	ETF	443.33	443.44	443.27	443.32	13233.0
2023-07-03 07:40:00	SPY	ETF	443.3	443.3	443.14	443.18	7140.0
2023-07-03 07:45:00	SPY	ETF	443.18	443.19	443.16	443.19	2125.0
2023-07-03 07:50:00	SPY	ETF	443.2	443.2	443.11	443.12	2125.0
2023-07-03 07:55:00	SPY	ETF	443.1	443.24	443.1	443.17	1085.0
2023-07-03 08:00:00	SPY	ETF	443.5311	443.89	443.04	443.0799	43431.0
2023-07-03 08:05:00	SPY	ETF	443.08	443.12	443.0203	443.11	5973.0

> showing 50 of 59,510 rows — these rows as CSV

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