PREVIEW / etf_5min / 2023-01-06

all etf 5-min files

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

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-06 04:00:00	SPY	ETF	380.0	380.0	379.75	379.79	7600.0
2023-01-06 04:05:00	SPY	ETF	379.77	379.81	379.5	379.5	4865.0
2023-01-06 04:10:00	SPY	ETF	379.6	379.6	379.28	379.28	1349.0
2023-01-06 04:15:00	SPY	ETF	379.38	379.56	379.38	379.54	1365.0
2023-01-06 04:20:00	SPY	ETF	379.43	379.43	379.18	379.3	6190.0
2023-01-06 04:25:00	SPY	ETF	379.25	379.25	379.25	379.25	300.0
2023-01-06 04:30:00	SPY	ETF	379.2	379.23	379.09	379.15	7650.0
2023-01-06 04:35:00	SPY	ETF	379.13	379.13	378.99	379.08	1137.0
2023-01-06 04:40:00	SPY	ETF	379.08	379.45	379.08	379.38	4295.0
2023-01-06 04:45:00	SPY	ETF	379.32	379.42	379.32	379.42	200.0
2023-01-06 04:50:00	SPY	ETF	379.38	379.38	379.3	379.3	1200.0
2023-01-06 04:55:00	SPY	ETF	379.45	379.49	379.41	379.48	2519.0
2023-01-06 05:00:00	SPY	ETF	379.38	379.38	379.17	379.18	3512.0
2023-01-06 05:05:00	SPY	ETF	379.44	379.44	379.34	379.34	240.0
2023-01-06 05:10:00	SPY	ETF	379.55	379.69	379.55	379.69	1500.0
2023-01-06 05:15:00	SPY	ETF	379.68	379.92	379.68	379.77	2645.0
2023-01-06 05:25:00	SPY	ETF	379.68	379.68	379.52	379.52	219.0
2023-01-06 05:30:00	SPY	ETF	379.62	379.62	379.52	379.59	7093.0
2023-01-06 05:35:00	SPY	ETF	379.69	379.7	379.69	379.7	1300.0
2023-01-06 05:40:00	SPY	ETF	379.78	379.93	379.78	379.82	1100.0
2023-01-06 05:45:00	SPY	ETF	379.86	379.86	379.73	379.73	1651.0
2023-01-06 05:50:00	SPY	ETF	379.84	379.84	379.63	379.63	833.0
2023-01-06 05:55:00	SPY	ETF	379.59	379.59	379.38	379.38	1794.0
2023-01-06 06:00:00	SPY	ETF	379.38	379.54	379.31	379.54	2785.0
2023-01-06 06:05:00	SPY	ETF	379.58	379.65	379.58	379.63	950.0
2023-01-06 06:10:00	SPY	ETF	379.8	379.89	379.8	379.82	3950.0
2023-01-06 06:15:00	SPY	ETF	379.9	379.9	379.9	379.9	9000.0
2023-01-06 06:20:00	SPY	ETF	379.9	380.04	379.9	379.94	42755.0
2023-01-06 06:25:00	SPY	ETF	379.95	379.98	379.7	379.7	2443.0
2023-01-06 06:30:00	SPY	ETF	379.85	379.85	379.69	379.71	992.0
2023-01-06 06:35:00	SPY	ETF	379.66	379.66	379.51	379.53	2850.0
2023-01-06 06:40:00	SPY	ETF	379.3	379.49	379.3	379.49	2770.0
2023-01-06 06:45:00	SPY	ETF	379.5	379.57	379.46	379.53	934.0
2023-01-06 06:50:00	SPY	ETF	379.57	379.62	379.55	379.61	4129.0
2023-01-06 06:55:00	SPY	ETF	379.66	379.66	379.6	379.66	399.0
2023-01-06 07:00:00	SPY	ETF	379.55	379.57	379.41	379.48	21982.0
2023-01-06 07:05:00	SPY	ETF	379.47	379.47	379.35	379.47	19642.0
2023-01-06 07:10:00	SPY	ETF	379.3	379.3	379.27	379.28	800.0
2023-01-06 07:15:00	SPY	ETF	379.37	379.42	379.26	379.36	23452.0
2023-01-06 07:20:00	SPY	ETF	379.43	379.53	379.4	379.53	23709.0
2023-01-06 07:25:00	SPY	ETF	379.57	379.66	379.47	379.47	19468.0
2023-01-06 07:30:00	SPY	ETF	379.55	379.6	379.5	379.52	5084.0
2023-01-06 07:35:00	SPY	ETF	379.48	379.48	379.28	379.35	17511.0
2023-01-06 07:40:00	SPY	ETF	379.38	379.45	379.15	379.15	28229.0
2023-01-06 07:45:00	SPY	ETF	379.19	379.34	379.13	379.26	15921.0
2023-01-06 07:50:00	SPY	ETF	379.34	379.62	379.31	379.58	23629.0
2023-01-06 07:55:00	SPY	ETF	379.58	379.58	379.36	379.44	35830.0
2023-01-06 08:00:00	SPY	ETF	379.43	380.89	378.96	378.99	26537.0
2023-01-06 08:05:00	SPY	ETF	379.03	379.25	378.98	379.25	36866.0
2023-01-06 08:10:00	SPY	ETF	379.28	379.38	379.18	379.24	12531.0

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

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