PREVIEW / etf_5min / 2023-08-07

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-08-07.parquet
  size:    1.9 MB
  rows:    95,652

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-07 04:00:00	SPY	ETF	448.94	449.08	448.45	448.84	12488.0
2023-08-07 04:05:00	SPY	ETF	448.81	448.96	448.78	448.8	31927.0
2023-08-07 04:10:00	SPY	ETF	448.79	448.89	448.78	448.78	521.0
2023-08-07 04:15:00	SPY	ETF	448.75	448.75	448.74	448.75	625.0
2023-08-07 04:20:00	SPY	ETF	448.76	448.85	448.63	448.63	6264.0
2023-08-07 04:25:00	SPY	ETF	448.56	448.62	448.52	448.52	1080.0
2023-08-07 04:30:00	SPY	ETF	448.5	448.54	448.33	448.33	787.0
2023-08-07 04:40:00	SPY	ETF	448.03	448.03	448.0	448.0	800.0
2023-08-07 04:45:00	SPY	ETF	448.05	448.05	447.86	447.86	900.0
2023-08-07 04:50:00	SPY	ETF	447.76	448.25	447.76	448.25	1613.0
2023-08-07 04:55:00	SPY	ETF	448.21	448.25	448.11	448.14	800.0
2023-08-07 05:00:00	SPY	ETF	448.14	448.14	447.91	447.96	1632.0
2023-08-07 05:05:00	SPY	ETF	448.03	448.03	448.03	448.03	1371.0
2023-08-07 05:10:00	SPY	ETF	448.06	448.06	447.93	447.94	4100.0
2023-08-07 05:15:00	SPY	ETF	448.01	448.12	448.01	448.11	1200.0
2023-08-07 05:20:00	SPY	ETF	448.08	448.1	448.08	448.1	600.0
2023-08-07 05:25:00	SPY	ETF	448.22	448.22	448.13	448.13	418.0
2023-08-07 05:35:00	SPY	ETF	448.17	448.38	448.17	448.38	618.0
2023-08-07 05:40:00	SPY	ETF	448.42	448.43	448.42	448.43	800.0
2023-08-07 05:50:00	SPY	ETF	448.43	448.43	448.38	448.38	500.0
2023-08-07 05:55:00	SPY	ETF	448.4	448.45	448.4	448.4	1400.0
2023-08-07 06:00:00	SPY	ETF	448.38	448.38	448.38	448.38	100.0
2023-08-07 06:05:00	SPY	ETF	448.14	448.14	448.05	448.07	550.0
2023-08-07 06:10:00	SPY	ETF	447.92	447.92	447.92	447.92	1000.0
2023-08-07 06:15:00	SPY	ETF	448.01	448.13	448.01	448.1	1572.0
2023-08-07 06:20:00	SPY	ETF	447.98	447.98	447.75	447.75	2400.0
2023-08-07 06:25:00	SPY	ETF	447.88	447.88	447.68	447.7	5046.0
2023-08-07 06:30:00	SPY	ETF	447.5	447.7	447.47	447.7	5910.0
2023-08-07 06:35:00	SPY	ETF	447.8	447.8	447.77	447.78	1445.0
2023-08-07 06:40:00	SPY	ETF	447.76	447.76	447.65	447.69	2600.0
2023-08-07 06:45:00	SPY	ETF	447.8	447.81	447.68	447.72	7977.0
2023-08-07 06:50:00	SPY	ETF	447.9	447.93	447.78	447.89	7869.0
2023-08-07 06:55:00	SPY	ETF	447.93	447.93	447.78	447.78	6814.0
2023-08-07 07:00:00	SPY	ETF	447.82	447.95	447.82	447.89	10046.0
2023-08-07 07:05:00	SPY	ETF	447.86	447.88	447.8	447.85	6538.0
2023-08-07 07:10:00	SPY	ETF	447.9	448.06	447.9	448.0	28968.0
2023-08-07 07:15:00	SPY	ETF	448.0	448.0	447.89	447.97	13667.0
2023-08-07 07:20:00	SPY	ETF	447.88	447.99	447.8	447.83	15530.0
2023-08-07 07:25:00	SPY	ETF	447.76	447.81	447.73	447.81	19465.0
2023-08-07 07:30:00	SPY	ETF	447.81	447.83	447.72	447.82	8234.0
2023-08-07 07:35:00	SPY	ETF	447.79	447.93	447.79	447.93	8175.0
2023-08-07 07:40:00	SPY	ETF	447.87	447.87	447.82	447.82	1100.0
2023-08-07 07:45:00	SPY	ETF	447.77	447.95	447.77	447.91	5073.0
2023-08-07 07:50:00	SPY	ETF	447.94	448.0	447.9	448.0	5306.0
2023-08-07 07:55:00	SPY	ETF	447.9	447.93	447.88	447.88	3500.0
2023-08-07 08:00:00	SPY	ETF	447.94	448.76	447.71	447.92	66807.0
2023-08-07 08:05:00	SPY	ETF	447.95	448.02	447.86	447.86	18086.0
2023-08-07 08:10:00	SPY	ETF	447.88	448.02	447.88	448.0	5751.0
2023-08-07 08:15:00	SPY	ETF	448.01	448.01	447.54	447.54	16861.0
2023-08-07 08:20:00	SPY	ETF	447.53	447.63	447.45	447.5	25005.0

> showing 50 of 95,652 rows — these rows as CSV

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