PREVIEW / etf_5min / 2023-06-06

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-06.parquet
  size:    2.0 MB
  rows:    96,161

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-06-06 04:00:00	SPY	ETF	427.02	427.48	427.02	427.48	1805.0
2023-06-06 04:05:00	SPY	ETF	427.46	427.52	427.46	427.48	516.0
2023-06-06 04:10:00	SPY	ETF	427.17	427.21	427.03	427.21	1616.0
2023-06-06 04:15:00	SPY	ETF	427.17	427.3	427.14	427.28	5004.0
2023-06-06 04:20:00	SPY	ETF	427.23	427.23	427.14	427.16	925.0
2023-06-06 04:25:00	SPY	ETF	427.1	427.1	426.97	426.97	1673.0
2023-06-06 04:30:00	SPY	ETF	426.79	426.94	426.79	426.83	10099.0
2023-06-06 04:35:00	SPY	ETF	426.9	427.03	426.9	426.94	812.0
2023-06-06 04:40:00	SPY	ETF	427.01	427.06	427.0	427.06	1850.0
2023-06-06 04:45:00	SPY	ETF	427.0	427.0	426.91	426.91	364.0
2023-06-06 04:50:00	SPY	ETF	426.82	426.87	426.8	426.8	880.0
2023-06-06 04:55:00	SPY	ETF	426.71	426.76	426.64	426.76	1300.0
2023-06-06 05:00:00	SPY	ETF	426.76	426.78	426.74	426.74	999.0
2023-06-06 05:05:00	SPY	ETF	426.89	426.9	426.69	426.69	800.0
2023-06-06 05:10:00	SPY	ETF	426.74	426.74	426.74	426.74	472.0
2023-06-06 05:15:00	SPY	ETF	426.69	426.69	426.51	426.62	3901.0
2023-06-06 05:20:00	SPY	ETF	426.66	426.74	426.66	426.72	2100.0
2023-06-06 05:25:00	SPY	ETF	426.75	426.75	426.75	426.75	100.0
2023-06-06 05:30:00	SPY	ETF	426.8	426.8	426.8	426.8	1000.0
2023-06-06 05:35:00	SPY	ETF	426.82	426.82	426.78	426.78	700.0
2023-06-06 05:40:00	SPY	ETF	426.96	426.96	426.96	426.96	100.0
2023-06-06 05:50:00	SPY	ETF	426.82	426.82	426.82	426.82	200.0
2023-06-06 05:55:00	SPY	ETF	426.79	426.79	426.79	426.79	100.0
2023-06-06 06:00:00	SPY	ETF	426.83	426.83	426.67	426.67	630.0
2023-06-06 06:05:00	SPY	ETF	426.73	426.73	426.72	426.72	600.0
2023-06-06 06:10:00	SPY	ETF	426.68	426.68	426.68	426.68	196.0
2023-06-06 06:20:00	SPY	ETF	426.69	426.69	426.69	426.69	200.0
2023-06-06 06:25:00	SPY	ETF	426.76	426.82	426.73	426.78	3057.0
2023-06-06 06:30:00	SPY	ETF	426.74	426.74	426.74	426.74	3700.0
2023-06-06 06:35:00	SPY	ETF	426.84	426.93	426.84	426.93	689.0
2023-06-06 06:40:00	SPY	ETF	426.88	426.88	426.79	426.82	1600.0
2023-06-06 06:45:00	SPY	ETF	426.71	426.72	426.7	426.72	2700.0
2023-06-06 06:50:00	SPY	ETF	426.7	426.7	426.7	426.7	496.0
2023-06-06 06:55:00	SPY	ETF	426.85	426.94	426.85	426.87	2600.0
2023-06-06 07:00:00	SPY	ETF	426.84	426.92	426.84	426.92	2922.0
2023-06-06 07:05:00	SPY	ETF	426.92	426.93	426.82	426.88	7299.0
2023-06-06 07:10:00	SPY	ETF	426.9	426.9	426.841	426.841	940.0
2023-06-06 07:15:00	SPY	ETF	426.82	426.82	426.8	426.8	1500.0
2023-06-06 07:20:00	SPY	ETF	426.87	426.88	426.77	426.78	3951.0
2023-06-06 07:25:00	SPY	ETF	426.79	426.99	426.79	426.99	2123.0
2023-06-06 07:30:00	SPY	ETF	427.0	427.0	426.89	426.91	2946.0
2023-06-06 07:35:00	SPY	ETF	426.92	426.99	426.92	426.99	4151.0
2023-06-06 07:40:00	SPY	ETF	426.91	427.01	426.87	427.01	5331.0
2023-06-06 07:45:00	SPY	ETF	427.02	427.14	426.98	426.99	9483.0
2023-06-06 07:50:00	SPY	ETF	426.98	427.0	426.98	426.99	1799.0
2023-06-06 07:55:00	SPY	ETF	426.99	427.02	426.97	426.98	2194.0
2023-06-06 08:00:00	SPY	ETF	426.8416	427.42	426.6604	427.14	24214.0
2023-06-06 08:05:00	SPY	ETF	427.07	427.0798	427.0	427.0	1799.0
2023-06-06 08:10:00	SPY	ETF	426.97	426.97	426.7	426.71	13159.0
2023-06-06 08:15:00	SPY	ETF	426.73	427.0	426.73	426.97	3960.0

> showing 50 of 96,161 rows — these rows as CSV

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