PREVIEW / etf_5min / 2023-11-15

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-11-15.parquet
  size:    2.2 MB
  rows:    107,778

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-15 04:00:00	SPY	ETF	450.66	450.67	450.39	450.52	18679.0
2023-11-15 04:05:00	SPY	ETF	450.52	450.61	450.39	450.43	15292.0
2023-11-15 04:10:00	SPY	ETF	450.43	450.45	450.13	450.22	9761.0
2023-11-15 04:15:00	SPY	ETF	450.26	450.3	449.93	449.93	8683.0
2023-11-15 04:20:00	SPY	ETF	449.99	450.1	449.89	450.03	7683.0
2023-11-15 04:25:00	SPY	ETF	450.06	450.09	449.86	449.98	9154.0
2023-11-15 04:30:00	SPY	ETF	449.94	449.98	449.84	449.92	5570.0
2023-11-15 04:40:00	SPY	ETF	449.78	449.78	449.68	449.68	500.0
2023-11-15 04:45:00	SPY	ETF	449.72	449.72	449.67	449.67	306.0
2023-11-15 04:50:00	SPY	ETF	449.65	449.73	449.65	449.71	2640.0
2023-11-15 04:55:00	SPY	ETF	449.78	449.79	449.75	449.79	438.0
2023-11-15 05:00:00	SPY	ETF	449.77	449.81	449.77	449.81	500.0
2023-11-15 05:05:00	SPY	ETF	449.97	449.97	449.97	449.97	100.0
2023-11-15 05:10:00	SPY	ETF	449.99	450.02	449.99	450.02	1227.0
2023-11-15 05:15:00	SPY	ETF	449.99	449.99	449.9	449.97	840.0
2023-11-15 05:20:00	SPY	ETF	450.0	450.03	450.0	450.03	581.0
2023-11-15 05:25:00	SPY	ETF	450.04	450.14	450.04	450.04	880.0
2023-11-15 05:30:00	SPY	ETF	450.17	450.31	450.17	450.29	5487.0
2023-11-15 05:35:00	SPY	ETF	450.4	450.54	450.4	450.54	3816.0
2023-11-15 05:45:00	SPY	ETF	450.52	450.52	450.51	450.51	349.0
2023-11-15 05:50:00	SPY	ETF	450.51	450.61	450.49	450.61	726.0
2023-11-15 05:55:00	SPY	ETF	450.61	450.61	450.53	450.54	1200.0
2023-11-15 06:00:00	SPY	ETF	450.5	450.5	450.48	450.48	300.0
2023-11-15 06:05:00	SPY	ETF	450.34	450.34	450.28	450.29	300.0
2023-11-15 06:10:00	SPY	ETF	450.28	450.28	450.2	450.2	209.0
2023-11-15 06:15:00	SPY	ETF	450.21	450.25	450.15	450.25	1000.0
2023-11-15 06:20:00	SPY	ETF	450.25	450.34	450.25	450.34	4073.0
2023-11-15 06:25:00	SPY	ETF	450.37	450.38	450.33	450.38	738.0
2023-11-15 06:30:00	SPY	ETF	450.35	450.57	450.35	450.57	18291.0
2023-11-15 06:35:00	SPY	ETF	450.59	450.65	450.55	450.57	5084.0
2023-11-15 06:40:00	SPY	ETF	450.65	450.68	450.52	450.52	51464.0
2023-11-15 06:45:00	SPY	ETF	450.63	450.72	450.63	450.72	2300.0
2023-11-15 06:50:00	SPY	ETF	450.66	450.75	450.66	450.74	3152.0
2023-11-15 06:55:00	SPY	ETF	450.74	450.76	450.74	450.76	379.0
2023-11-15 07:00:00	SPY	ETF	450.71	450.75	450.58	450.66	7555.0
2023-11-15 07:05:00	SPY	ETF	450.73	450.73	450.6	450.68	5385.0
2023-11-15 07:10:00	SPY	ETF	450.79	451.0	450.79	451.0	7478.0
2023-11-15 07:15:00	SPY	ETF	451.0	451.04	450.91	450.95	2378.0
2023-11-15 07:20:00	SPY	ETF	450.94	450.94	450.45	450.6	39713.0
2023-11-15 07:25:00	SPY	ETF	450.56	450.9	450.56	450.81	14275.0
2023-11-15 07:30:00	SPY	ETF	450.83	451.02	450.8	450.94	18058.0
2023-11-15 07:35:00	SPY	ETF	450.83	450.85	450.73	450.78	22330.0
2023-11-15 07:40:00	SPY	ETF	450.88	450.88	450.7	450.78	28516.0
2023-11-15 07:45:00	SPY	ETF	450.73	450.75	450.61	450.7	21218.0
2023-11-15 07:50:00	SPY	ETF	450.72	450.8	450.61	450.8	21118.0
2023-11-15 07:55:00	SPY	ETF	450.81	451.05	450.8	451.0	15095.0
2023-11-15 08:00:00	SPY	ETF	451.01	451.09	449.65	450.9	34191.0
2023-11-15 08:05:00	SPY	ETF	450.92	451.05	450.85	451.01	13765.0
2023-11-15 08:10:00	SPY	ETF	450.99	451.0	450.76	450.96	7012.0
2023-11-15 08:15:00	SPY	ETF	450.93	451.04	450.86	451.04	9979.0

> showing 50 of 107,778 rows — these rows as CSV

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