PREVIEW / etf_5min / 2023-09-13

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-09-13.parquet
  size:    1.9 MB
  rows:    91,866

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-13 04:00:00	SPY	ETF	446.06	446.2	445.99	446.2	2702.0
2023-09-13 04:05:00	SPY	ETF	446.02	446.06	446.0	446.06	500.0
2023-09-13 04:10:00	SPY	ETF	446.0	446.0	445.91	445.91	865.0
2023-09-13 04:15:00	SPY	ETF	446.04	446.04	445.84	445.88	518.0
2023-09-13 04:20:00	SPY	ETF	445.79	446.0	445.79	446.0	1125.0
2023-09-13 04:25:00	SPY	ETF	445.94	446.06	445.93	445.94	3941.0
2023-09-13 04:35:00	SPY	ETF	445.8	445.84	445.63	445.63	2921.0
2023-09-13 04:40:00	SPY	ETF	445.65	445.65	445.57	445.63	1540.0
2023-09-13 04:45:00	SPY	ETF	445.69	445.7	445.55	445.55	1664.0
2023-09-13 04:50:00	SPY	ETF	445.65	445.65	445.65	445.65	100.0
2023-09-13 04:55:00	SPY	ETF	445.7	445.75	445.52	445.55	2174.0
2023-09-13 05:00:00	SPY	ETF	445.55	445.55	445.48	445.5	3085.0
2023-09-13 05:05:00	SPY	ETF	445.6	445.6	445.6	445.6	270.0
2023-09-13 05:10:00	SPY	ETF	445.72	445.72	445.7	445.7	231.0
2023-09-13 05:15:00	SPY	ETF	445.75	445.9	445.75	445.83	500.0
2023-09-13 05:20:00	SPY	ETF	445.86	445.88	445.86	445.88	855.0
2023-09-13 05:25:00	SPY	ETF	445.88	445.89	445.78	445.78	300.0
2023-09-13 05:30:00	SPY	ETF	445.82	445.82	445.82	445.82	118.0
2023-09-13 05:40:00	SPY	ETF	445.99	446.0	445.95	445.95	5117.0
2023-09-13 05:45:00	SPY	ETF	445.69	445.74	445.58	445.58	2948.0
2023-09-13 05:50:00	SPY	ETF	445.76	445.76	445.76	445.76	136.0
2023-09-13 05:55:00	SPY	ETF	445.75	445.86	445.75	445.84	1246.0
2023-09-13 06:05:00	SPY	ETF	445.65	445.65	445.45	445.45	600.0
2023-09-13 06:10:00	SPY	ETF	445.38	445.39	445.24	445.24	13922.0
2023-09-13 06:15:00	SPY	ETF	445.31	445.31	445.19	445.24	3101.0
2023-09-13 06:20:00	SPY	ETF	445.22	445.34	445.22	445.25	4404.0
2023-09-13 06:25:00	SPY	ETF	445.26	445.29	445.24	445.24	3601.0
2023-09-13 06:30:00	SPY	ETF	445.21	445.4	445.21	445.39	2190.0
2023-09-13 06:35:00	SPY	ETF	445.41	445.41	445.41	445.41	110.0
2023-09-13 06:45:00	SPY	ETF	445.42	445.44	445.42	445.44	6625.0
2023-09-13 06:50:00	SPY	ETF	445.51	445.64	445.51	445.6	5220.0
2023-09-13 06:55:00	SPY	ETF	445.58	445.61	445.58	445.61	750.0
2023-09-13 07:00:00	SPY	ETF	445.75	445.75	445.6	445.6	9335.0
2023-09-13 07:05:00	SPY	ETF	445.6	445.6	445.48	445.5	51526.0
2023-09-13 07:10:00	SPY	ETF	445.4	445.4	445.26	445.26	5957.0
2023-09-13 07:15:00	SPY	ETF	445.3	445.37	445.3	445.33	1690.0
2023-09-13 07:20:00	SPY	ETF	445.32	445.44	445.32	445.44	12020.0
2023-09-13 07:25:00	SPY	ETF	445.49	445.66	445.49	445.62	3153.0
2023-09-13 07:30:00	SPY	ETF	445.7	445.7	445.62	445.7	4953.0
2023-09-13 07:35:00	SPY	ETF	445.71	445.8	445.65	445.65	13880.0
2023-09-13 07:40:00	SPY	ETF	445.69	445.86	445.63	445.86	10417.0
2023-09-13 07:45:00	SPY	ETF	445.76	445.97	445.76	445.97	53062.0
2023-09-13 07:50:00	SPY	ETF	445.97	446.09	445.91	446.08	11463.0
2023-09-13 07:55:00	SPY	ETF	446.129	446.18	446.129	446.18	1706.0
2023-09-13 08:00:00	SPY	ETF	445.5	446.4	445.25	445.9	73792.0
2023-09-13 08:05:00	SPY	ETF	445.91	446.18	445.84	446.18	15835.0
2023-09-13 08:10:00	SPY	ETF	446.18	446.28	446.09	446.19	19312.0
2023-09-13 08:15:00	SPY	ETF	445.99	446.22	445.99	446.22	3766.0
2023-09-13 08:20:00	SPY	ETF	446.25	446.25	445.94	445.94	10021.0
2023-09-13 08:25:00	SPY	ETF	445.94	446.07	445.83	446.07	53868.0

> showing 50 of 91,866 rows — these rows as CSV

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