PREVIEW / etf_5min / 2009-10-01

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-10-01.parquet
  size:    790 KB
  rows:    31,856

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
2009-10-01 04:40:00	SPY	ETF	105.59	105.59	105.5	105.5	12800.0
2009-10-01 04:45:00	SPY	ETF	105.4	105.4	105.31	105.31	13000.0
2009-10-01 04:50:00	SPY	ETF	105.28	105.28	105.23	105.23	350.0
2009-10-01 04:55:00	SPY	ETF	105.41	105.41	105.41	105.41	100.0
2009-10-01 05:00:00	SPY	ETF	105.37	105.37	105.37	105.37	1600.0
2009-10-01 05:05:00	SPY	ETF	105.51	105.51	105.5	105.5	1500.0
2009-10-01 05:10:00	SPY	ETF	105.47	105.51	105.47	105.51	1600.0
2009-10-01 05:25:00	SPY	ETF	105.48	105.48	105.38	105.38	600.0
2009-10-01 05:30:00	SPY	ETF	105.43	105.43	105.43	105.43	200.0
2009-10-01 05:35:00	SPY	ETF	105.43	105.43	105.43	105.43	800.0
2009-10-01 05:50:00	SPY	ETF	105.22	105.22	105.21	105.21	3000.0
2009-10-01 06:00:00	SPY	ETF	105.27	105.31	105.27	105.31	200.0
2009-10-01 06:10:00	SPY	ETF	105.24	105.26	105.24	105.26	200.0
2009-10-01 06:15:00	SPY	ETF	105.21	105.22	105.2	105.22	15100.0
2009-10-01 06:25:00	SPY	ETF	105.3	105.3	105.3	105.3	1000.0
2009-10-01 06:35:00	SPY	ETF	105.25	105.25	105.23	105.25	1100.0
2009-10-01 06:40:00	SPY	ETF	105.25	105.25	105.12	105.12	828.0
2009-10-01 06:45:00	SPY	ETF	105.15	105.15	105.07	105.15	9628.0
2009-10-01 06:55:00	SPY	ETF	105.13	105.16	105.13	105.16	4500.0
2009-10-01 07:00:00	SPY	ETF	105.16	105.16	105.1	105.13	86446.0
2009-10-01 07:05:00	SPY	ETF	105.12	105.23	105.12	105.21	4279.0
2009-10-01 07:10:00	SPY	ETF	105.18	105.2	105.17	105.18	29000.0
2009-10-01 07:15:00	SPY	ETF	105.2	105.2	105.18	105.18	14300.0
2009-10-01 07:20:00	SPY	ETF	105.17	105.26	105.16	105.21	31222.0
2009-10-01 07:25:00	SPY	ETF	105.23	105.28	105.2	105.21	42850.0
2009-10-01 07:30:00	SPY	ETF	105.21	105.28	105.16	105.17	33159.0
2009-10-01 07:35:00	SPY	ETF	105.2	105.2	105.19	105.19	600.0
2009-10-01 07:40:00	SPY	ETF	105.29	105.3	105.21	105.21	18000.0
2009-10-01 07:45:00	SPY	ETF	105.18	105.21	105.12	105.16	31700.0
2009-10-01 07:50:00	SPY	ETF	105.18	105.18	105.12	105.12	11588.0
2009-10-01 07:55:00	SPY	ETF	105.13	105.18	105.13	105.18	10112.0
2009-10-01 08:00:00	SPY	ETF	105.2	105.3	105.12	105.25	455098.0
2009-10-01 08:05:00	SPY	ETF	105.26	105.26	105.22	105.24	75785.0
2009-10-01 08:10:00	SPY	ETF	105.24	105.26	105.15	105.17	149987.0
2009-10-01 08:15:00	SPY	ETF	105.17	105.23	105.14	105.21	64969.0
2009-10-01 08:20:00	SPY	ETF	105.22	105.3	105.2	105.3	148906.0
2009-10-01 08:25:00	SPY	ETF	105.3	105.35	105.27	105.3	462544.0
2009-10-01 08:30:00	SPY	ETF	105.28	105.37	104.98	105.11	1673439.0
2009-10-01 08:35:00	SPY	ETF	105.12	105.34	105.11	105.3	267688.0
2009-10-01 08:40:00	SPY	ETF	105.29	105.31	105.21	105.31	372639.0
2009-10-01 08:45:00	SPY	ETF	105.3	105.49	105.29	105.46	338179.0
2009-10-01 08:50:00	SPY	ETF	105.46	105.47	105.41	105.45	315261.0
2009-10-01 08:55:00	SPY	ETF	105.46	105.47	105.32	105.42	971908.0
2009-10-01 09:00:00	SPY	ETF	105.43	105.46	105.32	105.37	183035.0
2009-10-01 09:05:00	SPY	ETF	105.38	105.38	104.85	105.34	2612893.0
2009-10-01 09:10:00	SPY	ETF	105.34	105.41	105.3	105.36	1324859.0
2009-10-01 09:15:00	SPY	ETF	105.36	105.37	105.28	105.32	200951.0
2009-10-01 09:20:00	SPY	ETF	105.32	105.33	105.24	105.28	97910.0
2009-10-01 09:25:00	SPY	ETF	105.29	105.56	105.23	105.33	1065514.0
2009-10-01 09:30:00	SPY	ETF	105.34	105.37	105.07	105.11	6480423.0

> showing 50 of 31,856 rows — these rows as CSV

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