PREVIEW / etf_1min / 2009-07-31

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-07-31.parquet
  size:    1.6 MB
  rows:    90,335

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-31 04:55:00	SPY	ETF	98.78	98.78	98.78	98.78	1000.0
2009-07-31 05:17:00	SPY	ETF	98.8	98.8	98.8	98.8	100.0
2009-07-31 05:19:00	SPY	ETF	98.83	98.83	98.83	98.83	100.0
2009-07-31 05:43:00	SPY	ETF	98.88	98.88	98.88	98.88	2500.0
2009-07-31 05:58:00	SPY	ETF	98.88	98.88	98.88	98.88	2480.0
2009-07-31 06:05:00	SPY	ETF	98.92	98.92	98.92	98.92	2500.0
2009-07-31 06:37:00	SPY	ETF	98.97	98.97	98.97	98.97	300.0
2009-07-31 06:43:00	SPY	ETF	99.04	99.04	99.04	99.04	100.0
2009-07-31 06:48:00	SPY	ETF	99.08	99.08	99.08	99.08	500.0
2009-07-31 06:53:00	SPY	ETF	99.09	99.09	99.09	99.09	100.0
2009-07-31 06:55:00	SPY	ETF	99.05	99.05	99.05	99.05	2500.0
2009-07-31 06:58:00	SPY	ETF	98.98	99.0	98.98	99.0	200.0
2009-07-31 06:59:00	SPY	ETF	98.93	98.96	98.93	98.96	2400.0
2009-07-31 07:00:00	SPY	ETF	99.01	99.01	99.0	99.0	1500.0
2009-07-31 07:01:00	SPY	ETF	98.99	98.99	98.96	98.99	4700.0
2009-07-31 07:02:00	SPY	ETF	99.01	99.02	99.0	99.02	29500.0
2009-07-31 07:03:00	SPY	ETF	99.02	99.02	99.0	99.0	1400.0
2009-07-31 07:04:00	SPY	ETF	99.02	99.04	99.02	99.03	2856.0
2009-07-31 07:05:00	SPY	ETF	99.05	99.09	99.05	99.05	5680.0
2009-07-31 07:06:00	SPY	ETF	99.0	99.0	99.0	99.0	2000.0
2009-07-31 07:07:00	SPY	ETF	99.04	99.04	99.04	99.04	113.0
2009-07-31 07:08:00	SPY	ETF	99.03	99.08	99.02	99.05	11200.0
2009-07-31 07:09:00	SPY	ETF	99.05	99.08	99.05	99.08	1500.0
2009-07-31 07:10:00	SPY	ETF	99.09	99.09	99.09	99.09	2100.0
2009-07-31 07:11:00	SPY	ETF	99.11	99.11	99.11	99.11	500.0
2009-07-31 07:13:00	SPY	ETF	99.08	99.1	99.08	99.1	10750.0
2009-07-31 07:15:00	SPY	ETF	99.05	99.05	99.05	99.05	500.0
2009-07-31 07:17:00	SPY	ETF	99.06	99.06	99.06	99.06	200.0
2009-07-31 07:18:00	SPY	ETF	99.06	99.06	99.06	99.06	500.0
2009-07-31 07:20:00	SPY	ETF	99.05	99.06	99.05	99.05	4300.0
2009-07-31 07:21:00	SPY	ETF	99.08	99.08	99.08	99.08	500.0
2009-07-31 07:24:00	SPY	ETF	99.08	99.1	99.07	99.1	41477.0
2009-07-31 07:25:00	SPY	ETF	99.1	99.1	99.04	99.04	85000.0
2009-07-31 07:26:00	SPY	ETF	99.02	99.06	99.02	99.06	27200.0
2009-07-31 07:27:00	SPY	ETF	99.03	99.03	99.01	99.01	8100.0
2009-07-31 07:28:00	SPY	ETF	99.01	99.02	98.99	99.02	7361.0
2009-07-31 07:29:00	SPY	ETF	99.02	99.03	98.99	99.0	7046.0
2009-07-31 07:30:00	SPY	ETF	99.0	99.01	99.0	99.0	124054.0
2009-07-31 07:31:00	SPY	ETF	98.99	98.99	98.96	98.96	50520.0
2009-07-31 07:32:00	SPY	ETF	98.99	99.0	98.96	99.0	20300.0
2009-07-31 07:34:00	SPY	ETF	98.99	98.99	98.98	98.98	15000.0
2009-07-31 07:35:00	SPY	ETF	98.98	99.0	98.98	99.0	2700.0
2009-07-31 07:36:00	SPY	ETF	98.96	98.96	98.96	98.96	100.0
2009-07-31 07:37:00	SPY	ETF	99.0	99.01	99.0	99.0	26500.0
2009-07-31 07:38:00	SPY	ETF	99.02	99.06	99.02	99.06	1959.0
2009-07-31 07:39:00	SPY	ETF	99.04	99.04	99.04	99.04	1000.0
2009-07-31 07:40:00	SPY	ETF	99.05	99.05	99.05	99.05	200.0
2009-07-31 07:41:00	SPY	ETF	99.06	99.07	99.06	99.07	2500.0
2009-07-31 07:42:00	SPY	ETF	99.05	99.05	99.05	99.05	100.0
2009-07-31 07:43:00	SPY	ETF	99.06	99.07	99.06	99.07	200.0

> showing 50 of 90,335 rows — these rows as CSV

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