PREVIEW / etf_1min / 2009-03-23

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-03-23.parquet
  size:    1.8 MB
  rows:    96,456

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-03-23 04:14:00	SPY	ETF	78.95	78.95	78.94	78.94	7500.0
2009-03-23 04:15:00	SPY	ETF	78.9	78.98	78.88	78.97	25430.0
2009-03-23 04:16:00	SPY	ETF	78.98	78.98	78.95	78.95	3640.0
2009-03-23 04:19:00	SPY	ETF	78.95	78.95	78.95	78.95	1100.0
2009-03-23 04:21:00	SPY	ETF	78.88	78.88	78.88	78.88	5000.0
2009-03-23 04:24:00	SPY	ETF	78.83	78.83	78.83	78.83	100.0
2009-03-23 04:38:00	SPY	ETF	78.75	78.75	78.75	78.75	500.0
2009-03-23 04:51:00	SPY	ETF	78.85	78.85	78.85	78.85	100.0
2009-03-23 05:04:00	SPY	ETF	78.98	78.98	78.98	78.98	330.0
2009-03-23 05:12:00	SPY	ETF	79.03	79.03	79.03	79.03	1000.0
2009-03-23 05:17:00	SPY	ETF	78.96	78.96	78.95	78.95	2500.0
2009-03-23 05:19:00	SPY	ETF	79.0	79.0	79.0	79.0	3700.0
2009-03-23 05:21:00	SPY	ETF	79.0	79.0	79.0	79.0	1300.0
2009-03-23 05:22:00	SPY	ETF	79.02	79.02	79.02	79.02	100.0
2009-03-23 05:30:00	SPY	ETF	78.87	78.87	78.85	78.85	1200.0
2009-03-23 05:36:00	SPY	ETF	78.87	78.87	78.87	78.87	300.0
2009-03-23 05:52:00	SPY	ETF	78.8	78.8	78.8	78.8	100.0
2009-03-23 05:55:00	SPY	ETF	78.83	78.83	78.83	78.83	2500.0
2009-03-23 05:56:00	SPY	ETF	78.85	78.85	78.85	78.85	100.0
2009-03-23 05:58:00	SPY	ETF	78.87	78.87	78.87	78.87	200.0
2009-03-23 06:01:00	SPY	ETF	79.0	79.0	79.0	79.0	100.0
2009-03-23 06:04:00	SPY	ETF	78.91	78.91	78.91	78.91	600.0
2009-03-23 06:06:00	SPY	ETF	78.98	78.98	78.98	78.98	100.0
2009-03-23 06:08:00	SPY	ETF	78.94	78.95	78.94	78.95	600.0
2009-03-23 06:11:00	SPY	ETF	78.88	78.88	78.88	78.88	150.0
2009-03-23 06:16:00	SPY	ETF	78.85	78.85	78.85	78.85	380.0
2009-03-23 06:22:00	SPY	ETF	78.86	78.86	78.86	78.86	416.0
2009-03-23 06:23:00	SPY	ETF	78.86	78.86	78.86	78.86	184.0
2009-03-23 06:25:00	SPY	ETF	78.86	78.86	78.86	78.86	100.0
2009-03-23 06:28:00	SPY	ETF	79.0	79.02	79.0	79.02	900.0
2009-03-23 06:29:00	SPY	ETF	79.05	79.05	79.05	79.05	2600.0
2009-03-23 06:32:00	SPY	ETF	78.99	78.99	78.99	78.99	5000.0
2009-03-23 06:35:00	SPY	ETF	79.01	79.07	79.01	79.07	1200.0
2009-03-23 06:40:00	SPY	ETF	79.11	79.11	79.11	79.11	100.0
2009-03-23 06:42:00	SPY	ETF	79.06	79.06	79.06	79.06	10000.0
2009-03-23 06:43:00	SPY	ETF	79.01	79.04	79.01	79.01	119400.0
2009-03-23 06:44:00	SPY	ETF	79.01	79.01	79.0	79.0	25000.0
2009-03-23 06:45:00	SPY	ETF	79.04	79.04	79.04	79.04	100.0
2009-03-23 06:46:00	SPY	ETF	79.11	79.11	79.11	79.11	10000.0
2009-03-23 06:47:00	SPY	ETF	79.16	79.16	79.16	79.16	100.0
2009-03-23 06:48:00	SPY	ETF	79.13	79.13	79.13	79.13	100.0
2009-03-23 06:51:00	SPY	ETF	79.07	79.07	79.07	79.07	100.0
2009-03-23 06:52:00	SPY	ETF	79.06	79.11	79.06	79.11	5100.0
2009-03-23 06:53:00	SPY	ETF	79.11	79.11	79.11	79.11	102.0
2009-03-23 06:54:00	SPY	ETF	79.05	79.05	79.05	79.05	24000.0
2009-03-23 06:55:00	SPY	ETF	79.05	79.05	79.03	79.03	63500.0
2009-03-23 06:56:00	SPY	ETF	79.07	79.07	79.07	79.07	100.0
2009-03-23 06:59:00	SPY	ETF	79.03	79.04	78.99	79.04	3300.0
2009-03-23 07:00:00	SPY	ETF	79.0	79.03	78.96	78.97	106100.0
2009-03-23 07:01:00	SPY	ETF	78.98	78.98	78.95	78.97	84468.0

> showing 50 of 96,456 rows — these rows as CSV

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