PREVIEW / etf_5min / 2023-04-18

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-04-18.parquet
  size:    1.9 MB
  rows:    94,311

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-04-18 04:00:00	SPY	ETF	414.2	414.27	414.2	414.27	620.0
2023-04-18 04:05:00	SPY	ETF	414.25	414.6	414.25	414.41	11979.0
2023-04-18 04:10:00	SPY	ETF	414.43	414.45	414.43	414.45	2000.0
2023-04-18 04:15:00	SPY	ETF	414.45	414.5	414.42	414.45	1848.0
2023-04-18 04:20:00	SPY	ETF	414.45	414.45	414.35	414.35	1379.0
2023-04-18 04:25:00	SPY	ETF	414.37	414.37	414.37	414.37	300.0
2023-04-18 04:30:00	SPY	ETF	414.57	414.57	414.53	414.53	633.0
2023-04-18 04:35:00	SPY	ETF	414.6	414.73	414.57	414.73	1100.0
2023-04-18 04:40:00	SPY	ETF	414.78	415.0	414.78	414.87	3709.0
2023-04-18 04:45:00	SPY	ETF	414.88	414.89	414.84	414.84	1325.0
2023-04-18 04:50:00	SPY	ETF	414.93	414.98	414.91	414.91	1401.0
2023-04-18 04:55:00	SPY	ETF	414.83	414.83	414.83	414.83	400.0
2023-04-18 05:00:00	SPY	ETF	414.73	414.83	414.73	414.77	6984.0
2023-04-18 05:05:00	SPY	ETF	414.79	414.79	414.79	414.79	302.0
2023-04-18 05:10:00	SPY	ETF	414.85	414.85	414.83	414.83	1493.0
2023-04-18 05:15:00	SPY	ETF	414.86	414.89	414.86	414.89	384.0
2023-04-18 05:20:00	SPY	ETF	415.02	415.26	415.02	415.19	5202.0
2023-04-18 05:25:00	SPY	ETF	415.16	415.17	415.09	415.1	2036.0
2023-04-18 05:30:00	SPY	ETF	415.11	415.31	415.11	415.31	715.0
2023-04-18 05:35:00	SPY	ETF	415.38	415.44	415.34	415.41	5631.0
2023-04-18 05:40:00	SPY	ETF	415.48	415.57	415.39	415.42	2689.0
2023-04-18 05:45:00	SPY	ETF	415.45	415.45	415.33	415.33	2309.0
2023-04-18 05:50:00	SPY	ETF	415.34	415.46	415.33	415.46	2441.0
2023-04-18 05:55:00	SPY	ETF	415.46	415.46	415.37	415.37	300.0
2023-04-18 06:00:00	SPY	ETF	415.33	415.43	415.33	415.43	225.0
2023-04-18 06:05:00	SPY	ETF	415.3	415.3	415.25	415.25	1100.0
2023-04-18 06:10:00	SPY	ETF	415.34	415.34	415.34	415.34	110.0
2023-04-18 06:15:00	SPY	ETF	415.28	415.28	415.28	415.28	168.0
2023-04-18 06:20:00	SPY	ETF	415.38	415.38	415.36	415.36	1170.0
2023-04-18 06:25:00	SPY	ETF	415.31	415.39	415.3	415.39	4401.0
2023-04-18 06:30:00	SPY	ETF	415.5	415.6	415.5	415.6	7375.0
2023-04-18 06:35:00	SPY	ETF	415.56	415.58	415.51	415.55	3288.0
2023-04-18 06:40:00	SPY	ETF	415.55	415.67	415.55	415.67	7031.0
2023-04-18 06:45:00	SPY	ETF	415.7	415.85	415.6	415.8	14146.0
2023-04-18 06:50:00	SPY	ETF	415.82	415.84	415.74	415.74	8194.0
2023-04-18 06:55:00	SPY	ETF	415.75	415.79	415.71	415.75	4243.0
2023-04-18 07:00:00	SPY	ETF	415.77	415.78	415.22	415.55	40331.0
2023-04-18 07:05:00	SPY	ETF	415.58	415.7	415.58	415.66	3483.0
2023-04-18 07:10:00	SPY	ETF	415.69	415.73	415.62	415.71	2540.0
2023-04-18 07:15:00	SPY	ETF	415.72	415.72	415.6	415.63	83309.0
2023-04-18 07:20:00	SPY	ETF	415.62	415.74	415.6	415.64	27170.0
2023-04-18 07:25:00	SPY	ETF	415.64	415.69	415.46	415.46	13116.0
2023-04-18 07:30:00	SPY	ETF	415.51	415.81	415.5	415.76	22044.0
2023-04-18 07:35:00	SPY	ETF	415.72	415.73	415.51	415.62	26750.0
2023-04-18 07:40:00	SPY	ETF	415.61	415.67	415.55	415.62	5214.0
2023-04-18 07:45:00	SPY	ETF	415.61	415.61	415.45	415.5	28467.0
2023-04-18 07:50:00	SPY	ETF	415.47	415.47	415.42	415.47	16611.0
2023-04-18 07:55:00	SPY	ETF	415.47	415.52	415.42	415.52	8067.0
2023-04-18 08:00:00	SPY	ETF	415.72	415.8	413.68	415.65	48917.0
2023-04-18 08:05:00	SPY	ETF	415.63	415.71	415.6	415.67	12119.0

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

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