PREVIEW / etf_5min / 2023-01-27

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-01-27.parquet
  size:    2.0 MB
  rows:    97,479

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-01-27 04:00:00	SPY	ETF	403.42	404.0	403.2	403.49	7750.0
2023-01-27 04:05:00	SPY	ETF	403.44	403.44	403.3	403.35	10270.0
2023-01-27 04:10:00	SPY	ETF	403.36	403.53	403.35	403.49	3521.0
2023-01-27 04:15:00	SPY	ETF	403.49	403.52	403.46	403.47	51372.0
2023-01-27 04:20:00	SPY	ETF	403.49	403.57	403.39	403.39	329.0
2023-01-27 04:25:00	SPY	ETF	403.35	403.35	403.28	403.32	2007.0
2023-01-27 04:30:00	SPY	ETF	403.3	403.39	403.3	403.39	792.0
2023-01-27 04:35:00	SPY	ETF	403.39	403.47	403.39	403.46	3733.0
2023-01-27 04:40:00	SPY	ETF	403.38	403.44	403.32	403.44	409.0
2023-01-27 04:45:00	SPY	ETF	403.45	403.68	403.35	403.62	3826.0
2023-01-27 04:50:00	SPY	ETF	403.65	403.69	403.6	403.6	3276.0
2023-01-27 04:55:00	SPY	ETF	403.58	403.64	403.53	403.64	3616.0
2023-01-27 05:00:00	SPY	ETF	403.5	403.57	403.5	403.57	1976.0
2023-01-27 05:05:00	SPY	ETF	403.56	403.61	403.56	403.61	2869.0
2023-01-27 05:10:00	SPY	ETF	403.61	403.63	403.61	403.63	400.0
2023-01-27 05:15:00	SPY	ETF	403.53	403.53	403.5	403.51	2200.0
2023-01-27 05:20:00	SPY	ETF	403.53	403.86	403.53	403.84	3058.0
2023-01-27 05:25:00	SPY	ETF	403.75	403.8	403.73	403.73	1000.0
2023-01-27 05:30:00	SPY	ETF	403.69	403.7	403.65	403.68	899.0
2023-01-27 05:35:00	SPY	ETF	403.76	403.77	403.76	403.77	205.0
2023-01-27 05:40:00	SPY	ETF	403.77	403.8	403.74	403.8	4099.0
2023-01-27 05:45:00	SPY	ETF	403.69	403.72	403.56	403.56	4300.0
2023-01-27 05:50:00	SPY	ETF	403.67	403.75	403.67	403.75	721.0
2023-01-27 05:55:00	SPY	ETF	403.82	403.82	403.8	403.8	623.0
2023-01-27 06:00:00	SPY	ETF	403.81	403.95	403.81	403.91	2101.0
2023-01-27 06:05:00	SPY	ETF	404.0	404.08	403.97	403.97	1194.0
2023-01-27 06:10:00	SPY	ETF	403.96	403.96	403.86	403.86	2162.0
2023-01-27 06:15:00	SPY	ETF	403.86	403.93	403.84	403.93	1165.0
2023-01-27 06:20:00	SPY	ETF	403.77	403.9	403.74	403.9	1400.0
2023-01-27 06:25:00	SPY	ETF	403.9	403.9	403.77	403.77	500.0
2023-01-27 06:30:00	SPY	ETF	403.81	403.92	403.81	403.9	1178.0
2023-01-27 06:35:00	SPY	ETF	403.98	403.99	403.93	403.99	1220.0
2023-01-27 06:40:00	SPY	ETF	403.99	404.14	403.99	404.1	2219.0
2023-01-27 06:45:00	SPY	ETF	404.07	404.11	403.85	403.85	13312.0
2023-01-27 06:50:00	SPY	ETF	403.85	403.87	403.84	403.84	35096.0
2023-01-27 06:55:00	SPY	ETF	403.85	403.85	403.74	403.85	18431.0
2023-01-27 07:00:00	SPY	ETF	403.9	404.16	403.8	404.1	104741.0
2023-01-27 07:05:00	SPY	ETF	404.17	404.24	404.1	404.15	53331.0
2023-01-27 07:10:00	SPY	ETF	404.11	404.18	404.11	404.15	8100.0
2023-01-27 07:15:00	SPY	ETF	404.18	404.28	404.12	404.28	8522.0
2023-01-27 07:20:00	SPY	ETF	404.26	404.29	404.14	404.19	3260.0
2023-01-27 07:25:00	SPY	ETF	404.15	404.15	403.67	403.71	19765.0
2023-01-27 07:30:00	SPY	ETF	403.7	403.86	403.61	403.61	7363.0
2023-01-27 07:35:00	SPY	ETF	403.62	403.64	403.42	403.46	21405.0
2023-01-27 07:40:00	SPY	ETF	403.56	403.58	403.46	403.46	3922.0
2023-01-27 07:45:00	SPY	ETF	403.46	403.54	403.34	403.54	33622.0
2023-01-27 07:50:00	SPY	ETF	403.58	403.6	403.26	403.32	27472.0
2023-01-27 07:55:00	SPY	ETF	403.35	403.51	403.33	403.33	20260.0
2023-01-27 08:00:00	SPY	ETF	404.06	404.25	403.21	403.46	63947.0
2023-01-27 08:05:00	SPY	ETF	403.48	403.51	403.31	403.43	25443.0

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

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