PREVIEW / etf_5min / 2023-08-09

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-08-09.parquet
  size:    2.0 MB
  rows:    96,218

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-08-09 04:00:00	SPY	ETF	449.96	450.03	449.62	450.03	3118.0
2023-08-09 04:05:00	SPY	ETF	450.2	450.26	450.19	450.23	3770.0
2023-08-09 04:10:00	SPY	ETF	450.19	450.19	450.02	450.1	5314.0
2023-08-09 04:15:00	SPY	ETF	450.1	450.1	449.84	449.84	877.0
2023-08-09 04:20:00	SPY	ETF	450.0	450.0	450.0	450.0	100.0
2023-08-09 04:25:00	SPY	ETF	450.25	450.3	450.25	450.26	444.0
2023-08-09 04:30:00	SPY	ETF	450.34	450.35	450.34	450.34	649.0
2023-08-09 04:35:00	SPY	ETF	450.5	450.58	450.4	450.43	4770.0
2023-08-09 04:40:00	SPY	ETF	450.4	450.42	450.4	450.42	241.0
2023-08-09 04:45:00	SPY	ETF	450.37	450.6	450.37	450.55	4919.0
2023-08-09 04:50:00	SPY	ETF	450.53	450.53	450.51	450.52	1500.0
2023-08-09 04:55:00	SPY	ETF	450.51	450.53	450.51	450.52	703.0
2023-08-09 05:00:00	SPY	ETF	450.48	450.48	450.45	450.45	200.0
2023-08-09 05:05:00	SPY	ETF	450.52	450.52	450.52	450.52	192.0
2023-08-09 05:10:00	SPY	ETF	450.38	450.63	450.38	450.63	1933.0
2023-08-09 05:15:00	SPY	ETF	450.6	450.6	450.32	450.32	1406.0
2023-08-09 05:20:00	SPY	ETF	450.31	450.45	450.31	450.44	450.0
2023-08-09 05:25:00	SPY	ETF	450.32	450.32	450.32	450.32	140.0
2023-08-09 05:30:00	SPY	ETF	450.32	450.32	450.3	450.3	295.0
2023-08-09 05:35:00	SPY	ETF	450.26	450.26	450.11	450.11	4136.0
2023-08-09 05:40:00	SPY	ETF	450.17	450.17	450.17	450.17	136.0
2023-08-09 05:45:00	SPY	ETF	450.2	450.2	450.0	450.0	850.0
2023-08-09 05:50:00	SPY	ETF	449.98	450.12	449.98	450.12	1000.0
2023-08-09 06:00:00	SPY	ETF	450.19	450.19	450.19	450.19	264.0
2023-08-09 06:05:00	SPY	ETF	450.12	450.22	450.1	450.22	700.0
2023-08-09 06:10:00	SPY	ETF	450.18	450.18	450.0	450.0	442.0
2023-08-09 06:15:00	SPY	ETF	449.99	450.04	449.99	450.04	379.0
2023-08-09 06:20:00	SPY	ETF	450.14	450.19	450.14	450.19	325.0
2023-08-09 06:25:00	SPY	ETF	450.25	450.25	450.25	450.25	250.0
2023-08-09 06:30:00	SPY	ETF	450.36	450.4	450.31	450.33	864.0
2023-08-09 06:35:00	SPY	ETF	450.29	450.29	450.16	450.18	350.0
2023-08-09 06:40:00	SPY	ETF	450.06	450.06	449.92	449.93	1246.0
2023-08-09 06:45:00	SPY	ETF	449.84	449.87	449.8	449.83	2408.0
2023-08-09 06:50:00	SPY	ETF	449.84	449.88	449.84	449.88	1480.0
2023-08-09 06:55:00	SPY	ETF	449.83	449.83	449.8	449.8	1450.0
2023-08-09 07:00:00	SPY	ETF	449.78	449.89	449.61	449.65	20739.0
2023-08-09 07:05:00	SPY	ETF	449.69	449.759	449.62	449.73	6762.0
2023-08-09 07:10:00	SPY	ETF	449.8	449.8	449.67	449.67	10100.0
2023-08-09 07:15:00	SPY	ETF	449.65	449.65	449.48	449.48	9100.0
2023-08-09 07:20:00	SPY	ETF	449.51	449.63	449.51	449.55	18725.0
2023-08-09 07:25:00	SPY	ETF	449.54	449.54	449.45	449.45	11652.0
2023-08-09 07:30:00	SPY	ETF	449.44	449.84	449.43	449.84	24489.0
2023-08-09 07:35:00	SPY	ETF	449.85	449.92	449.78	449.85	11214.0
2023-08-09 07:40:00	SPY	ETF	449.87	450.02	449.86	449.98	27052.0
2023-08-09 07:45:00	SPY	ETF	449.98	450.21	449.94	450.18	25769.0
2023-08-09 07:50:00	SPY	ETF	450.22	450.26	450.17	450.2	18024.0
2023-08-09 07:55:00	SPY	ETF	450.26	450.3	450.17	450.19	7484.0
2023-08-09 08:00:00	SPY	ETF	449.47	450.6204	449.26	450.26	45594.0
2023-08-09 08:05:00	SPY	ETF	450.26	450.3	450.02	450.03	76715.0
2023-08-09 08:10:00	SPY	ETF	450.1	450.11	449.87	449.97	18300.0

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

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