PREVIEW / etf_5min / 2022-08-01

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-08-01.parquet
  size:    1.9 MB
  rows:    93,489

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
2022-08-01 04:00:00	SPY	ETF	411.19	411.21	411.07	411.1	3735.0
2022-08-01 04:05:00	SPY	ETF	411.22	411.22	411.08	411.14	1218.0
2022-08-01 04:10:00	SPY	ETF	411.25	411.42	411.01	411.01	4380.0
2022-08-01 04:15:00	SPY	ETF	411.02	411.2	411.01	411.2	2200.0
2022-08-01 04:20:00	SPY	ETF	411.0	411.0	411.0	411.0	500.0
2022-08-01 04:25:00	SPY	ETF	410.96	410.96	410.89	410.91	596.0
2022-08-01 04:30:00	SPY	ETF	410.93	410.93	410.93	410.93	107.0
2022-08-01 04:35:00	SPY	ETF	410.88	410.91	410.88	410.91	400.0
2022-08-01 04:40:00	SPY	ETF	410.95	410.96	410.82	410.82	1349.0
2022-08-01 04:45:00	SPY	ETF	410.72	410.72	410.71	410.71	1000.0
2022-08-01 04:50:00	SPY	ETF	410.5	410.57	410.45	410.57	467.0
2022-08-01 04:55:00	SPY	ETF	410.49	410.58	410.49	410.58	1050.0
2022-08-01 05:05:00	SPY	ETF	410.66	410.66	410.66	410.66	100.0
2022-08-01 05:10:00	SPY	ETF	410.78	410.78	410.78	410.78	500.0
2022-08-01 05:15:00	SPY	ETF	410.91	410.91	410.86	410.86	899.0
2022-08-01 05:20:00	SPY	ETF	410.9	410.9	410.9	410.9	350.0
2022-08-01 05:25:00	SPY	ETF	411.0	411.0	410.9	410.91	1190.0
2022-08-01 05:30:00	SPY	ETF	410.89	411.26	410.89	411.26	2689.0
2022-08-01 05:35:00	SPY	ETF	411.15	411.15	411.15	411.15	100.0
2022-08-01 05:40:00	SPY	ETF	411.21	411.21	411.21	411.21	300.0
2022-08-01 05:45:00	SPY	ETF	411.2	411.2	411.19	411.19	200.0
2022-08-01 05:50:00	SPY	ETF	411.36	411.36	411.29	411.29	754.0
2022-08-01 05:55:00	SPY	ETF	411.23	411.29	411.2	411.21	1500.0
2022-08-01 06:00:00	SPY	ETF	411.16	411.29	411.16	411.29	2300.0
2022-08-01 06:05:00	SPY	ETF	411.4	411.43	411.27	411.27	1490.0
2022-08-01 06:10:00	SPY	ETF	411.2	411.2	411.12	411.17	3336.0
2022-08-01 06:15:00	SPY	ETF	411.16	411.27	411.16	411.27	3200.0
2022-08-01 06:20:00	SPY	ETF	411.11	411.11	411.11	411.11	300.0
2022-08-01 06:25:00	SPY	ETF	411.14	411.21	411.14	411.21	805.0
2022-08-01 06:30:00	SPY	ETF	411.21	411.21	411.11	411.11	1107.0
2022-08-01 06:35:00	SPY	ETF	411.25	411.26	411.2	411.22	5650.0
2022-08-01 06:40:00	SPY	ETF	411.17	411.18	411.12	411.18	2291.0
2022-08-01 06:45:00	SPY	ETF	411.2	411.2	411.03	411.03	6068.0
2022-08-01 06:50:00	SPY	ETF	411.07	411.09	411.06	411.06	895.0
2022-08-01 06:55:00	SPY	ETF	411.15	411.17	411.15	411.17	500.0
2022-08-01 07:00:00	SPY	ETF	411.16	411.3	411.16	411.21	11656.0
2022-08-01 07:05:00	SPY	ETF	411.29	411.36	411.23	411.23	8142.0
2022-08-01 07:10:00	SPY	ETF	411.26	411.52	411.25	411.51	1815.0
2022-08-01 07:15:00	SPY	ETF	411.47	411.52	411.35	411.46	9976.0
2022-08-01 07:20:00	SPY	ETF	411.45	411.61	411.41	411.42	14015.0
2022-08-01 07:25:00	SPY	ETF	411.45	411.57	411.43	411.51	3318.0
2022-08-01 07:30:00	SPY	ETF	411.46	411.46	411.39	411.39	1469.0
2022-08-01 07:35:00	SPY	ETF	411.37	411.44	411.37	411.44	1643.0
2022-08-01 07:40:00	SPY	ETF	411.47	411.84	411.45	411.72	9848.0
2022-08-01 07:45:00	SPY	ETF	411.73	412.06	411.73	411.87	21036.0
2022-08-01 07:50:00	SPY	ETF	411.83	411.84	411.67	411.67	3573.0
2022-08-01 07:55:00	SPY	ETF	411.55	411.59	411.48	411.5	32245.0
2022-08-01 08:00:00	SPY	ETF	411.5	411.985	410.42	411.25	39921.0
2022-08-01 08:05:00	SPY	ETF	411.26	411.26	410.53	410.98	104075.0
2022-08-01 08:10:00	SPY	ETF	411.0	411.01	410.8	410.86	20095.0

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

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