PREVIEW / etf_5min / 2023-10-06

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-10-06.parquet
  size:    2.1 MB
  rows:    100,024

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-10-06 04:00:00	SPY	ETF	424.65	424.93	424.65	424.67	11494.0
2023-10-06 04:05:00	SPY	ETF	424.7	424.95	424.7	424.87	4900.0
2023-10-06 04:10:00	SPY	ETF	424.94	425.01	424.72	424.73	5850.0
2023-10-06 04:15:00	SPY	ETF	424.83	424.87	424.77	424.85	3075.0
2023-10-06 04:20:00	SPY	ETF	424.92	424.92	424.67	424.77	4538.0
2023-10-06 04:25:00	SPY	ETF	424.75	424.85	424.75	424.84	2565.0
2023-10-06 04:30:00	SPY	ETF	424.87	424.87	424.36	424.47	3173.0
2023-10-06 04:35:00	SPY	ETF	424.44	424.55	424.44	424.52	2802.0
2023-10-06 04:40:00	SPY	ETF	424.51	424.76	424.5	424.76	1551.0
2023-10-06 04:45:00	SPY	ETF	424.65	424.81	424.65	424.79	6492.0
2023-10-06 04:55:00	SPY	ETF	424.48	424.6	424.48	424.5	1200.0
2023-10-06 05:00:00	SPY	ETF	424.54	424.6	424.42	424.6	2811.0
2023-10-06 05:05:00	SPY	ETF	424.7	424.71	424.7	424.7	864.0
2023-10-06 05:10:00	SPY	ETF	424.65	424.75	424.65	424.75	700.0
2023-10-06 05:15:00	SPY	ETF	424.8	424.8	424.8	424.8	300.0
2023-10-06 05:20:00	SPY	ETF	424.84	424.86	424.84	424.86	3700.0
2023-10-06 05:25:00	SPY	ETF	424.8	424.94	424.8	424.94	6800.0
2023-10-06 05:30:00	SPY	ETF	424.89	425.0	424.86	425.0	1017.0
2023-10-06 05:45:00	SPY	ETF	424.8	424.8	424.77	424.77	200.0
2023-10-06 05:50:00	SPY	ETF	424.82	424.98	424.82	424.98	700.0
2023-10-06 05:55:00	SPY	ETF	424.99	425.05	424.98	425.01	1100.0
2023-10-06 06:00:00	SPY	ETF	425.12	425.2	425.05	425.1	7711.0
2023-10-06 06:05:00	SPY	ETF	425.16	425.29	425.16	425.29	1900.0
2023-10-06 06:10:00	SPY	ETF	425.33	425.45	425.33	425.45	1400.0
2023-10-06 06:15:00	SPY	ETF	425.47	425.5	425.42	425.48	4257.0
2023-10-06 06:20:00	SPY	ETF	425.45	425.57	425.45	425.57	1000.0
2023-10-06 06:25:00	SPY	ETF	425.52	425.68	425.52	425.67	1877.0
2023-10-06 06:30:00	SPY	ETF	425.62	425.79	425.6	425.77	8259.0
2023-10-06 06:35:00	SPY	ETF	425.79	425.84	425.79	425.81	5964.0
2023-10-06 06:40:00	SPY	ETF	425.81	425.83	425.74	425.77	5578.0
2023-10-06 06:45:00	SPY	ETF	425.84	425.84	425.51	425.52	2075.0
2023-10-06 06:50:00	SPY	ETF	425.5	425.5	425.43	425.43	675.0
2023-10-06 06:55:00	SPY	ETF	425.45	425.53	425.37	425.51	1918.0
2023-10-06 07:00:00	SPY	ETF	425.42	425.42	425.31	425.32	2574.0
2023-10-06 07:05:00	SPY	ETF	425.34	425.37	425.15	425.23	6573.0
2023-10-06 07:10:00	SPY	ETF	425.25	425.45	425.25	425.37	9577.0
2023-10-06 07:15:00	SPY	ETF	425.36	425.521	425.36	425.521	12601.0
2023-10-06 07:20:00	SPY	ETF	425.56	425.581	425.25	425.28	15753.0
2023-10-06 07:25:00	SPY	ETF	425.22	425.28	425.03	425.19	34362.0
2023-10-06 07:30:00	SPY	ETF	425.2	425.2	424.86	425.001	32220.0
2023-10-06 07:35:00	SPY	ETF	425.01	425.01	424.9	424.9	1350.0
2023-10-06 07:40:00	SPY	ETF	424.97	425.01	424.91	424.91	1316.0
2023-10-06 07:45:00	SPY	ETF	424.99	425.18	424.99	425.099	14790.0
2023-10-06 07:50:00	SPY	ETF	425.2	425.24	424.95	424.95	17667.0
2023-10-06 07:55:00	SPY	ETF	424.94	424.95	424.74	424.809	19093.0
2023-10-06 08:00:00	SPY	ETF	425.34	425.8204	423.66	424.89	42163.0
2023-10-06 08:05:00	SPY	ETF	424.95	425.2	424.9	425.11	28445.0
2023-10-06 08:10:00	SPY	ETF	425.0	425.02	424.8	424.9	57523.0
2023-10-06 08:15:00	SPY	ETF	424.9	425.01	424.77	424.8	21614.0
2023-10-06 08:20:00	SPY	ETF	424.66	424.84	424.62	424.72	33626.0

> showing 50 of 100,024 rows — these rows as CSV

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