PREVIEW / etf_5min / 2007-07-31

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-07-31.parquet
  size:    412 KB
  rows:    19,788

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-07-31 05:50:00	SPY	ETF	147.89	147.89	147.89	147.89	5000.0
2007-07-31 06:00:00	SPY	ETF	147.88	147.88	147.88	147.88	500.0
2007-07-31 06:10:00	SPY	ETF	147.91	147.91	147.91	147.91	300.0
2007-07-31 06:15:00	SPY	ETF	147.91	147.91	147.91	147.91	6000.0
2007-07-31 06:40:00	SPY	ETF	148.0	148.03	148.0	148.03	52500.0
2007-07-31 06:45:00	SPY	ETF	148.0	148.0	148.0	148.0	21900.0
2007-07-31 06:50:00	SPY	ETF	148.05	148.18	148.05	148.18	29100.0
2007-07-31 06:55:00	SPY	ETF	148.15	148.2	148.13	148.2	193000.0
2007-07-31 07:00:00	SPY	ETF	148.22	148.4	148.22	148.4	258600.0
2007-07-31 07:05:00	SPY	ETF	148.41	148.5	148.36	148.39	392000.0
2007-07-31 07:10:00	SPY	ETF	148.37	148.48	148.32	148.38	343100.0
2007-07-31 07:15:00	SPY	ETF	148.35	148.52	148.35	148.5	146700.0
2007-07-31 07:20:00	SPY	ETF	148.48	148.5	148.45	148.45	212700.0
2007-07-31 07:25:00	SPY	ETF	148.49	148.58	148.42	148.58	569500.0
2007-07-31 07:30:00	SPY	ETF	148.57	148.66	148.54	148.61	204600.0
2007-07-31 07:35:00	SPY	ETF	148.64	148.7	148.58	148.61	428800.0
2007-07-31 07:40:00	SPY	ETF	148.61	148.63	148.5	148.53	259200.0
2007-07-31 07:45:00	SPY	ETF	148.53	148.58	148.47	148.49	291400.0
2007-07-31 07:50:00	SPY	ETF	148.51	148.53	148.44	148.46	302300.0
2007-07-31 07:55:00	SPY	ETF	148.48	148.58	148.48	148.55	120600.0
2007-07-31 08:00:00	SPY	ETF	148.58	148.65	148.04	148.61	1609200.0
2007-07-31 08:05:00	SPY	ETF	148.6	148.6	148.52	148.53	42500.0
2007-07-31 08:10:00	SPY	ETF	148.42	148.6	148.42	148.58	176300.0
2007-07-31 08:15:00	SPY	ETF	148.58	148.75	148.33	148.72	1678300.0
2007-07-31 08:20:00	SPY	ETF	148.73	148.8	148.48	148.78	1154500.0
2007-07-31 08:25:00	SPY	ETF	148.77	148.81	148.65	148.79	509500.0
2007-07-31 08:30:00	SPY	ETF	148.84	148.95	148.67	148.73	1913100.0
2007-07-31 08:35:00	SPY	ETF	148.73	148.75	148.53	148.55	867500.0
2007-07-31 08:40:00	SPY	ETF	148.55	148.62	148.53	148.54	777600.0
2007-07-31 08:45:00	SPY	ETF	148.55	148.57	148.38	148.47	813300.0
2007-07-31 08:50:00	SPY	ETF	148.45	148.47	148.29	148.38	1457300.0
2007-07-31 08:55:00	SPY	ETF	148.37	148.46	147.23	148.23	1413800.0
2007-07-31 09:00:00	SPY	ETF	148.23	148.42	147.22	148.37	569700.0
2007-07-31 09:05:00	SPY	ETF	148.35	148.42	148.28	148.36	563100.0
2007-07-31 09:10:00	SPY	ETF	148.38	148.42	148.19	148.25	630700.0
2007-07-31 09:15:00	SPY	ETF	148.24	148.28	148.15	148.18	277700.0
2007-07-31 09:20:00	SPY	ETF	148.17	148.33	148.15	148.3	256400.0
2007-07-31 09:25:00	SPY	ETF	148.3	148.4	148.26	148.34	760800.0
2007-07-31 09:30:00	SPY	ETF	148.32	148.55	148.24	148.44	5195598.0
2007-07-31 09:35:00	SPY	ETF	148.45	148.51	148.31	148.37	4308998.0
2007-07-31 09:40:00	SPY	ETF	148.36	149.32	147.78	148.43	5050222.0
2007-07-31 09:45:00	SPY	ETF	148.43	148.51	147.66	148.38	5461671.0
2007-07-31 09:50:00	SPY	ETF	148.39	148.54	147.72	148.49	1940473.0
2007-07-31 09:55:00	SPY	ETF	148.49	149.22	148.34	148.47	1917561.0
2007-07-31 10:00:00	SPY	ETF	148.48	149.28	148.43	148.74	8194119.0
2007-07-31 10:05:00	SPY	ETF	148.74	148.82	148.61	148.69	3179616.0
2007-07-31 10:10:00	SPY	ETF	148.69	149.46	148.53	148.54	4923450.0
2007-07-31 10:15:00	SPY	ETF	148.54	149.36	148.24	148.38	3335226.0
2007-07-31 10:20:00	SPY	ETF	148.37	148.63	148.05	148.24	5368905.0
2007-07-31 10:25:00	SPY	ETF	148.25	148.33	147.96	147.98	3436899.0

> showing 50 of 19,788 rows — these rows as CSV

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