PREVIEW / etf_1min / 2009-09-24

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-09-24.parquet
  size:    1.8 MB
  rows:    97,386

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-09-24 04:15:00	SPY	ETF	105.87	105.88	105.87	105.88	2100.0
2009-09-24 04:16:00	SPY	ETF	105.9	105.9	105.9	105.9	2500.0
2009-09-24 04:19:00	SPY	ETF	105.88	105.88	105.88	105.88	1700.0
2009-09-24 04:23:00	SPY	ETF	105.83	105.83	105.83	105.83	100.0
2009-09-24 04:25:00	SPY	ETF	105.82	105.82	105.82	105.82	100.0
2009-09-24 04:43:00	SPY	ETF	105.95	105.95	105.95	105.95	207.0
2009-09-24 04:50:00	SPY	ETF	106.0	106.0	106.0	106.0	100.0
2009-09-24 04:54:00	SPY	ETF	106.05	106.05	106.05	106.05	376.0
2009-09-24 05:04:00	SPY	ETF	106.11	106.11	106.11	106.11	700.0
2009-09-24 05:42:00	SPY	ETF	106.28	106.28	106.28	106.28	2000.0
2009-09-24 05:53:00	SPY	ETF	106.47	106.47	106.47	106.47	100.0
2009-09-24 05:57:00	SPY	ETF	106.42	106.42	106.42	106.42	1500.0
2009-09-24 05:58:00	SPY	ETF	106.49	106.5	106.49	106.5	200.0
2009-09-24 06:02:00	SPY	ETF	106.4	106.4	106.4	106.4	300.0
2009-09-24 06:14:00	SPY	ETF	106.41	106.41	106.41	106.41	100.0
2009-09-24 06:30:00	SPY	ETF	106.32	106.32	106.32	106.32	200.0
2009-09-24 06:34:00	SPY	ETF	106.39	106.39	106.39	106.39	100.0
2009-09-24 06:36:00	SPY	ETF	106.39	106.39	106.39	106.39	100.0
2009-09-24 06:40:00	SPY	ETF	106.39	106.39	106.39	106.39	5000.0
2009-09-24 06:42:00	SPY	ETF	106.37	106.37	106.37	106.37	2500.0
2009-09-24 06:45:00	SPY	ETF	106.37	106.37	106.35	106.35	3000.0
2009-09-24 06:47:00	SPY	ETF	106.31	106.31	106.31	106.31	200.0
2009-09-24 06:54:00	SPY	ETF	106.32	106.32	106.32	106.32	199.0
2009-09-24 06:56:00	SPY	ETF	106.31	106.31	106.21	106.21	1600.0
2009-09-24 06:57:00	SPY	ETF	106.19	106.19	106.14	106.14	4100.0
2009-09-24 06:59:00	SPY	ETF	106.11	106.11	106.11	106.11	200.0
2009-09-24 07:01:00	SPY	ETF	106.12	106.14	106.12	106.14	3697.0
2009-09-24 07:02:00	SPY	ETF	106.16	106.16	106.16	106.16	400.0
2009-09-24 07:03:00	SPY	ETF	106.14	106.14	106.13	106.13	600.0
2009-09-24 07:04:00	SPY	ETF	106.14	106.14	106.14	106.14	2000.0
2009-09-24 07:05:00	SPY	ETF	106.14	106.14	106.14	106.14	1200.0
2009-09-24 07:06:00	SPY	ETF	106.16	106.16	106.16	106.16	2401.0
2009-09-24 07:07:00	SPY	ETF	106.16	106.16	106.16	106.16	2000.0
2009-09-24 07:08:00	SPY	ETF	106.18	106.18	106.18	106.18	2502.0
2009-09-24 07:09:00	SPY	ETF	106.19	106.19	106.18	106.18	5500.0
2009-09-24 07:11:00	SPY	ETF	106.16	106.16	106.16	106.16	3102.0
2009-09-24 07:12:00	SPY	ETF	106.16	106.16	106.14	106.14	1300.0
2009-09-24 07:13:00	SPY	ETF	106.14	106.14	106.14	106.14	1200.0
2009-09-24 07:14:00	SPY	ETF	106.16	106.18	106.16	106.18	5372.0
2009-09-24 07:15:00	SPY	ETF	106.18	106.18	106.18	106.18	2502.0
2009-09-24 07:16:00	SPY	ETF	106.15	106.15	106.15	106.15	200.0
2009-09-24 07:17:00	SPY	ETF	106.18	106.21	106.18	106.21	9301.0
2009-09-24 07:19:00	SPY	ETF	106.21	106.23	106.21	106.21	12399.0
2009-09-24 07:20:00	SPY	ETF	106.24	106.24	106.24	106.24	5000.0
2009-09-24 07:22:00	SPY	ETF	106.24	106.24	106.24	106.24	2700.0
2009-09-24 07:23:00	SPY	ETF	106.22	106.22	106.2	106.2	1200.0
2009-09-24 07:24:00	SPY	ETF	106.26	106.26	106.26	106.26	1813.0
2009-09-24 07:25:00	SPY	ETF	106.31	106.31	106.31	106.31	4502.0
2009-09-24 07:26:00	SPY	ETF	106.31	106.31	106.31	106.31	2050.0
2009-09-24 07:30:00	SPY	ETF	106.35	106.36	106.35	106.36	1500.0

> showing 50 of 97,386 rows — these rows as CSV

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