PREVIEW / etf_5min / 2007-07-03

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-07-03.parquet
  size:    188 KB
  rows:    9,444

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-03 06:20:00	SPY	ETF	152.31	152.31	152.31	152.31	3500.0
2007-07-03 06:40:00	SPY	ETF	152.3	152.3	152.3	152.3	25000.0
2007-07-03 06:45:00	SPY	ETF	152.3	152.3	152.3	152.3	100.0
2007-07-03 07:00:00	SPY	ETF	152.3	152.3	152.28	152.3	9900.0
2007-07-03 07:05:00	SPY	ETF	152.3	152.34	152.3	152.31	2900.0
2007-07-03 07:10:00	SPY	ETF	152.31	152.33	152.3	152.3	29500.0
2007-07-03 07:15:00	SPY	ETF	152.3	152.3	152.3	152.3	35500.0
2007-07-03 07:20:00	SPY	ETF	152.25	152.25	152.25	152.25	500.0
2007-07-03 07:30:00	SPY	ETF	152.27	152.28	152.27	152.28	3800.0
2007-07-03 07:40:00	SPY	ETF	152.29	152.29	152.28	152.29	23500.0
2007-07-03 07:45:00	SPY	ETF	152.3	152.3	152.25	152.28	243500.0
2007-07-03 07:50:00	SPY	ETF	152.28	152.31	152.28	152.3	69400.0
2007-07-03 07:55:00	SPY	ETF	152.31	152.33	152.27	152.29	105700.0
2007-07-03 08:00:00	SPY	ETF	151.79	152.28	151.79	152.28	46000.0
2007-07-03 08:05:00	SPY	ETF	152.3	152.33	152.3	152.33	155300.0
2007-07-03 08:10:00	SPY	ETF	152.32	152.32	152.3	152.3	53700.0
2007-07-03 08:15:00	SPY	ETF	152.3	152.31	152.28	152.31	166200.0
2007-07-03 08:20:00	SPY	ETF	152.32	152.36	152.32	152.33	77400.0
2007-07-03 08:25:00	SPY	ETF	152.32	152.34	152.29	152.29	20000.0
2007-07-03 08:30:00	SPY	ETF	152.29	152.29	152.22	152.26	22000.0
2007-07-03 08:35:00	SPY	ETF	152.25	152.26	152.22	152.23	83100.0
2007-07-03 08:40:00	SPY	ETF	152.24	152.24	152.18	152.18	3500.0
2007-07-03 08:45:00	SPY	ETF	152.18	152.22	152.17	152.2	95900.0
2007-07-03 08:50:00	SPY	ETF	152.21	152.22	152.2	152.2	100600.0
2007-07-03 08:55:00	SPY	ETF	152.2	152.24	152.16	152.22	202100.0
2007-07-03 09:00:00	SPY	ETF	152.22	152.23	152.2	152.23	66800.0
2007-07-03 09:05:00	SPY	ETF	152.23	152.23	152.18	152.2	21800.0
2007-07-03 09:10:00	SPY	ETF	152.19	152.23	152.19	152.23	89700.0
2007-07-03 09:15:00	SPY	ETF	152.24	152.24	152.2	152.2	12300.0
2007-07-03 09:20:00	SPY	ETF	152.18	152.2	152.18	152.19	28300.0
2007-07-03 09:25:00	SPY	ETF	152.19	152.2	152.16	152.18	102700.0
2007-07-03 09:30:00	SPY	ETF	152.18	152.22	152.06	152.13	1951390.0
2007-07-03 09:35:00	SPY	ETF	152.14	152.2	151.99	152.195	2926675.0
2007-07-03 09:40:00	SPY	ETF	152.19	152.4	152.14	152.34	3826500.0
2007-07-03 09:45:00	SPY	ETF	152.34	152.39	152.21	152.25	1544013.0
2007-07-03 09:50:00	SPY	ETF	152.25	152.3	152.23	152.265	793270.0
2007-07-03 09:55:00	SPY	ETF	152.265	152.4	152.265	152.4	761165.0
2007-07-03 10:00:00	SPY	ETF	152.39	152.5	152.22	152.3	3269800.0
2007-07-03 10:05:00	SPY	ETF	152.29	152.35	152.24	152.33	1346300.0
2007-07-03 10:10:00	SPY	ETF	152.33	152.42	152.25	152.33	1274400.0
2007-07-03 10:15:00	SPY	ETF	152.33	152.34	152.24	152.3	1214210.0
2007-07-03 10:20:00	SPY	ETF	152.31	152.4	152.3	152.35	890300.0
2007-07-03 10:25:00	SPY	ETF	152.35	152.45	152.32	152.44	2058504.0
2007-07-03 10:30:00	SPY	ETF	152.44	152.45	152.34	152.38	2029306.0
2007-07-03 10:35:00	SPY	ETF	152.39	152.4	152.29	152.36	1325998.0
2007-07-03 10:40:00	SPY	ETF	152.36	152.4	152.3	152.36	1047500.0
2007-07-03 10:45:00	SPY	ETF	152.36	152.39	152.31	152.33	966500.0
2007-07-03 10:50:00	SPY	ETF	152.34	152.36	152.29	152.33	985900.0
2007-07-03 10:55:00	SPY	ETF	152.33	152.35	152.28	152.31	569681.0
2007-07-03 11:00:00	SPY	ETF	152.31	152.32	152.16	152.18	1201329.0

> showing 50 of 9,444 rows — these rows as CSV

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