PREVIEW / etf_5min / 2024-04-16

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-04-16.parquet
  size:    2.3 MB
  rows:    117,364

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
2024-04-16 04:00:00	SPY	ETF	504.4	504.53	504.19	504.53	16734.0
2024-04-16 04:05:00	SPY	ETF	504.19	504.34	504.15	504.34	644.0
2024-04-16 04:10:00	SPY	ETF	504.46	504.54	504.46	504.54	2816.0
2024-04-16 04:15:00	SPY	ETF	504.37	504.46	504.28	504.29	3716.0
2024-04-16 04:20:00	SPY	ETF	504.21	504.25	504.13	504.15	1751.0
2024-04-16 04:25:00	SPY	ETF	504.07	504.3	504.07	504.29	2100.0
2024-04-16 04:30:00	SPY	ETF	504.37	504.37	504.36	504.36	1152.0
2024-04-16 04:35:00	SPY	ETF	504.39	504.39	504.38	504.38	800.0
2024-04-16 04:40:00	SPY	ETF	504.2	504.2	504.08	504.08	1500.0
2024-04-16 04:45:00	SPY	ETF	504.04	504.28	504.04	504.28	1256.0
2024-04-16 04:50:00	SPY	ETF	504.13	504.18	504.09	504.18	3974.0
2024-04-16 04:55:00	SPY	ETF	504.45	504.51	504.45	504.51	1505.0
2024-04-16 05:00:00	SPY	ETF	504.3	504.35	504.2	504.35	2025.0
2024-04-16 05:05:00	SPY	ETF	504.45	504.49	504.45	504.49	700.0
2024-04-16 05:10:00	SPY	ETF	504.2	504.35	504.2	504.33	1000.0
2024-04-16 05:15:00	SPY	ETF	504.14	504.33	504.14	504.25	525.0
2024-04-16 05:20:00	SPY	ETF	504.25	504.25	503.71	503.71	2120.0
2024-04-16 05:25:00	SPY	ETF	503.73	504.28	503.73	504.08	1375.0
2024-04-16 05:30:00	SPY	ETF	504.23	504.23	503.61	503.61	1800.0
2024-04-16 05:35:00	SPY	ETF	503.77	503.84	503.77	503.84	700.0
2024-04-16 05:40:00	SPY	ETF	503.84	503.84	503.84	503.84	450.0
2024-04-16 05:45:00	SPY	ETF	503.89	503.89	503.89	503.89	2000.0
2024-04-16 05:50:00	SPY	ETF	503.72	503.72	503.24	503.63	7252.0
2024-04-16 05:55:00	SPY	ETF	503.52	504.0	503.52	503.8	9209.0
2024-04-16 06:00:00	SPY	ETF	503.87	503.87	503.74	503.77	700.0
2024-04-16 06:05:00	SPY	ETF	503.77	503.77	503.48	503.48	700.0
2024-04-16 06:10:00	SPY	ETF	503.39	503.56	503.28	503.55	1555.0
2024-04-16 06:15:00	SPY	ETF	503.6	503.6	503.56	503.6	676.0
2024-04-16 06:20:00	SPY	ETF	503.51	503.51	503.17	503.36	2283.0
2024-04-16 06:25:00	SPY	ETF	503.25	503.46	503.1	503.38	7370.0
2024-04-16 06:30:00	SPY	ETF	503.4	504.01	503.2	504.01	53637.0
2024-04-16 06:35:00	SPY	ETF	504.02	504.21	504.01	504.2	3904.0
2024-04-16 06:40:00	SPY	ETF	504.12	504.32	504.0	504.32	7382.0
2024-04-16 06:45:00	SPY	ETF	504.35	504.48	504.35	504.36	4900.0
2024-04-16 06:50:00	SPY	ETF	504.4	504.45	504.21	504.21	14364.0
2024-04-16 06:55:00	SPY	ETF	504.27	504.43	504.27	504.43	2864.0
2024-04-16 07:00:00	SPY	ETF	504.45	504.85	504.36	504.829	14232.0
2024-04-16 07:05:00	SPY	ETF	504.86	505.01	504.83	504.9	83019.0
2024-04-16 07:10:00	SPY	ETF	504.93	505.2	504.88	505.2	32392.0
2024-04-16 07:15:00	SPY	ETF	505.25	505.31	505.11	505.11	9064.0
2024-04-16 07:20:00	SPY	ETF	505.1	505.13	504.8	505.1	53779.0
2024-04-16 07:25:00	SPY	ETF	505.24	505.39	505.02	505.04	36954.0
2024-04-16 07:30:00	SPY	ETF	505.04	505.59	505.03	505.49	33851.0
2024-04-16 07:35:00	SPY	ETF	505.42	505.93	505.42	505.58	80067.0
2024-04-16 07:40:00	SPY	ETF	505.56	505.59	505.33	505.44	22907.0
2024-04-16 07:45:00	SPY	ETF	505.4	506.13	505.4	506.03	85511.0
2024-04-16 07:50:00	SPY	ETF	505.99	506.24	505.92	506.15	66465.0
2024-04-16 07:55:00	SPY	ETF	506.16	506.24	506.02	506.03	39671.0
2024-04-16 08:00:00	SPY	ETF	506.02	506.1682	503.4	505.63	82649.0
2024-04-16 08:05:00	SPY	ETF	505.63	505.63	503.45	505.42	78568.0

> showing 50 of 117,364 rows — these rows as CSV

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