PREVIEW / etf_5min / 2007-11-01

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-11-01.parquet
  size:    433 KB
  rows:    21,062

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-11-01 04:15:00	SPY	ETF	154.5	154.5	154.5	154.5	100.0
2007-11-01 04:20:00	SPY	ETF	154.34	154.34	154.34	154.34	300.0
2007-11-01 04:35:00	SPY	ETF	154.29	154.29	154.29	154.29	200.0
2007-11-01 05:00:00	SPY	ETF	154.4	154.4	154.32	154.32	2300.0
2007-11-01 05:05:00	SPY	ETF	154.23	154.23	154.23	154.23	300.0
2007-11-01 05:50:00	SPY	ETF	154.35	154.35	154.35	154.35	1000.0
2007-11-01 05:55:00	SPY	ETF	154.32	154.32	154.32	154.32	12500.0
2007-11-01 06:00:00	SPY	ETF	154.27	154.27	154.27	154.27	10100.0
2007-11-01 06:05:00	SPY	ETF	154.26	154.26	154.26	154.26	200.0
2007-11-01 06:10:00	SPY	ETF	154.22	154.24	154.22	154.24	1200.0
2007-11-01 06:15:00	SPY	ETF	154.3	154.3	154.27	154.27	5200.0
2007-11-01 06:25:00	SPY	ETF	154.29	154.32	154.29	154.32	1200.0
2007-11-01 06:30:00	SPY	ETF	154.32	154.37	154.32	154.37	2700.0
2007-11-01 06:40:00	SPY	ETF	154.4	154.4	154.37	154.37	400.0
2007-11-01 06:50:00	SPY	ETF	154.45	154.45	154.37	154.37	2400.0
2007-11-01 06:55:00	SPY	ETF	154.4	154.4	154.4	154.4	200.0
2007-11-01 07:00:00	SPY	ETF	154.43	154.43	154.37	154.37	30500.0
2007-11-01 07:05:00	SPY	ETF	154.35	154.35	154.3	154.3	41200.0
2007-11-01 07:10:00	SPY	ETF	154.29	154.34	154.27	154.32	33100.0
2007-11-01 07:15:00	SPY	ETF	154.34	154.37	154.28	154.37	44100.0
2007-11-01 07:20:00	SPY	ETF	154.31	154.31	154.25	154.3	59000.0
2007-11-01 07:25:00	SPY	ETF	154.27	154.3	154.22	154.27	88800.0
2007-11-01 07:30:00	SPY	ETF	154.22	154.27	154.22	154.26	74000.0
2007-11-01 07:35:00	SPY	ETF	154.26	154.27	154.2	154.22	149400.0
2007-11-01 07:40:00	SPY	ETF	154.22	154.22	154.07	154.08	203000.0
2007-11-01 07:45:00	SPY	ETF	154.06	154.12	154.05	154.05	294500.0
2007-11-01 07:50:00	SPY	ETF	154.05	154.12	154.04	154.12	172800.0
2007-11-01 07:55:00	SPY	ETF	154.08	154.12	154.06	154.12	28400.0
2007-11-01 08:00:00	SPY	ETF	154.1	154.14	154.06	154.09	1192600.0
2007-11-01 08:05:00	SPY	ETF	154.08	154.21	153.87	153.89	1238700.0
2007-11-01 08:10:00	SPY	ETF	153.88	154.27	153.67	153.85	1273000.0
2007-11-01 08:15:00	SPY	ETF	153.83	154.06	153.8	153.82	784600.0
2007-11-01 08:20:00	SPY	ETF	153.8	153.82	153.68	153.73	186400.0
2007-11-01 08:25:00	SPY	ETF	153.72	154.65	153.67	153.8	587400.0
2007-11-01 08:30:00	SPY	ETF	153.76	154.01	153.76	153.95	685800.0
2007-11-01 08:35:00	SPY	ETF	153.94	153.97	153.45	153.45	711400.0
2007-11-01 08:40:00	SPY	ETF	153.45	153.75	153.31	153.51	1745200.0
2007-11-01 08:45:00	SPY	ETF	153.48	153.48	152.9	152.9	3557500.0
2007-11-01 08:50:00	SPY	ETF	152.94	153.2	152.93	153.08	901100.0
2007-11-01 08:55:00	SPY	ETF	153.07	153.22	153.02	153.05	1304300.0
2007-11-01 09:00:00	SPY	ETF	153.04	153.22	153.0	153.18	680200.0
2007-11-01 09:05:00	SPY	ETF	153.17	153.26	153.1	153.25	1065600.0
2007-11-01 09:10:00	SPY	ETF	153.24	153.3	153.17	153.3	231000.0
2007-11-01 09:15:00	SPY	ETF	153.3	153.32	153.22	153.22	357400.0
2007-11-01 09:20:00	SPY	ETF	153.24	153.27	153.21	153.23	131400.0
2007-11-01 09:25:00	SPY	ETF	153.23	154.48	153.19	153.33	767100.0
2007-11-01 09:30:00	SPY	ETF	153.3	153.41	153.18	153.221	3702620.0
2007-11-01 09:35:00	SPY	ETF	153.23	153.2999	152.39	152.4	6950005.0
2007-11-01 09:40:00	SPY	ETF	152.4	153.21	152.38	152.6	6920610.0
2007-11-01 09:45:00	SPY	ETF	152.59	153.19	152.05	152.43	9860315.0

> showing 50 of 21,062 rows — these rows as CSV

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