PREVIEW / etf_5min / 2024-01-09

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-01-09.parquet
  size:    2.2 MB
  rows:    107,296

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-01-09 04:00:00	SPY	ETF	473.88	473.91	473.4	473.44	7104.0
2024-01-09 04:05:00	SPY	ETF	473.44	473.44	473.23	473.23	1195.0
2024-01-09 04:10:00	SPY	ETF	473.22	473.27	472.89	472.91	4092.0
2024-01-09 04:15:00	SPY	ETF	473.02	473.04	472.99	473.03	1010.0
2024-01-09 04:20:00	SPY	ETF	473.0	473.0	472.92	472.99	1016.0
2024-01-09 04:25:00	SPY	ETF	473.01	473.1	473.01	473.1	999.0
2024-01-09 04:35:00	SPY	ETF	473.22	473.22	473.22	473.22	225.0
2024-01-09 04:40:00	SPY	ETF	473.24	473.24	473.24	473.24	105.0
2024-01-09 04:45:00	SPY	ETF	473.3	473.33	473.29	473.33	500.0
2024-01-09 04:50:00	SPY	ETF	473.45	473.5	473.4	473.4	1000.0
2024-01-09 04:55:00	SPY	ETF	473.35	473.35	473.35	473.35	300.0
2024-01-09 05:00:00	SPY	ETF	473.26	473.28	473.26	473.27	600.0
2024-01-09 05:05:00	SPY	ETF	473.31	473.31	473.25	473.25	500.0
2024-01-09 05:10:00	SPY	ETF	473.21	473.38	473.21	473.38	400.0
2024-01-09 05:15:00	SPY	ETF	473.35	473.39	473.33	473.33	800.0
2024-01-09 05:20:00	SPY	ETF	473.32	473.36	473.32	473.33	1400.0
2024-01-09 05:25:00	SPY	ETF	473.35	473.36	473.35	473.36	500.0
2024-01-09 05:30:00	SPY	ETF	473.27	473.35	473.27	473.35	1732.0
2024-01-09 05:35:00	SPY	ETF	473.32	473.34	473.28	473.34	1100.0
2024-01-09 05:40:00	SPY	ETF	473.29	473.29	473.21	473.21	2122.0
2024-01-09 05:45:00	SPY	ETF	473.14	473.14	473.04	473.1	8600.0
2024-01-09 05:50:00	SPY	ETF	473.2	473.2	473.17	473.17	700.0
2024-01-09 05:55:00	SPY	ETF	473.14	473.14	473.14	473.14	684.0
2024-01-09 06:00:00	SPY	ETF	473.22	473.26	473.19	473.19	708.0
2024-01-09 06:05:00	SPY	ETF	473.05	473.05	472.93	472.93	1600.0
2024-01-09 06:10:00	SPY	ETF	472.9	472.9	472.81	472.84	1489.0
2024-01-09 06:15:00	SPY	ETF	472.9	472.99	472.82	472.82	2657.0
2024-01-09 06:20:00	SPY	ETF	472.82	472.87	472.81	472.87	1600.0
2024-01-09 06:25:00	SPY	ETF	472.88	472.88	472.79	472.81	906.0
2024-01-09 06:30:00	SPY	ETF	472.79	472.9	472.71	472.9	2165.0
2024-01-09 06:35:00	SPY	ETF	472.91	472.91	472.8	472.8	500.0
2024-01-09 06:40:00	SPY	ETF	472.68	472.75	472.65	472.69	5811.0
2024-01-09 06:45:00	SPY	ETF	472.67	472.69	472.66	472.69	705.0
2024-01-09 06:50:00	SPY	ETF	472.68	472.68	472.42	472.43	11750.0
2024-01-09 06:55:00	SPY	ETF	472.4	472.42	472.31	472.42	17936.0
2024-01-09 07:00:00	SPY	ETF	472.44	472.45	472.24	472.42	96909.0
2024-01-09 07:05:00	SPY	ETF	472.41	472.59	472.4	472.571	28344.0
2024-01-09 07:10:00	SPY	ETF	472.56	472.75	472.56	472.75	3871.0
2024-01-09 07:15:00	SPY	ETF	472.75	472.84	472.69	472.82	7240.0
2024-01-09 07:20:00	SPY	ETF	472.82	472.82	472.7	472.7	9624.0
2024-01-09 07:25:00	SPY	ETF	472.78	472.9	472.78	472.79	28601.0
2024-01-09 07:30:00	SPY	ETF	472.73	472.97	472.68	472.92	10979.0
2024-01-09 07:35:00	SPY	ETF	472.92	473.0	472.84	472.91	4935.0
2024-01-09 07:40:00	SPY	ETF	472.96	472.96	472.85	472.85	20140.0
2024-01-09 07:45:00	SPY	ETF	472.85	472.97	472.85	472.94	4208.0
2024-01-09 07:50:00	SPY	ETF	472.91	473.03	472.85	473.0	51879.0
2024-01-09 07:55:00	SPY	ETF	473.02	473.06	472.94	472.98	16214.0
2024-01-09 08:00:00	SPY	ETF	472.54	474.21	472.3196	472.67	68147.0
2024-01-09 08:05:00	SPY	ETF	472.66	472.78	472.65	472.71	13605.0
2024-01-09 08:10:00	SPY	ETF	472.79	472.92	472.72	472.89	24942.0

> showing 50 of 107,296 rows — these rows as CSV

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