PREVIEW / etf_5min / 2007-10-23

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-10-23.parquet
  size:    391 KB
  rows:    19,445

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-10-23 04:50:00	SPY	ETF	151.1	151.1	151.1	151.1	100.0
2007-10-23 05:55:00	SPY	ETF	151.03	151.03	151.03	151.03	2000.0
2007-10-23 06:15:00	SPY	ETF	151.15	151.15	151.15	151.15	2000.0
2007-10-23 06:30:00	SPY	ETF	151.3	151.32	151.3	151.32	100000.0
2007-10-23 06:35:00	SPY	ETF	151.26	151.26	151.26	151.26	5000.0
2007-10-23 06:40:00	SPY	ETF	151.33	151.33	151.33	151.33	200.0
2007-10-23 06:50:00	SPY	ETF	151.42	151.43	151.42	151.43	25000.0
2007-10-23 06:55:00	SPY	ETF	151.42	151.42	151.4	151.4	6500.0
2007-10-23 07:00:00	SPY	ETF	151.37	151.37	151.37	151.37	100.0
2007-10-23 07:05:00	SPY	ETF	151.37	151.38	151.32	151.33	43100.0
2007-10-23 07:10:00	SPY	ETF	151.35	151.39	151.2	151.23	97000.0
2007-10-23 07:15:00	SPY	ETF	151.21	151.3	151.15	151.15	117400.0
2007-10-23 07:20:00	SPY	ETF	151.12	151.15	150.99	151.0	137100.0
2007-10-23 07:25:00	SPY	ETF	151.01	151.06	150.99	151.01	10300.0
2007-10-23 07:30:00	SPY	ETF	151.01	151.01	150.93	150.94	114400.0
2007-10-23 07:35:00	SPY	ETF	150.96	151.03	150.96	151.03	8500.0
2007-10-23 07:40:00	SPY	ETF	151.03	151.15	151.03	151.12	106000.0
2007-10-23 07:45:00	SPY	ETF	151.13	151.14	151.09	151.13	37700.0
2007-10-23 07:50:00	SPY	ETF	151.11	151.11	150.97	150.97	20300.0
2007-10-23 07:55:00	SPY	ETF	150.94	151.0	150.93	150.98	24700.0
2007-10-23 08:00:00	SPY	ETF	150.97	151.13	150.96	151.13	1270100.0
2007-10-23 08:05:00	SPY	ETF	151.17	151.17	151.03	151.03	36700.0
2007-10-23 08:10:00	SPY	ETF	151.06	151.1	151.03	151.04	108000.0
2007-10-23 08:15:00	SPY	ETF	151.05	151.1	151.0	151.02	177200.0
2007-10-23 08:20:00	SPY	ETF	151.04	151.04	151.0	151.03	88700.0
2007-10-23 08:25:00	SPY	ETF	151.03	151.14	151.03	151.14	225000.0
2007-10-23 08:30:00	SPY	ETF	151.1	151.28	151.1	151.26	69100.0
2007-10-23 08:35:00	SPY	ETF	151.28	151.32	151.26	151.3	240300.0
2007-10-23 08:40:00	SPY	ETF	151.29	151.35	151.29	151.35	147700.0
2007-10-23 08:45:00	SPY	ETF	151.31	151.32	151.25	151.29	32400.0
2007-10-23 08:50:00	SPY	ETF	151.29	151.4	151.1	151.3	149000.0
2007-10-23 08:55:00	SPY	ETF	151.29	151.41	151.29	151.37	146900.0
2007-10-23 09:00:00	SPY	ETF	151.39	151.42	151.35	151.36	184700.0
2007-10-23 09:05:00	SPY	ETF	151.36	151.49	151.35	151.47	708600.0
2007-10-23 09:10:00	SPY	ETF	151.47	151.47	151.42	151.44	293800.0
2007-10-23 09:15:00	SPY	ETF	151.43	151.5	151.43	151.48	390600.0
2007-10-23 09:20:00	SPY	ETF	151.49	151.5	151.43	151.44	158100.0
2007-10-23 09:25:00	SPY	ETF	151.44	151.44	151.3	151.31	328200.0
2007-10-23 09:30:00	SPY	ETF	151.3	151.5	151.3	151.46	3651804.0
2007-10-23 09:35:00	SPY	ETF	151.46	151.52	151.35	151.42	2734118.0
2007-10-23 09:40:00	SPY	ETF	151.42	151.45	151.28	151.34	1701600.0
2007-10-23 09:45:00	SPY	ETF	151.34	151.34	151.15	151.17	2995700.0
2007-10-23 09:50:00	SPY	ETF	151.17	151.37	151.15	151.32	2549000.0
2007-10-23 09:55:00	SPY	ETF	151.33	151.33	151.15	151.27	1973900.0
2007-10-23 10:00:00	SPY	ETF	151.29	151.48	151.23	151.4	1934600.0
2007-10-23 10:05:00	SPY	ETF	151.4	151.61	151.34	151.47	2679500.0
2007-10-23 10:10:00	SPY	ETF	151.47	151.56	151.41	151.41	2015300.0
2007-10-23 10:15:00	SPY	ETF	151.42	151.42	151.23	151.27	2202300.0
2007-10-23 10:20:00	SPY	ETF	151.26	151.26	151.1	151.25	2523100.0
2007-10-23 10:25:00	SPY	ETF	151.24	151.4	151.16	151.33	1636600.0

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

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