PREVIEW / etf_5min / 2023-03-07

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-03-07.parquet
  size:    1.9 MB
  rows:    93,822

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-03-07 04:00:00	SPY	ETF	405.33	405.5	405.33	405.49	1462.0
2023-03-07 04:05:00	SPY	ETF	405.52	405.73	405.41	405.6	2418.0
2023-03-07 04:10:00	SPY	ETF	405.63	405.65	405.5	405.58	2163.0
2023-03-07 04:15:00	SPY	ETF	405.53	405.63	405.53	405.63	300.0
2023-03-07 04:20:00	SPY	ETF	405.58	405.58	405.58	405.58	100.0
2023-03-07 04:25:00	SPY	ETF	405.5	405.59	405.48	405.48	780.0
2023-03-07 04:30:00	SPY	ETF	405.47	405.53	405.47	405.48	1350.0
2023-03-07 04:35:00	SPY	ETF	405.4	405.44	405.4	405.44	749.0
2023-03-07 04:40:00	SPY	ETF	405.45	405.45	405.45	405.45	100.0
2023-03-07 04:45:00	SPY	ETF	405.43	405.43	405.31	405.31	1481.0
2023-03-07 04:50:00	SPY	ETF	405.26	405.26	405.23	405.23	1500.0
2023-03-07 04:55:00	SPY	ETF	405.1	405.11	405.1	405.1	1580.0
2023-03-07 05:00:00	SPY	ETF	405.11	405.24	405.11	405.24	844.0
2023-03-07 05:05:00	SPY	ETF	405.1	405.29	405.09	405.28	1485.0
2023-03-07 05:10:00	SPY	ETF	405.24	405.24	405.24	405.24	200.0
2023-03-07 05:15:00	SPY	ETF	405.28	405.28	405.28	405.28	500.0
2023-03-07 05:20:00	SPY	ETF	405.36	405.36	405.36	405.36	800.0
2023-03-07 05:25:00	SPY	ETF	405.3	405.3	405.19	405.21	2590.0
2023-03-07 05:30:00	SPY	ETF	405.23	405.23	405.23	405.23	200.0
2023-03-07 05:35:00	SPY	ETF	405.28	405.32	405.28	405.32	650.0
2023-03-07 05:40:00	SPY	ETF	405.38	405.38	405.34	405.34	850.0
2023-03-07 05:45:00	SPY	ETF	405.3	405.3	405.3	405.3	300.0
2023-03-07 05:50:00	SPY	ETF	405.19	405.2	405.16	405.16	1066.0
2023-03-07 05:55:00	SPY	ETF	405.26	405.35	405.23	405.35	1049.0
2023-03-07 06:00:00	SPY	ETF	405.42	405.53	405.35	405.35	3320.0
2023-03-07 06:05:00	SPY	ETF	405.36	405.36	405.34	405.35	2800.0
2023-03-07 06:10:00	SPY	ETF	405.35	405.45	405.35	405.45	11232.0
2023-03-07 06:15:00	SPY	ETF	405.38	405.38	405.32	405.36	1300.0
2023-03-07 06:20:00	SPY	ETF	405.3	405.3	405.07	405.12	1250.0
2023-03-07 06:25:00	SPY	ETF	405.12	405.12	405.12	405.12	200.0
2023-03-07 06:30:00	SPY	ETF	405.16	405.3	405.16	405.3	1000.0
2023-03-07 06:35:00	SPY	ETF	405.31	405.31	405.2	405.2	800.0
2023-03-07 06:40:00	SPY	ETF	405.28	405.28	405.18	405.21	11250.0
2023-03-07 06:45:00	SPY	ETF	405.11	405.14	405.07	405.08	1109.0
2023-03-07 06:50:00	SPY	ETF	405.14	405.14	405.14	405.14	100.0
2023-03-07 06:55:00	SPY	ETF	405.05	405.05	404.97	405.03	1735.0
2023-03-07 07:00:00	SPY	ETF	405.0	405.07	404.95	404.95	6088.0
2023-03-07 07:05:00	SPY	ETF	404.96	405.02	404.96	405.02	749.0
2023-03-07 07:10:00	SPY	ETF	405.001	405.001	404.98	404.99	900.0
2023-03-07 07:15:00	SPY	ETF	405.05	405.05	404.99	405.02	3295.0
2023-03-07 07:20:00	SPY	ETF	405.05	405.05	404.8	404.8	2288.0
2023-03-07 07:25:00	SPY	ETF	404.8	404.82	404.75	404.75	52319.0
2023-03-07 07:30:00	SPY	ETF	404.76	404.84	404.75	404.8	4143.0
2023-03-07 07:35:00	SPY	ETF	404.81	404.9	404.81	404.9	2700.0
2023-03-07 07:40:00	SPY	ETF	404.93	405.05	404.93	404.93	10894.0
2023-03-07 07:45:00	SPY	ETF	404.96	404.96	404.81	404.9	3523.0
2023-03-07 07:50:00	SPY	ETF	404.92	405.04	404.92	405.03	12639.0
2023-03-07 07:55:00	SPY	ETF	405.03	405.05	404.97	404.97	13479.0
2023-03-07 08:00:00	SPY	ETF	404.9813	405.6296	404.77	405.12	44374.0
2023-03-07 08:05:00	SPY	ETF	405.13	405.28	405.11	405.15	16929.0

> showing 50 of 93,822 rows — these rows as CSV

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