PREVIEW / etf_5min / 2007-09-05

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-09-05.parquet
  size:    335 KB
  rows:    17,623

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
2007-09-05 04:05:00	SPY	ETF	148.42	148.42	148.42	148.42	3000.0
2007-09-05 04:15:00	SPY	ETF	148.5	148.5	148.5	148.5	3000.0
2007-09-05 04:20:00	SPY	ETF	148.5	148.5	148.5	148.5	1000.0
2007-09-05 06:00:00	SPY	ETF	148.21	148.21	148.21	148.21	1000.0
2007-09-05 06:20:00	SPY	ETF	148.41	148.48	148.4	148.43	19400.0
2007-09-05 06:30:00	SPY	ETF	148.33	148.33	148.31	148.31	9100.0
2007-09-05 06:35:00	SPY	ETF	148.27	148.27	147.97	148.03	27400.0
2007-09-05 06:40:00	SPY	ETF	148.01	148.11	148.01	148.11	2100.0
2007-09-05 06:45:00	SPY	ETF	148.03	148.03	147.97	147.97	15500.0
2007-09-05 06:50:00	SPY	ETF	148.07	148.07	148.07	148.07	1000.0
2007-09-05 06:55:00	SPY	ETF	148.09	148.09	148.07	148.07	5400.0
2007-09-05 07:00:00	SPY	ETF	148.09	148.11	147.9	148.0	170100.0
2007-09-05 07:05:00	SPY	ETF	148.04	148.07	147.97	148.04	130900.0
2007-09-05 07:10:00	SPY	ETF	148.03	148.14	148.0	148.1	40300.0
2007-09-05 07:15:00	SPY	ETF	148.12	148.12	148.02	148.12	153900.0
2007-09-05 07:20:00	SPY	ETF	148.12	148.12	148.02	148.05	16700.0
2007-09-05 07:25:00	SPY	ETF	148.01	148.04	147.95	147.95	87600.0
2007-09-05 07:30:00	SPY	ETF	148.02	148.02	147.93	147.95	26200.0
2007-09-05 07:35:00	SPY	ETF	148.0	148.01	147.9	147.91	84100.0
2007-09-05 07:40:00	SPY	ETF	147.9	147.97	147.89	147.95	84100.0
2007-09-05 07:45:00	SPY	ETF	147.95	147.95	147.85	147.87	114900.0
2007-09-05 07:50:00	SPY	ETF	147.86	147.95	147.86	147.95	72400.0
2007-09-05 07:55:00	SPY	ETF	147.98	148.1	147.98	148.07	50300.0
2007-09-05 08:00:00	SPY	ETF	148.07	148.16	147.86	148.16	184300.0
2007-09-05 08:05:00	SPY	ETF	148.18	148.2	148.09	148.12	243600.0
2007-09-05 08:10:00	SPY	ETF	148.15	148.16	148.11	148.13	153600.0
2007-09-05 08:15:00	SPY	ETF	148.14	148.2	147.98	148.1	238900.0
2007-09-05 08:20:00	SPY	ETF	148.08	148.09	147.95	148.02	301300.0
2007-09-05 08:25:00	SPY	ETF	148.01	148.1	147.96	148.0	533700.0
2007-09-05 08:30:00	SPY	ETF	147.99	148.05	147.99	148.02	540300.0
2007-09-05 08:35:00	SPY	ETF	148.03	148.03	147.9	147.9	279200.0
2007-09-05 08:40:00	SPY	ETF	147.9	147.92	147.82	147.85	151100.0
2007-09-05 08:45:00	SPY	ETF	147.85	149.08	147.84	147.98	247800.0
2007-09-05 08:50:00	SPY	ETF	147.98	148.07	147.95	148.03	58300.0
2007-09-05 08:55:00	SPY	ETF	148.03	148.09	148.03	148.07	112500.0
2007-09-05 09:00:00	SPY	ETF	148.02	148.03	147.97	148.03	139200.0
2007-09-05 09:05:00	SPY	ETF	148.04	148.14	147.9	147.93	263200.0
2007-09-05 09:10:00	SPY	ETF	147.95	148.17	147.87	148.1	644200.0
2007-09-05 09:15:00	SPY	ETF	148.08	148.08	148.01	148.06	145900.0
2007-09-05 09:20:00	SPY	ETF	148.08	149.08	148.07	148.15	216000.0
2007-09-05 09:25:00	SPY	ETF	148.15	148.17	148.07	148.17	57000.0
2007-09-05 09:30:00	SPY	ETF	148.2	148.25	148.0	148.19	2899908.0
2007-09-05 09:35:00	SPY	ETF	148.17	148.36	148.1	148.15	2255600.0
2007-09-05 09:40:00	SPY	ETF	148.14	148.23	147.92	148.06	2933600.0
2007-09-05 09:45:00	SPY	ETF	148.06	148.35	148.0	148.22	2835000.0
2007-09-05 09:50:00	SPY	ETF	148.22	148.3	148.1	148.21	1399400.0
2007-09-05 09:55:00	SPY	ETF	148.21	148.23	147.93	147.98	1774600.0
2007-09-05 10:00:00	SPY	ETF	147.98	147.98	147.45	147.72	7238300.0
2007-09-05 10:05:00	SPY	ETF	147.72	147.79	147.56	147.69	3555800.0
2007-09-05 10:10:00	SPY	ETF	147.69	147.72	147.36	147.48	3249800.0

> showing 50 of 17,623 rows — these rows as CSV

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