PREVIEW / etf_5min / 2007-07-18

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-07-18.parquet
  size:    340 KB
  rows:    17,534

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-18 05:10:00	SPY	ETF	154.04	154.05	154.04	154.05	20000.0
2007-07-18 06:10:00	SPY	ETF	154.16	154.21	154.15	154.2	99600.0
2007-07-18 06:15:00	SPY	ETF	154.2	154.2	154.2	154.2	8800.0
2007-07-18 06:20:00	SPY	ETF	154.17	154.17	154.11	154.11	71400.0
2007-07-18 06:25:00	SPY	ETF	154.11	154.11	154.05	154.1	237100.0
2007-07-18 06:30:00	SPY	ETF	154.1	154.1	154.1	154.1	1500.0
2007-07-18 06:35:00	SPY	ETF	154.15	154.15	154.1	154.1	20500.0
2007-07-18 06:40:00	SPY	ETF	154.14	154.14	154.14	154.14	4500.0
2007-07-18 06:45:00	SPY	ETF	154.05	154.05	154.05	154.05	15000.0
2007-07-18 06:55:00	SPY	ETF	154.1	154.16	154.1	154.16	1500.0
2007-07-18 07:00:00	SPY	ETF	154.23	154.26	154.17	154.25	101000.0
2007-07-18 07:05:00	SPY	ETF	154.21	154.21	154.18	154.2	5600.0
2007-07-18 07:10:00	SPY	ETF	154.19	154.21	154.19	154.2	46100.0
2007-07-18 07:15:00	SPY	ETF	154.19	154.25	154.18	154.18	59700.0
2007-07-18 07:20:00	SPY	ETF	154.22	154.35	154.22	154.35	274900.0
2007-07-18 07:25:00	SPY	ETF	154.35	154.41	154.35	154.41	133200.0
2007-07-18 07:30:00	SPY	ETF	154.4	154.41	154.37	154.39	59100.0
2007-07-18 07:35:00	SPY	ETF	154.41	154.45	154.29	154.29	66200.0
2007-07-18 07:40:00	SPY	ETF	154.3	154.33	154.26	154.27	96000.0
2007-07-18 07:45:00	SPY	ETF	154.28	154.28	154.21	154.27	99900.0
2007-07-18 07:50:00	SPY	ETF	154.27	154.29	154.21	154.22	249600.0
2007-07-18 07:55:00	SPY	ETF	154.22	154.22	154.16	154.22	20900.0
2007-07-18 08:00:00	SPY	ETF	154.18	154.22	154.1	154.19	326000.0
2007-07-18 08:05:00	SPY	ETF	154.2	154.2	154.07	154.09	105500.0
2007-07-18 08:10:00	SPY	ETF	154.3	154.3	154.05	154.06	67100.0
2007-07-18 08:15:00	SPY	ETF	154.08	154.19	154.08	154.19	81800.0
2007-07-18 08:20:00	SPY	ETF	154.19	154.2	154.08	154.12	1238900.0
2007-07-18 08:25:00	SPY	ETF	154.14	154.14	153.96	154.11	347200.0
2007-07-18 08:30:00	SPY	ETF	154.11	154.26	153.95	154.04	1347900.0
2007-07-18 08:35:00	SPY	ETF	154.04	154.14	153.85	154.05	184400.0
2007-07-18 08:40:00	SPY	ETF	154.04	154.13	153.85	154.1	400400.0
2007-07-18 08:45:00	SPY	ETF	154.08	154.2	154.08	154.15	286400.0
2007-07-18 08:50:00	SPY	ETF	154.13	154.16	154.12	154.12	70300.0
2007-07-18 08:55:00	SPY	ETF	154.12	154.18	154.1	154.18	190300.0
2007-07-18 09:00:00	SPY	ETF	154.18	154.18	154.12	154.14	323800.0
2007-07-18 09:05:00	SPY	ETF	154.14	154.17	154.14	154.16	208900.0
2007-07-18 09:10:00	SPY	ETF	154.16	154.19	154.14	154.14	494700.0
2007-07-18 09:15:00	SPY	ETF	154.16	154.22	154.14	154.21	75400.0
2007-07-18 09:20:00	SPY	ETF	154.22	154.27	154.22	154.24	92700.0
2007-07-18 09:25:00	SPY	ETF	154.25	154.31	154.2	154.31	228500.0
2007-07-18 09:30:00	SPY	ETF	154.31	154.32	154.15	154.18	3921770.0
2007-07-18 09:35:00	SPY	ETF	154.18	154.3	154.08	154.27	3677857.0
2007-07-18 09:40:00	SPY	ETF	154.28	154.51	154.13	154.46	7089500.0
2007-07-18 09:45:00	SPY	ETF	154.46	154.73	154.38	154.64	5513472.0
2007-07-18 09:50:00	SPY	ETF	154.64	154.715	154.45	154.47	4081000.0
2007-07-18 09:55:00	SPY	ETF	154.47	154.58	154.34	154.49	3961229.0
2007-07-18 10:00:00	SPY	ETF	154.48	154.78	154.4	154.44	6761863.0
2007-07-18 10:05:00	SPY	ETF	154.45	154.52	154.21	154.21	5226685.0
2007-07-18 10:10:00	SPY	ETF	154.21	154.28	154.01	154.22	5392730.0
2007-07-18 10:15:00	SPY	ETF	154.23	154.3	154.1	154.27	2851137.0

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

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