PREVIEW / etf_5min / 2007-10-19

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-10-19.parquet
  size:    427 KB
  rows:    20,131

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-19 04:15:00	SPY	ETF	152.96	152.96	152.96	152.96	1500.0
2007-10-19 05:05:00	SPY	ETF	152.96	152.96	152.96	152.96	15000.0
2007-10-19 05:25:00	SPY	ETF	152.96	152.96	152.96	152.96	100.0
2007-10-19 05:30:00	SPY	ETF	152.93	152.93	152.93	152.93	10000.0
2007-10-19 05:35:00	SPY	ETF	152.88	152.88	152.88	152.88	2000.0
2007-10-19 05:55:00	SPY	ETF	153.08	153.08	153.08	153.08	12500.0
2007-10-19 06:05:00	SPY	ETF	153.22	153.24	153.22	153.24	3500.0
2007-10-19 06:15:00	SPY	ETF	153.18	153.18	153.18	153.18	2000.0
2007-10-19 06:35:00	SPY	ETF	153.35	153.4	153.35	153.4	15000.0
2007-10-19 06:45:00	SPY	ETF	153.28	153.36	153.28	153.36	31000.0
2007-10-19 06:55:00	SPY	ETF	153.39	153.39	153.39	153.39	2000.0
2007-10-19 07:00:00	SPY	ETF	153.41	153.41	153.32	153.32	2400.0
2007-10-19 07:05:00	SPY	ETF	153.32	153.39	153.32	153.39	12000.0
2007-10-19 07:10:00	SPY	ETF	153.37	153.37	153.32	153.35	52800.0
2007-10-19 07:15:00	SPY	ETF	153.38	153.5	153.38	153.46	17900.0
2007-10-19 07:20:00	SPY	ETF	153.45	153.48	153.45	153.48	14100.0
2007-10-19 07:25:00	SPY	ETF	153.49	153.5	153.46	153.46	16400.0
2007-10-19 07:30:00	SPY	ETF	153.42	153.43	153.28	153.28	139500.0
2007-10-19 07:35:00	SPY	ETF	153.28	153.33	153.22	153.25	554600.0
2007-10-19 07:40:00	SPY	ETF	153.32	153.32	153.32	153.32	1000.0
2007-10-19 07:45:00	SPY	ETF	153.32	153.38	153.32	153.32	42300.0
2007-10-19 07:50:00	SPY	ETF	153.4	153.4	153.4	153.4	1000.0
2007-10-19 07:55:00	SPY	ETF	153.41	153.41	153.31	153.31	128500.0
2007-10-19 08:00:00	SPY	ETF	153.36	153.38	153.33	153.37	1319500.0
2007-10-19 08:05:00	SPY	ETF	153.41	153.41	153.31	153.31	338400.0
2007-10-19 08:10:00	SPY	ETF	153.35	153.35	153.23	153.24	68200.0
2007-10-19 08:15:00	SPY	ETF	153.24	153.26	153.08	153.13	1074900.0
2007-10-19 08:20:00	SPY	ETF	153.12	153.21	153.12	153.21	79900.0
2007-10-19 08:25:00	SPY	ETF	153.21	153.25	153.21	153.25	38500.0
2007-10-19 08:30:00	SPY	ETF	153.28	153.3	153.27	153.29	75200.0
2007-10-19 08:35:00	SPY	ETF	153.29	153.51	152.92	153.28	197300.0
2007-10-19 08:40:00	SPY	ETF	153.25	153.34	153.24	153.25	499000.0
2007-10-19 08:45:00	SPY	ETF	153.25	153.34	153.22	153.3	309000.0
2007-10-19 08:50:00	SPY	ETF	153.32	153.35	153.255	153.31	535000.0
2007-10-19 08:55:00	SPY	ETF	153.31	153.34	153.3	153.32	149700.0
2007-10-19 09:00:00	SPY	ETF	153.32	153.32	153.22	153.22	96800.0
2007-10-19 09:05:00	SPY	ETF	153.23	153.26	153.21	153.22	58800.0
2007-10-19 09:10:00	SPY	ETF	153.23	153.23	153.08	153.08	269900.0
2007-10-19 09:15:00	SPY	ETF	153.11	153.15	152.97	153.04	256152.0
2007-10-19 09:20:00	SPY	ETF	153.06	153.09	153.05	153.09	270800.0
2007-10-19 09:25:00	SPY	ETF	153.09	153.1	152.96	153.09	817279.0
2007-10-19 09:30:00	SPY	ETF	153.11	156.48	152.97	152.99	1975026.0
2007-10-19 09:35:00	SPY	ETF	152.99	153.07	152.69	152.7	3597871.0
2007-10-19 09:40:00	SPY	ETF	152.69	153.0	152.6	152.8	6507700.0
2007-10-19 09:45:00	SPY	ETF	152.8	152.98	152.7	152.88	3611200.0
2007-10-19 09:50:00	SPY	ETF	152.88	152.93	152.79	152.82	1692703.0
2007-10-19 09:55:00	SPY	ETF	152.82	152.92	152.69	152.87	2694133.0
2007-10-19 10:00:00	SPY	ETF	152.87	153.012	152.46	152.5197	9173600.0
2007-10-19 10:05:00	SPY	ETF	152.51	152.51	152.23	152.45	7161600.0
2007-10-19 10:10:00	SPY	ETF	152.45	152.52	152.35	152.47	3587300.0

> showing 50 of 20,131 rows — these rows as CSV

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