PREVIEW / etf_5min / 2023-07-18

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-18.parquet
  size:    2.1 MB
  rows:    99,927

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-07-18 04:00:00	SPY	ETF	450.52	450.88	450.52	450.87	3350.0
2023-07-18 04:05:00	SPY	ETF	450.9	450.98	450.88	450.91	2638.0
2023-07-18 04:10:00	SPY	ETF	450.89	450.92	450.89	450.9	600.0
2023-07-18 04:15:00	SPY	ETF	450.91	450.92	450.78	450.81	900.0
2023-07-18 04:20:00	SPY	ETF	450.84	450.84	450.83	450.83	1204.0
2023-07-18 04:25:00	SPY	ETF	450.88	450.92	450.88	450.92	1400.0
2023-07-18 04:30:00	SPY	ETF	450.91	451.02	450.91	450.97	2185.0
2023-07-18 04:35:00	SPY	ETF	450.97	450.97	450.84	450.84	1666.0
2023-07-18 04:40:00	SPY	ETF	450.84	450.87	450.8	450.8	1379.0
2023-07-18 04:45:00	SPY	ETF	450.75	450.75	450.7	450.7	1104.0
2023-07-18 04:50:00	SPY	ETF	450.5	450.55	450.5	450.55	2400.0
2023-07-18 04:55:00	SPY	ETF	450.63	450.65	450.63	450.65	310.0
2023-07-18 05:00:00	SPY	ETF	450.62	450.71	450.62	450.71	250.0
2023-07-18 05:05:00	SPY	ETF	450.73	450.73	450.69	450.73	477.0
2023-07-18 05:10:00	SPY	ETF	450.71	450.71	450.71	450.71	328.0
2023-07-18 05:15:00	SPY	ETF	450.69	450.79	450.69	450.79	603.0
2023-07-18 05:20:00	SPY	ETF	450.8	450.8	450.8	450.8	364.0
2023-07-18 05:25:00	SPY	ETF	450.75	450.75	450.75	450.75	100.0
2023-07-18 05:30:00	SPY	ETF	450.79	450.81	450.79	450.81	1000.0
2023-07-18 05:35:00	SPY	ETF	450.88	450.88	450.88	450.88	101.0
2023-07-18 05:40:00	SPY	ETF	450.99	451.01	450.99	451.01	1080.0
2023-07-18 05:45:00	SPY	ETF	450.9	450.9	450.9	450.9	299.0
2023-07-18 05:50:00	SPY	ETF	450.88	450.9	450.88	450.9	219.0
2023-07-18 06:00:00	SPY	ETF	450.94	451.01	450.94	450.99	310.0
2023-07-18 06:05:00	SPY	ETF	450.87	450.87	450.87	450.87	100.0
2023-07-18 06:10:00	SPY	ETF	450.84	450.87	450.83	450.83	400.0
2023-07-18 06:15:00	SPY	ETF	450.82	450.83	450.82	450.82	890.0
2023-07-18 06:20:00	SPY	ETF	450.83	450.83	450.79	450.79	1386.0
2023-07-18 06:25:00	SPY	ETF	450.78	450.78	450.72	450.72	600.0
2023-07-18 06:30:00	SPY	ETF	450.73	450.73	450.65	450.67	1842.0
2023-07-18 06:35:00	SPY	ETF	450.62	450.64	450.6	450.64	1213.0
2023-07-18 06:40:00	SPY	ETF	450.63	450.67	450.63	450.66	310.0
2023-07-18 06:45:00	SPY	ETF	450.71	450.71	450.71	450.71	100.0
2023-07-18 06:55:00	SPY	ETF	450.56	450.66	450.56	450.66	400.0
2023-07-18 07:00:00	SPY	ETF	450.61	450.73	450.58	450.7	5587.0
2023-07-18 07:05:00	SPY	ETF	450.73	450.73	450.65	450.65	1541.0
2023-07-18 07:10:00	SPY	ETF	450.59	450.64	450.59	450.6	1300.0
2023-07-18 07:15:00	SPY	ETF	450.62	450.74	450.62	450.71	1448.0
2023-07-18 07:20:00	SPY	ETF	450.71	450.71	450.65	450.65	800.0
2023-07-18 07:25:00	SPY	ETF	450.65	450.68	450.63	450.67	1460.0
2023-07-18 07:30:00	SPY	ETF	450.68	450.68	450.58	450.58	4505.0
2023-07-18 07:35:00	SPY	ETF	450.529	450.56	450.42	450.42	2780.0
2023-07-18 07:40:00	SPY	ETF	450.5	450.52	450.5	450.52	800.0
2023-07-18 07:45:00	SPY	ETF	450.57	450.58	450.54	450.56	1353.0
2023-07-18 07:50:00	SPY	ETF	450.54	450.58	450.52	450.57	992.0
2023-07-18 07:55:00	SPY	ETF	450.57	450.61	450.53	450.61	3148.0
2023-07-18 08:00:00	SPY	ETF	450.24	450.84	450.24	450.55	22828.0
2023-07-18 08:05:00	SPY	ETF	450.55	450.58	450.51	450.57	3303.0
2023-07-18 08:10:00	SPY	ETF	450.59	450.59	450.43	450.48	11461.0
2023-07-18 08:15:00	SPY	ETF	450.48	450.56	450.43	450.55	1901.0

> showing 50 of 99,927 rows — these rows as CSV

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