PREVIEW / etf_5min / 2023-11-27

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-11-27.parquet
  size:    2.1 MB
  rows:    101,139

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-11-27 04:00:00	SPY	ETF	454.62	454.71	454.36	454.39	3346.0
2023-11-27 04:05:00	SPY	ETF	454.37	454.4	454.29	454.37	3186.0
2023-11-27 04:10:00	SPY	ETF	454.37	454.53	454.35	454.53	1360.0
2023-11-27 04:15:00	SPY	ETF	454.55	454.55	454.35	454.36	3411.0
2023-11-27 04:20:00	SPY	ETF	454.37	454.37	454.34	454.34	1712.0
2023-11-27 04:25:00	SPY	ETF	454.35	454.35	454.35	454.35	500.0
2023-11-27 04:35:00	SPY	ETF	454.23	454.23	454.23	454.23	500.0
2023-11-27 04:40:00	SPY	ETF	454.17	454.19	454.17	454.19	836.0
2023-11-27 04:50:00	SPY	ETF	454.17	454.17	454.17	454.17	1067.0
2023-11-27 04:55:00	SPY	ETF	454.11	454.11	454.0	454.0	700.0
2023-11-27 05:00:00	SPY	ETF	454.07	454.07	454.07	454.07	100.0
2023-11-27 05:05:00	SPY	ETF	454.28	454.28	454.21	454.21	663.0
2023-11-27 05:10:00	SPY	ETF	454.32	454.49	454.32	454.47	1490.0
2023-11-27 05:15:00	SPY	ETF	454.5	454.59	454.47	454.59	1140.0
2023-11-27 05:20:00	SPY	ETF	454.62	454.64	454.62	454.64	1773.0
2023-11-27 05:25:00	SPY	ETF	454.68	454.7	454.68	454.7	662.0
2023-11-27 05:30:00	SPY	ETF	454.65	454.65	454.6	454.6	1079.0
2023-11-27 05:35:00	SPY	ETF	454.6	454.6	454.53	454.53	2652.0
2023-11-27 05:40:00	SPY	ETF	454.72	454.75	454.72	454.75	2575.0
2023-11-27 05:45:00	SPY	ETF	454.8	454.8	454.8	454.8	305.0
2023-11-27 05:50:00	SPY	ETF	454.8	454.89	454.8	454.89	2406.0
2023-11-27 05:55:00	SPY	ETF	454.93	454.96	454.93	454.96	1000.0
2023-11-27 06:00:00	SPY	ETF	454.91	454.95	454.9	454.93	1856.0
2023-11-27 06:05:00	SPY	ETF	454.99	454.99	454.93	454.93	700.0
2023-11-27 06:10:00	SPY	ETF	455.0	455.0	455.0	455.0	1827.0
2023-11-27 06:15:00	SPY	ETF	454.82	454.86	454.82	454.82	1632.0
2023-11-27 06:20:00	SPY	ETF	454.82	454.82	454.79	454.79	600.0
2023-11-27 06:30:00	SPY	ETF	454.74	454.76	454.74	454.76	823.0
2023-11-27 06:35:00	SPY	ETF	454.79	454.79	454.79	454.79	200.0
2023-11-27 06:45:00	SPY	ETF	454.67	454.67	454.67	454.67	430.0
2023-11-27 06:55:00	SPY	ETF	454.61	454.61	454.61	454.61	600.0
2023-11-27 07:00:00	SPY	ETF	454.67	454.75	454.67	454.75	1221.0
2023-11-27 07:05:00	SPY	ETF	454.85	454.85	454.85	454.85	200.0
2023-11-27 07:10:00	SPY	ETF	454.91	454.93	454.91	454.93	625.0
2023-11-27 07:15:00	SPY	ETF	454.86	454.86	454.8	454.84	12663.0
2023-11-27 07:20:00	SPY	ETF	454.9	454.9	454.82	454.82	1304.0
2023-11-27 07:25:00	SPY	ETF	454.79	454.79	454.6	454.6	2483.0
2023-11-27 07:30:00	SPY	ETF	454.8	454.8	454.7	454.7	2700.0
2023-11-27 07:35:00	SPY	ETF	454.7	454.72	454.63	454.63	2883.0
2023-11-27 07:40:00	SPY	ETF	454.63	454.71	454.58	454.63	2788.0
2023-11-27 07:45:00	SPY	ETF	454.62	454.62	454.56	454.62	6583.0
2023-11-27 07:50:00	SPY	ETF	454.68	454.68	454.68	454.68	200.0
2023-11-27 07:55:00	SPY	ETF	454.68	454.69	454.62	454.62	2187.0
2023-11-27 08:00:00	SPY	ETF	454.6817	454.9704	453.77	454.74	39688.0
2023-11-27 08:05:00	SPY	ETF	454.83	454.95	454.82	454.9	11238.0
2023-11-27 08:10:00	SPY	ETF	454.8909	454.98	454.8909	454.91	9760.0
2023-11-27 08:15:00	SPY	ETF	454.91	454.91	454.8	454.86	10695.0
2023-11-27 08:20:00	SPY	ETF	454.86	454.94	454.83	454.91	11682.0
2023-11-27 08:25:00	SPY	ETF	454.91	454.98	454.86	454.95	20954.0
2023-11-27 08:30:00	SPY	ETF	454.95	454.96	454.83	454.86	19522.0

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

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