PREVIEW / etf_1min / 2009-07-28

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-07-28.parquet
  size:    1.7 MB
  rows:    92,897

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-07-28 04:05:00	SPY	ETF	98.45	98.45	98.45	98.45	600.0
2009-07-28 04:16:00	SPY	ETF	98.35	98.35	98.35	98.35	100.0
2009-07-28 04:19:00	SPY	ETF	98.33	98.33	98.33	98.33	5100.0
2009-07-28 04:22:00	SPY	ETF	98.38	98.38	98.38	98.38	500.0
2009-07-28 04:30:00	SPY	ETF	98.33	98.33	98.33	98.33	6700.0
2009-07-28 04:31:00	SPY	ETF	98.34	98.34	98.34	98.34	2100.0
2009-07-28 04:35:00	SPY	ETF	98.31	98.31	98.3	98.3	2600.0
2009-07-28 04:46:00	SPY	ETF	98.29	98.29	98.29	98.29	2500.0
2009-07-28 04:47:00	SPY	ETF	98.3	98.3	98.3	98.3	1000.0
2009-07-28 04:48:00	SPY	ETF	98.26	98.26	98.26	98.26	2500.0
2009-07-28 04:49:00	SPY	ETF	98.24	98.24	98.24	98.24	1000.0
2009-07-28 04:54:00	SPY	ETF	98.3	98.3	98.3	98.3	100.0
2009-07-28 04:58:00	SPY	ETF	98.2	98.2	98.2	98.2	100.0
2009-07-28 04:59:00	SPY	ETF	98.24	98.24	98.24	98.24	2800.0
2009-07-28 05:09:00	SPY	ETF	98.3	98.3	98.3	98.3	1000.0
2009-07-28 05:17:00	SPY	ETF	98.24	98.24	98.24	98.24	500.0
2009-07-28 05:19:00	SPY	ETF	98.24	98.24	98.24	98.24	500.0
2009-07-28 05:23:00	SPY	ETF	98.2	98.2	98.2	98.2	1500.0
2009-07-28 05:24:00	SPY	ETF	98.17	98.17	98.17	98.17	2100.0
2009-07-28 05:31:00	SPY	ETF	98.06	98.08	98.06	98.08	9600.0
2009-07-28 05:36:00	SPY	ETF	98.14	98.14	98.14	98.14	4000.0
2009-07-28 05:57:00	SPY	ETF	98.17	98.17	98.17	98.17	1500.0
2009-07-28 06:11:00	SPY	ETF	98.16	98.16	98.16	98.16	5300.0
2009-07-28 06:18:00	SPY	ETF	98.22	98.22	98.22	98.22	500.0
2009-07-28 06:28:00	SPY	ETF	98.21	98.21	98.21	98.21	100.0
2009-07-28 06:31:00	SPY	ETF	98.25	98.25	98.25	98.25	5000.0
2009-07-28 06:32:00	SPY	ETF	98.18	98.18	98.18	98.18	2500.0
2009-07-28 06:33:00	SPY	ETF	98.2	98.2	98.2	98.2	2500.0
2009-07-28 06:34:00	SPY	ETF	98.2	98.2	98.2	98.2	2500.0
2009-07-28 06:37:00	SPY	ETF	98.15	98.15	98.15	98.15	1500.0
2009-07-28 06:44:00	SPY	ETF	98.0	98.0	98.0	98.0	2000.0
2009-07-28 06:53:00	SPY	ETF	97.96	97.98	97.96	97.98	1500.0
2009-07-28 07:00:00	SPY	ETF	98.03	98.03	98.03	98.03	300.0
2009-07-28 07:01:00	SPY	ETF	98.05	98.05	98.05	98.05	15000.0
2009-07-28 07:04:00	SPY	ETF	98.05	98.05	98.05	98.05	1000.0
2009-07-28 07:05:00	SPY	ETF	98.0	98.0	98.0	98.0	1500.0
2009-07-28 07:08:00	SPY	ETF	98.0	98.0	98.0	98.0	15000.0
2009-07-28 07:12:00	SPY	ETF	98.02	98.02	98.0	98.0	9000.0
2009-07-28 07:15:00	SPY	ETF	98.01	98.02	98.01	98.02	5100.0
2009-07-28 07:16:00	SPY	ETF	98.04	98.04	98.04	98.04	200.0
2009-07-28 07:17:00	SPY	ETF	98.01	98.01	97.98	98.0	18900.0
2009-07-28 07:18:00	SPY	ETF	98.02	98.02	98.02	98.02	100.0
2009-07-28 07:19:00	SPY	ETF	98.01	98.01	98.0	98.0	400.0
2009-07-28 07:20:00	SPY	ETF	97.97	97.97	97.9	97.9	28600.0
2009-07-28 07:21:00	SPY	ETF	97.91	97.94	97.91	97.94	2300.0
2009-07-28 07:22:00	SPY	ETF	97.95	97.95	97.95	97.95	8415.0
2009-07-28 07:23:00	SPY	ETF	97.96	97.96	97.96	97.96	1000.0
2009-07-28 07:24:00	SPY	ETF	97.93	97.95	97.93	97.95	400.0
2009-07-28 07:25:00	SPY	ETF	97.93	97.94	97.93	97.94	10500.0
2009-07-28 07:26:00	SPY	ETF	97.95	97.95	97.95	97.95	4700.0

> showing 50 of 92,897 rows — these rows as CSV

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