PREVIEW / etf_5min / 2007-09-06

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-09-06.parquet
  size:    338 KB
  rows:    17,711

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-06 04:50:00	SPY	ETF	148.1	148.1	148.1	148.1	2000.0
2007-09-06 05:55:00	SPY	ETF	147.88	147.88	147.88	147.88	2000.0
2007-09-06 06:05:00	SPY	ETF	147.65	147.65	147.65	147.65	1000.0
2007-09-06 06:15:00	SPY	ETF	147.43	147.43	147.35	147.36	91500.0
2007-09-06 06:25:00	SPY	ETF	147.41	147.45	147.35	147.35	6000.0
2007-09-06 06:40:00	SPY	ETF	147.45	147.45	147.45	147.45	1000.0
2007-09-06 06:50:00	SPY	ETF	147.5	147.6	147.5	147.6	8500.0
2007-09-06 07:00:00	SPY	ETF	147.58	147.58	147.48	147.55	188500.0
2007-09-06 07:05:00	SPY	ETF	147.55	147.55	147.4	147.43	78300.0
2007-09-06 07:10:00	SPY	ETF	147.36	147.39	147.23	147.34	163300.0
2007-09-06 07:15:00	SPY	ETF	147.33	147.33	147.16	147.27	82800.0
2007-09-06 07:20:00	SPY	ETF	147.3	147.4	147.29	147.29	61900.0
2007-09-06 07:25:00	SPY	ETF	147.26	147.34	147.25	147.25	10200.0
2007-09-06 07:30:00	SPY	ETF	147.3	147.5	147.3	147.45	46300.0
2007-09-06 07:35:00	SPY	ETF	147.47	147.56	147.46	147.46	47100.0
2007-09-06 07:40:00	SPY	ETF	147.43	147.54	147.43	147.53	49500.0
2007-09-06 07:45:00	SPY	ETF	147.53	147.58	147.31	147.38	76100.0
2007-09-06 07:50:00	SPY	ETF	147.4	147.5	147.4	147.48	96700.0
2007-09-06 07:55:00	SPY	ETF	147.45	147.45	147.17	147.33	115100.0
2007-09-06 08:00:00	SPY	ETF	148.25	148.25	147.21	147.23	193600.0
2007-09-06 08:05:00	SPY	ETF	147.26	147.46	147.21	147.46	45700.0
2007-09-06 08:10:00	SPY	ETF	147.45	147.6	147.38	147.52	232100.0
2007-09-06 08:15:00	SPY	ETF	147.58	147.6	147.5	147.54	71000.0
2007-09-06 08:20:00	SPY	ETF	147.56	147.73	147.55	147.63	123700.0
2007-09-06 08:25:00	SPY	ETF	147.62	147.75	147.6	147.6	622200.0
2007-09-06 08:30:00	SPY	ETF	147.6	148.01	147.6	147.9	2157800.0
2007-09-06 08:35:00	SPY	ETF	147.91	147.93	147.73	147.84	470600.0
2007-09-06 08:40:00	SPY	ETF	147.83	147.87	147.55	147.71	668200.0
2007-09-06 08:45:00	SPY	ETF	147.7	147.78	147.64	147.69	184200.0
2007-09-06 08:50:00	SPY	ETF	147.7	147.82	147.67	147.7	196700.0
2007-09-06 08:55:00	SPY	ETF	147.71	147.88	147.7	147.88	127400.0
2007-09-06 09:00:00	SPY	ETF	147.89	148.09	147.87	148.07	842600.0
2007-09-06 09:05:00	SPY	ETF	148.06	148.14	147.97	148.09	468600.0
2007-09-06 09:10:00	SPY	ETF	148.07	148.17	148.07	148.1	209700.0
2007-09-06 09:15:00	SPY	ETF	148.11	148.14	148.11	148.12	14900.0
2007-09-06 09:20:00	SPY	ETF	148.11	148.13	148.08	148.1	49900.0
2007-09-06 09:25:00	SPY	ETF	148.12	148.12	147.93	147.95	421751.0
2007-09-06 09:30:00	SPY	ETF	147.95	148.24	147.93	148.07	2987782.0
2007-09-06 09:35:00	SPY	ETF	148.08	148.12	147.93	147.94	2887923.0
2007-09-06 09:40:00	SPY	ETF	147.95	148.04	147.85	147.97	1659400.0
2007-09-06 09:45:00	SPY	ETF	147.98	147.98	147.78	147.817	2297400.0
2007-09-06 09:50:00	SPY	ETF	147.79	147.89	147.56	147.57	2813100.0
2007-09-06 09:55:00	SPY	ETF	147.56	147.69	147.48	147.61	2212100.0
2007-09-06 10:00:00	SPY	ETF	147.61	147.74	147.34	147.37	3007000.0
2007-09-06 10:05:00	SPY	ETF	147.38	147.5294	147.31	147.45	2337300.0
2007-09-06 10:10:00	SPY	ETF	147.45	147.6	147.42	147.48	1690800.0
2007-09-06 10:15:00	SPY	ETF	147.48	147.51	147.23	147.32	2201200.0
2007-09-06 10:20:00	SPY	ETF	147.31	147.37	147.12	147.36	1885000.0
2007-09-06 10:25:00	SPY	ETF	147.36	147.47	147.34	147.37	1625800.0
2007-09-06 10:30:00	SPY	ETF	147.38	147.53	147.29	147.52	1593700.0

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

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