PREVIEW / etf_5min / 2007-11-09

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-11-09.parquet
  size:    444 KB
  rows:    21,184

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-09 04:10:00	SPY	ETF	147.54	147.54	147.54	147.54	2000.0
2007-11-09 04:20:00	SPY	ETF	147.54	147.54	147.54	147.54	3000.0
2007-11-09 04:50:00	SPY	ETF	147.27	147.27	147.27	147.27	1000.0
2007-11-09 05:25:00	SPY	ETF	147.12	147.12	147.12	147.12	1000.0
2007-11-09 05:40:00	SPY	ETF	146.81	146.81	146.73	146.73	14000.0
2007-11-09 05:45:00	SPY	ETF	146.51	146.51	146.51	146.51	20000.0
2007-11-09 05:50:00	SPY	ETF	146.56	146.56	146.56	146.56	5000.0
2007-11-09 06:05:00	SPY	ETF	146.56	146.56	146.34	146.34	2000.0
2007-11-09 06:10:00	SPY	ETF	146.37	146.37	146.32	146.32	4000.0
2007-11-09 06:15:00	SPY	ETF	146.37	146.37	146.13	146.13	4000.0
2007-11-09 06:20:00	SPY	ETF	146.02	146.1	146.0	146.08	5500.0
2007-11-09 06:25:00	SPY	ETF	146.08	146.08	145.95	145.95	36500.0
2007-11-09 06:30:00	SPY	ETF	145.91	145.91	145.6	145.6	30500.0
2007-11-09 06:35:00	SPY	ETF	145.75	145.81	145.75	145.81	34500.0
2007-11-09 06:40:00	SPY	ETF	145.81	145.81	145.6	145.77	33800.0
2007-11-09 06:45:00	SPY	ETF	145.74	145.75	145.73	145.75	62500.0
2007-11-09 06:50:00	SPY	ETF	145.75	145.8	145.65	145.8	204500.0
2007-11-09 06:55:00	SPY	ETF	145.75	145.75	145.68	145.74	119300.0
2007-11-09 07:00:00	SPY	ETF	145.83	146.12	145.7	146.12	162400.0
2007-11-09 07:05:00	SPY	ETF	146.13	146.2	145.96	146.15	42000.0
2007-11-09 07:10:00	SPY	ETF	146.15	146.4	146.15	146.3	361500.0
2007-11-09 07:15:00	SPY	ETF	146.17	146.26	146.09	146.2	200700.0
2007-11-09 07:20:00	SPY	ETF	146.25	146.25	146.12	146.15	63600.0
2007-11-09 07:25:00	SPY	ETF	146.16	146.16	145.92	146.01	43000.0
2007-11-09 07:30:00	SPY	ETF	146.03	146.11	146.0	146.11	91300.0
2007-11-09 07:35:00	SPY	ETF	146.14	146.18	145.82	145.82	150900.0
2007-11-09 07:40:00	SPY	ETF	145.96	145.96	145.88	145.96	93100.0
2007-11-09 07:45:00	SPY	ETF	145.94	146.03	145.9	146.03	39900.0
2007-11-09 07:50:00	SPY	ETF	146.06	146.06	145.83	145.86	35200.0
2007-11-09 07:55:00	SPY	ETF	145.82	145.96	145.8	145.9	77700.0
2007-11-09 08:00:00	SPY	ETF	145.92	146.15	145.66	146.15	654400.0
2007-11-09 08:05:00	SPY	ETF	146.14	146.17	146.03	146.05	220100.0
2007-11-09 08:10:00	SPY	ETF	146.05	146.05	145.95	146.01	117000.0
2007-11-09 08:15:00	SPY	ETF	146.0	146.03	145.87	146.03	237000.0
2007-11-09 08:20:00	SPY	ETF	146.01	146.07	145.99	145.99	14300.0
2007-11-09 08:25:00	SPY	ETF	145.99	146.0	145.5	145.7	473300.0
2007-11-09 08:30:00	SPY	ETF	145.72	145.84	145.52	145.7	860400.0
2007-11-09 08:35:00	SPY	ETF	145.69	145.78	145.58	145.6	702000.0
2007-11-09 08:40:00	SPY	ETF	145.63	145.73	145.53	145.61	502100.0
2007-11-09 08:45:00	SPY	ETF	145.55	145.8	145.55	145.76	133200.0
2007-11-09 08:50:00	SPY	ETF	145.76	145.99	145.72	145.98	302600.0
2007-11-09 08:55:00	SPY	ETF	145.98	146.1	145.81	145.91	701200.0
2007-11-09 09:00:00	SPY	ETF	145.9	145.94	145.8	145.82	177100.0
2007-11-09 09:05:00	SPY	ETF	145.83	145.95	145.83	145.86	160000.0
2007-11-09 09:10:00	SPY	ETF	145.86	145.99	145.85	145.91	203300.0
2007-11-09 09:15:00	SPY	ETF	145.92	145.92	145.86	145.9	188700.0
2007-11-09 09:20:00	SPY	ETF	145.89	145.89	145.73	145.75	373300.0
2007-11-09 09:25:00	SPY	ETF	145.77	145.77	145.52	145.52	338171.0
2007-11-09 09:30:00	SPY	ETF	145.51	145.95	145.41	145.88	4708825.0
2007-11-09 09:35:00	SPY	ETF	145.88	145.88	145.11	145.39	6203726.0

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

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