PREVIEW / etf_1min / 2023-07-19

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-07-19.parquet
  size:    4.7 MB
  rows:    267,190

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-07-19 04:00:00	SPY	ETF	454.09	454.16	454.09	454.12	800.0
2023-07-19 04:02:00	SPY	ETF	454.15	454.17	454.14	454.15	9100.0
2023-07-19 04:03:00	SPY	ETF	454.15	454.15	454.15	454.15	12542.0
2023-07-19 04:04:00	SPY	ETF	454.15	454.25	454.15	454.25	11700.0
2023-07-19 04:05:00	SPY	ETF	454.24	454.25	454.24	454.25	521.0
2023-07-19 04:07:00	SPY	ETF	454.31	454.31	454.27	454.27	809.0
2023-07-19 04:08:00	SPY	ETF	454.25	454.25	454.25	454.25	100.0
2023-07-19 04:10:00	SPY	ETF	454.15	454.15	454.15	454.15	350.0
2023-07-19 04:11:00	SPY	ETF	454.23	454.23	454.23	454.23	150.0
2023-07-19 04:12:00	SPY	ETF	454.26	454.26	454.26	454.26	1000.0
2023-07-19 04:13:00	SPY	ETF	454.25	454.25	454.25	454.25	112.0
2023-07-19 04:17:00	SPY	ETF	454.33	454.33	454.33	454.33	1000.0
2023-07-19 04:21:00	SPY	ETF	454.37	454.39	454.37	454.39	1600.0
2023-07-19 04:22:00	SPY	ETF	454.45	454.45	454.42	454.42	241.0
2023-07-19 04:23:00	SPY	ETF	454.38	454.38	454.34	454.34	1541.0
2023-07-19 04:24:00	SPY	ETF	454.33	454.38	454.33	454.38	1355.0
2023-07-19 04:27:00	SPY	ETF	454.49	454.5	454.49	454.5	350.0
2023-07-19 04:31:00	SPY	ETF	454.43	454.44	454.4	454.43	1028.0
2023-07-19 04:37:00	SPY	ETF	454.46	454.46	454.46	454.46	100.0
2023-07-19 04:38:00	SPY	ETF	454.5	454.51	454.5	454.51	500.0
2023-07-19 04:39:00	SPY	ETF	454.5	454.5	454.5	454.5	100.0
2023-07-19 04:41:00	SPY	ETF	454.6	454.6	454.6	454.6	400.0
2023-07-19 04:43:00	SPY	ETF	454.57	454.57	454.55	454.55	300.0
2023-07-19 04:45:00	SPY	ETF	454.55	454.55	454.52	454.52	300.0
2023-07-19 04:49:00	SPY	ETF	454.61	454.61	454.61	454.61	1000.0
2023-07-19 04:51:00	SPY	ETF	454.59	454.59	454.59	454.59	250.0
2023-07-19 04:53:00	SPY	ETF	454.54	454.54	454.53	454.53	200.0
2023-07-19 04:55:00	SPY	ETF	454.55	454.55	454.55	454.55	222.0
2023-07-19 05:03:00	SPY	ETF	454.42	454.42	454.42	454.42	321.0
2023-07-19 05:04:00	SPY	ETF	454.45	454.45	454.45	454.45	100.0
2023-07-19 05:05:00	SPY	ETF	454.51	454.51	454.51	454.51	100.0
2023-07-19 05:09:00	SPY	ETF	454.51	454.54	454.51	454.53	3800.0
2023-07-19 05:10:00	SPY	ETF	454.51	454.51	454.51	454.51	500.0
2023-07-19 05:12:00	SPY	ETF	454.49	454.49	454.49	454.49	100.0
2023-07-19 05:13:00	SPY	ETF	454.51	454.51	454.51	454.51	100.0
2023-07-19 05:14:00	SPY	ETF	454.56	454.56	454.56	454.56	100.0
2023-07-19 05:15:00	SPY	ETF	454.54	454.54	454.54	454.54	100.0
2023-07-19 05:16:00	SPY	ETF	454.53	454.53	454.5	454.5	200.0
2023-07-19 05:18:00	SPY	ETF	454.45	454.45	454.45	454.45	100.0
2023-07-19 05:19:00	SPY	ETF	454.5	454.5	454.5	454.5	397.0
2023-07-19 05:20:00	SPY	ETF	454.59	454.59	454.59	454.59	100.0
2023-07-19 05:22:00	SPY	ETF	454.6	454.6	454.6	454.6	100.0
2023-07-19 05:23:00	SPY	ETF	454.6	454.6	454.6	454.6	400.0
2023-07-19 05:26:00	SPY	ETF	454.51	454.51	454.51	454.51	324.0
2023-07-19 05:27:00	SPY	ETF	454.5	454.5	454.5	454.5	500.0
2023-07-19 05:28:00	SPY	ETF	454.47	454.47	454.47	454.47	100.0
2023-07-19 05:33:00	SPY	ETF	454.45	454.45	454.45	454.45	100.0
2023-07-19 05:35:00	SPY	ETF	454.53	454.53	454.53	454.53	200.0
2023-07-19 05:37:00	SPY	ETF	454.58	454.58	454.58	454.58	217.0
2023-07-19 05:38:00	SPY	ETF	454.61	454.61	454.61	454.61	400.0

> showing 50 of 267,190 rows — these rows as CSV

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