PREVIEW / etf_5min / 2023-11-06

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-11-06.parquet
  size:    2.1 MB
  rows:    102,217

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-06 04:00:00	SPY	ETF	435.02	435.49	435.02	435.38	37520.0
2023-11-06 04:05:00	SPY	ETF	435.37	435.47	435.28	435.33	22413.0
2023-11-06 04:10:00	SPY	ETF	435.4	435.57	435.4	435.57	3473.0
2023-11-06 04:15:00	SPY	ETF	435.56	435.56	435.54	435.54	486.0
2023-11-06 04:20:00	SPY	ETF	435.34	435.43	435.28	435.43	1283.0
2023-11-06 04:25:00	SPY	ETF	435.47	435.47	435.46	435.46	331.0
2023-11-06 04:30:00	SPY	ETF	435.5	435.5	435.42	435.42	823.0
2023-11-06 04:35:00	SPY	ETF	435.3	435.37	435.3	435.37	323.0
2023-11-06 04:40:00	SPY	ETF	435.4	435.65	435.4	435.65	3143.0
2023-11-06 04:45:00	SPY	ETF	435.64	435.64	435.55	435.55	1406.0
2023-11-06 04:50:00	SPY	ETF	435.67	435.67	435.67	435.67	100.0
2023-11-06 04:55:00	SPY	ETF	435.56	435.56	435.56	435.56	400.0
2023-11-06 05:00:00	SPY	ETF	435.74	435.75	435.72	435.72	1000.0
2023-11-06 05:05:00	SPY	ETF	435.66	435.77	435.66	435.77	897.0
2023-11-06 05:10:00	SPY	ETF	435.75	435.75	435.64	435.7	1459.0
2023-11-06 05:15:00	SPY	ETF	435.7	435.74	435.68	435.69	1301.0
2023-11-06 05:20:00	SPY	ETF	435.68	435.68	435.62	435.62	300.0
2023-11-06 05:25:00	SPY	ETF	435.68	435.68	435.64	435.66	2599.0
2023-11-06 05:30:00	SPY	ETF	435.58	435.6	435.58	435.6	317.0
2023-11-06 05:35:00	SPY	ETF	435.51	435.51	435.51	435.51	160.0
2023-11-06 05:40:00	SPY	ETF	435.56	435.56	435.56	435.56	300.0
2023-11-06 05:45:00	SPY	ETF	435.5	435.5	435.49	435.49	2300.0
2023-11-06 05:50:00	SPY	ETF	435.44	435.44	435.44	435.44	200.0
2023-11-06 05:55:00	SPY	ETF	435.47	435.6	435.47	435.6	1794.0
2023-11-06 06:00:00	SPY	ETF	435.56	435.56	435.55	435.55	1200.0
2023-11-06 06:05:00	SPY	ETF	435.47	435.59	435.47	435.59	531.0
2023-11-06 06:10:00	SPY	ETF	435.65	435.66	435.61	435.61	1161.0
2023-11-06 06:15:00	SPY	ETF	435.61	435.61	435.61	435.61	100.0
2023-11-06 06:20:00	SPY	ETF	435.63	435.63	435.61	435.61	622.0
2023-11-06 06:25:00	SPY	ETF	435.6	435.6	435.53	435.53	1896.0
2023-11-06 06:30:00	SPY	ETF	435.55	435.65	435.55	435.63	600.0
2023-11-06 06:35:00	SPY	ETF	435.72	435.75	435.7	435.75	2086.0
2023-11-06 06:40:00	SPY	ETF	435.75	435.91	435.71	435.88	8256.0
2023-11-06 06:45:00	SPY	ETF	435.85	435.85	435.82	435.83	6598.0
2023-11-06 06:50:00	SPY	ETF	435.86	435.86	435.7	435.7	10862.0
2023-11-06 06:55:00	SPY	ETF	435.75	435.77	435.66	435.66	2595.0
2023-11-06 07:00:00	SPY	ETF	435.66	435.7	435.56	435.59	4745.0
2023-11-06 07:05:00	SPY	ETF	435.61	435.63	435.47	435.55	8212.0
2023-11-06 07:10:00	SPY	ETF	435.61	435.65	435.42	435.451	10318.0
2023-11-06 07:15:00	SPY	ETF	435.48	435.51	435.43	435.48	2787.0
2023-11-06 07:20:00	SPY	ETF	435.46	435.5	435.29	435.42	29858.0
2023-11-06 07:25:00	SPY	ETF	435.46	435.5	435.37	435.42	8879.0
2023-11-06 07:30:00	SPY	ETF	435.43	435.52	435.33	435.49	5626.0
2023-11-06 07:35:00	SPY	ETF	435.56	435.671	435.56	435.671	5700.0
2023-11-06 07:40:00	SPY	ETF	435.72	435.72	435.65	435.65	2874.0
2023-11-06 07:45:00	SPY	ETF	435.67	435.7	435.63	435.63	4802.0
2023-11-06 07:50:00	SPY	ETF	435.63	435.63	435.41	435.47	17166.0
2023-11-06 07:55:00	SPY	ETF	435.44	435.54	435.3	435.54	12162.0
2023-11-06 08:00:00	SPY	ETF	435.53	435.8596	434.96	435.4697	43525.0
2023-11-06 08:05:00	SPY	ETF	435.44	435.4402	435.26	435.4	20350.0

> showing 50 of 102,217 rows — these rows as CSV

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