PREVIEW / etf_5min / 2023-05-05

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-05-05.parquet
  size:    1.9 MB
  rows:    93,134

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-05-05 04:00:00	SPY	ETF	406.48	406.62	406.25	406.6	3300.0
2023-05-05 04:05:00	SPY	ETF	406.61	406.67	406.6	406.6	10873.0
2023-05-05 04:10:00	SPY	ETF	406.52	406.52	406.52	406.52	142.0
2023-05-05 04:15:00	SPY	ETF	406.56	406.6	406.4	406.4	800.0
2023-05-05 04:20:00	SPY	ETF	406.4	406.4	406.25	406.25	4764.0
2023-05-05 04:25:00	SPY	ETF	406.36	406.49	406.36	406.49	700.0
2023-05-05 04:30:00	SPY	ETF	406.46	406.59	406.43	406.43	1213.0
2023-05-05 04:35:00	SPY	ETF	406.48	406.49	406.4	406.4	1703.0
2023-05-05 04:40:00	SPY	ETF	406.44	406.51	406.44	406.51	750.0
2023-05-05 04:45:00	SPY	ETF	406.67	406.72	406.67	406.72	600.0
2023-05-05 04:50:00	SPY	ETF	407.0	407.11	407.0	407.11	2451.0
2023-05-05 04:55:00	SPY	ETF	407.08	407.08	407.05	407.05	1500.0
2023-05-05 05:00:00	SPY	ETF	407.02	407.02	406.86	406.86	324.0
2023-05-05 05:05:00	SPY	ETF	406.8	406.82	406.8	406.82	1300.0
2023-05-05 05:10:00	SPY	ETF	407.0	407.01	406.92	406.92	6500.0
2023-05-05 05:15:00	SPY	ETF	406.76	406.8	406.76	406.8	550.0
2023-05-05 05:20:00	SPY	ETF	406.89	406.89	406.88	406.88	200.0
2023-05-05 05:25:00	SPY	ETF	406.92	406.97	406.92	406.97	896.0
2023-05-05 05:30:00	SPY	ETF	406.96	406.97	406.92	406.92	1400.0
2023-05-05 05:35:00	SPY	ETF	406.96	406.96	406.96	406.96	200.0
2023-05-05 05:40:00	SPY	ETF	406.99	407.12	406.99	407.12	1076.0
2023-05-05 05:45:00	SPY	ETF	407.11	407.17	407.11	407.17	6240.0
2023-05-05 05:50:00	SPY	ETF	407.22	407.26	407.17	407.22	12283.0
2023-05-05 05:55:00	SPY	ETF	407.15	407.15	407.15	407.15	300.0
2023-05-05 06:00:00	SPY	ETF	407.22	407.26	407.22	407.26	300.0
2023-05-05 06:05:00	SPY	ETF	407.3	407.31	407.25	407.28	3697.0
2023-05-05 06:10:00	SPY	ETF	407.33	407.38	407.33	407.37	2711.0
2023-05-05 06:15:00	SPY	ETF	407.39	407.5	407.39	407.46	11882.0
2023-05-05 06:20:00	SPY	ETF	407.35	407.5	407.35	407.5	3951.0
2023-05-05 06:25:00	SPY	ETF	407.45	407.45	407.37	407.45	10600.0
2023-05-05 06:30:00	SPY	ETF	407.49	407.49	407.41	407.45	2100.0
2023-05-05 06:35:00	SPY	ETF	407.48	407.62	407.45	407.62	1700.0
2023-05-05 06:40:00	SPY	ETF	407.66	407.75	407.57	407.63	6940.0
2023-05-05 06:45:00	SPY	ETF	407.58	407.7	407.53	407.7	3860.0
2023-05-05 06:50:00	SPY	ETF	407.7	407.7	407.37	407.37	2350.0
2023-05-05 06:55:00	SPY	ETF	407.4	407.5	407.39	407.5	12290.0
2023-05-05 07:00:00	SPY	ETF	407.55	407.65	407.47	407.61	31828.0
2023-05-05 07:05:00	SPY	ETF	407.59	407.63	407.58	407.62	6948.0
2023-05-05 07:10:00	SPY	ETF	407.63	407.77	407.6	407.74	18774.0
2023-05-05 07:15:00	SPY	ETF	407.72	407.85	407.7	407.84	10241.0
2023-05-05 07:20:00	SPY	ETF	407.84	407.89	407.84	407.87	4348.0
2023-05-05 07:25:00	SPY	ETF	407.89	408.12	407.89	408.12	10111.0
2023-05-05 07:30:00	SPY	ETF	408.111	408.22	408.03	408.05	15278.0
2023-05-05 07:35:00	SPY	ETF	408.0	408.0	407.92	407.93	26789.0
2023-05-05 07:40:00	SPY	ETF	407.82	407.87	407.74	407.8	8861.0
2023-05-05 07:45:00	SPY	ETF	407.81	407.81	407.66	407.66	33841.0
2023-05-05 07:50:00	SPY	ETF	407.65	407.9	407.65	407.84	14771.0
2023-05-05 07:55:00	SPY	ETF	407.86	408.02	407.86	407.98	7097.0
2023-05-05 08:00:00	SPY	ETF	407.58	408.24	406.54	408.11	63114.0
2023-05-05 08:05:00	SPY	ETF	408.04	408.08	407.9	408.02	22460.0

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

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