PREVIEW / etf_1min / 2023-09-07

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-09-07.parquet
  size:    4.4 MB
  rows:    250,606

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-09-07 04:00:00	SPY	ETF	445.6	445.6	445.48	445.51	5211.0
2023-09-07 04:02:00	SPY	ETF	445.4	445.4	445.4	445.4	500.0
2023-09-07 04:03:00	SPY	ETF	445.41	445.41	445.34	445.37	400.0
2023-09-07 04:04:00	SPY	ETF	445.34	445.42	445.34	445.36	710.0
2023-09-07 04:05:00	SPY	ETF	445.34	445.35	445.34	445.34	800.0
2023-09-07 04:06:00	SPY	ETF	445.32	445.4	445.32	445.4	604.0
2023-09-07 04:07:00	SPY	ETF	445.27	445.27	445.27	445.27	105.0
2023-09-07 04:08:00	SPY	ETF	445.27	445.32	445.21	445.32	1214.0
2023-09-07 04:09:00	SPY	ETF	445.2	445.21	445.13	445.13	14572.0
2023-09-07 04:10:00	SPY	ETF	445.13	445.13	444.97	444.97	300.0
2023-09-07 04:11:00	SPY	ETF	445.04	445.04	445.03	445.03	600.0
2023-09-07 04:12:00	SPY	ETF	444.92	444.92	444.92	444.92	268.0
2023-09-07 04:13:00	SPY	ETF	444.9	444.97	444.9	444.97	200.0
2023-09-07 04:15:00	SPY	ETF	445.04	445.04	445.04	445.04	200.0
2023-09-07 04:18:00	SPY	ETF	445.05	445.05	445.05	445.05	600.0
2023-09-07 04:21:00	SPY	ETF	444.88	444.88	444.88	444.88	400.0
2023-09-07 04:22:00	SPY	ETF	444.9	444.9	444.85	444.85	986.0
2023-09-07 04:24:00	SPY	ETF	444.82	444.82	444.81	444.81	200.0
2023-09-07 04:25:00	SPY	ETF	444.72	444.72	444.72	444.72	300.0
2023-09-07 04:28:00	SPY	ETF	444.6	444.6	444.6	444.6	100.0
2023-09-07 04:31:00	SPY	ETF	444.85	444.85	444.85	444.85	100.0
2023-09-07 04:32:00	SPY	ETF	444.85	444.85	444.85	444.85	700.0
2023-09-07 04:34:00	SPY	ETF	444.96	444.96	444.86	444.86	1600.0
2023-09-07 04:35:00	SPY	ETF	444.88	444.88	444.87	444.87	1000.0
2023-09-07 04:36:00	SPY	ETF	444.87	444.87	444.87	444.87	100.0
2023-09-07 04:37:00	SPY	ETF	444.74	444.74	444.72	444.72	250.0
2023-09-07 04:38:00	SPY	ETF	444.72	444.72	444.72	444.72	150.0
2023-09-07 04:41:00	SPY	ETF	444.75	444.75	444.75	444.75	150.0
2023-09-07 04:42:00	SPY	ETF	444.7	444.7	444.7	444.7	100.0
2023-09-07 04:44:00	SPY	ETF	444.72	444.72	444.72	444.72	303.0
2023-09-07 04:45:00	SPY	ETF	444.8	444.8	444.8	444.8	100.0
2023-09-07 04:51:00	SPY	ETF	445.0	445.0	445.0	445.0	500.0
2023-09-07 04:54:00	SPY	ETF	445.2	445.2	445.2	445.2	250.0
2023-09-07 04:55:00	SPY	ETF	445.17	445.21	445.17	445.21	2100.0
2023-09-07 04:56:00	SPY	ETF	445.15	445.21	445.15	445.19	311.0
2023-09-07 05:02:00	SPY	ETF	445.13	445.13	445.13	445.13	100.0
2023-09-07 05:09:00	SPY	ETF	445.39	445.39	445.39	445.39	500.0
2023-09-07 05:10:00	SPY	ETF	445.44	445.44	445.44	445.44	100.0
2023-09-07 05:11:00	SPY	ETF	445.33	445.38	445.33	445.38	200.0
2023-09-07 05:12:00	SPY	ETF	445.38	445.48	445.38	445.48	500.0
2023-09-07 05:13:00	SPY	ETF	445.48	445.5	445.48	445.5	500.0
2023-09-07 05:14:00	SPY	ETF	445.4	445.4	445.4	445.4	300.0
2023-09-07 05:15:00	SPY	ETF	445.5	445.5	445.5	445.5	400.0
2023-09-07 05:18:00	SPY	ETF	445.42	445.42	445.42	445.42	100.0
2023-09-07 05:21:00	SPY	ETF	445.46	445.5	445.46	445.5	300.0
2023-09-07 05:27:00	SPY	ETF	445.58	445.58	445.58	445.58	200.0
2023-09-07 05:28:00	SPY	ETF	445.49	445.49	445.49	445.49	500.0
2023-09-07 05:29:00	SPY	ETF	445.44	445.44	445.44	445.44	100.0
2023-09-07 05:30:00	SPY	ETF	445.57	445.57	445.57	445.57	100.0
2023-09-07 05:33:00	SPY	ETF	445.59	445.59	445.59	445.59	200.0

> showing 50 of 250,606 rows — these rows as CSV

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