PREVIEW / etf_5min / 2023-05-01

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-05-01.parquet
  size:    1.9 MB
  rows:    94,412

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-01 04:00:00	SPY	ETF	416.15	416.15	416.07	416.12	100743.0
2023-05-01 04:05:00	SPY	ETF	416.1	416.11	415.9	415.9	55601.0
2023-05-01 04:10:00	SPY	ETF	415.95	415.95	415.75	415.75	21500.0
2023-05-01 04:15:00	SPY	ETF	415.75	415.75	415.67	415.72	11306.0
2023-05-01 04:20:00	SPY	ETF	415.72	415.85	415.72	415.78	11331.0
2023-05-01 04:25:00	SPY	ETF	415.81	415.82	415.74	415.74	14439.0
2023-05-01 04:30:00	SPY	ETF	415.72	415.72	415.58	415.6	5540.0
2023-05-01 04:35:00	SPY	ETF	415.63	415.66	415.63	415.66	1155.0
2023-05-01 04:40:00	SPY	ETF	415.7	415.7	415.7	415.7	102.0
2023-05-01 04:45:00	SPY	ETF	415.71	415.79	415.71	415.78	765.0
2023-05-01 04:50:00	SPY	ETF	415.75	415.78	415.75	415.78	400.0
2023-05-01 04:55:00	SPY	ETF	415.79	415.79	415.7	415.7	600.0
2023-05-01 05:00:00	SPY	ETF	415.81	415.82	415.8	415.8	2100.0
2023-05-01 05:05:00	SPY	ETF	415.79	415.79	415.79	415.79	100.0
2023-05-01 05:10:00	SPY	ETF	415.8	415.92	415.8	415.92	702.0
2023-05-01 05:15:00	SPY	ETF	416.01	416.01	415.99	416.01	1323.0
2023-05-01 05:20:00	SPY	ETF	416.09	416.14	416.09	416.09	3220.0
2023-05-01 05:25:00	SPY	ETF	416.08	416.08	416.05	416.05	600.0
2023-05-01 05:30:00	SPY	ETF	416.06	416.06	416.06	416.06	100.0
2023-05-01 05:35:00	SPY	ETF	416.03	416.03	415.99	415.99	400.0
2023-05-01 05:40:00	SPY	ETF	415.97	415.98	415.97	415.98	409.0
2023-05-01 05:45:00	SPY	ETF	415.89	415.99	415.89	415.94	24801.0
2023-05-01 05:50:00	SPY	ETF	415.92	416.01	415.92	416.0	31399.0
2023-05-01 05:55:00	SPY	ETF	416.0	416.0	415.99	416.0	10119.0
2023-05-01 06:00:00	SPY	ETF	415.99	415.99	415.91	415.92	2609.0
2023-05-01 06:05:00	SPY	ETF	415.93	416.0	415.91	416.0	2002.0
2023-05-01 06:10:00	SPY	ETF	416.03	416.04	416.03	416.03	1398.0
2023-05-01 06:15:00	SPY	ETF	415.93	415.93	415.89	415.91	900.0
2023-05-01 06:20:00	SPY	ETF	415.89	415.89	415.83	415.83	2800.0
2023-05-01 06:25:00	SPY	ETF	415.88	415.88	415.84	415.84	3700.0
2023-05-01 06:30:00	SPY	ETF	415.86	415.87	415.78	415.78	1300.0
2023-05-01 06:35:00	SPY	ETF	415.82	415.82	415.82	415.82	500.0
2023-05-01 06:40:00	SPY	ETF	415.7	415.79	415.62	415.78	9344.0
2023-05-01 06:45:00	SPY	ETF	415.78	415.95	415.78	415.94	12568.0
2023-05-01 06:50:00	SPY	ETF	415.94	415.95	415.87	415.87	17900.0
2023-05-01 06:55:00	SPY	ETF	415.86	415.93	415.86	415.9	1729.0
2023-05-01 07:00:00	SPY	ETF	415.9	415.949	415.83	415.89	32687.0
2023-05-01 07:05:00	SPY	ETF	415.92	415.94	415.91	415.92	2427.0
2023-05-01 07:10:00	SPY	ETF	415.87	415.87	415.75	415.76	11742.0
2023-05-01 07:15:00	SPY	ETF	415.7	415.8	415.63	415.78	4663.0
2023-05-01 07:20:00	SPY	ETF	415.78	415.84	415.78	415.8	6301.0
2023-05-01 07:25:00	SPY	ETF	415.85	415.85	415.73	415.75	2686.0
2023-05-01 07:30:00	SPY	ETF	415.74	415.77	415.73	415.75	2734.0
2023-05-01 07:35:00	SPY	ETF	415.82	415.82	415.77	415.8	23725.0
2023-05-01 07:40:00	SPY	ETF	415.78	415.78	415.63	415.65	14169.0
2023-05-01 07:45:00	SPY	ETF	415.65	415.65	415.4	415.44	28457.0
2023-05-01 07:50:00	SPY	ETF	415.48	415.54	415.48	415.51	21650.0
2023-05-01 07:55:00	SPY	ETF	415.5	415.5	415.4	415.42	9858.0
2023-05-01 08:00:00	SPY	ETF	415.91	416.34	415.31	415.33	30259.0
2023-05-01 08:05:00	SPY	ETF	415.32	415.47	415.32	415.45	7650.0

> showing 50 of 94,412 rows — these rows as CSV

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