PREVIEW / etf_1min / 2009-09-04

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-09-04.parquet
  size:    1.6 MB
  rows:    85,615

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-04 04:15:00	SPY	ETF	100.94	100.94	100.94	100.94	1400.0
2009-09-04 04:27:00	SPY	ETF	101.01	101.01	101.01	101.01	200.0
2009-09-04 04:29:00	SPY	ETF	100.98	100.98	100.98	100.98	100.0
2009-09-04 04:30:00	SPY	ETF	100.98	100.98	100.98	100.98	100.0
2009-09-04 04:31:00	SPY	ETF	100.98	100.98	100.98	100.98	100.0
2009-09-04 04:32:00	SPY	ETF	100.98	100.98	100.98	100.98	100.0
2009-09-04 04:41:00	SPY	ETF	101.03	101.03	101.03	101.03	300.0
2009-09-04 04:54:00	SPY	ETF	101.08	101.08	101.08	101.08	100.0
2009-09-04 05:00:00	SPY	ETF	101.1	101.1	101.1	101.1	190.0
2009-09-04 05:03:00	SPY	ETF	101.11	101.12	101.11	101.12	700.0
2009-09-04 05:04:00	SPY	ETF	101.16	101.16	101.16	101.16	200.0
2009-09-04 05:27:00	SPY	ETF	101.06	101.06	101.06	101.06	100.0
2009-09-04 05:46:00	SPY	ETF	101.03	101.03	101.03	101.03	200.0
2009-09-04 05:49:00	SPY	ETF	101.0	101.0	101.0	101.0	1000.0
2009-09-04 06:00:00	SPY	ETF	100.9	100.9	100.9	100.9	400.0
2009-09-04 06:42:00	SPY	ETF	100.91	100.91	100.91	100.91	10000.0
2009-09-04 06:47:00	SPY	ETF	100.91	100.91	100.91	100.91	100.0
2009-09-04 06:49:00	SPY	ETF	100.91	100.91	100.91	100.91	450.0
2009-09-04 06:52:00	SPY	ETF	100.91	100.91	100.91	100.91	100.0
2009-09-04 07:00:00	SPY	ETF	100.93	101.01	100.93	101.01	3400.0
2009-09-04 07:01:00	SPY	ETF	101.01	101.08	101.01	101.08	2520.0
2009-09-04 07:02:00	SPY	ETF	101.04	101.04	101.04	101.04	2000.0
2009-09-04 07:03:00	SPY	ETF	101.04	101.04	101.04	101.04	5000.0
2009-09-04 07:04:00	SPY	ETF	101.04	101.04	101.04	101.04	1600.0
2009-09-04 07:05:00	SPY	ETF	101.05	101.05	101.05	101.05	10067.0
2009-09-04 07:06:00	SPY	ETF	101.05	101.05	101.05	101.05	2000.0
2009-09-04 07:07:00	SPY	ETF	101.04	101.04	101.04	101.04	500.0
2009-09-04 07:08:00	SPY	ETF	101.06	101.06	101.04	101.06	700.0
2009-09-04 07:09:00	SPY	ETF	101.06	101.08	101.04	101.04	49867.0
2009-09-04 07:10:00	SPY	ETF	101.04	101.04	101.04	101.04	13500.0
2009-09-04 07:11:00	SPY	ETF	101.05	101.05	101.05	101.05	12415.0
2009-09-04 07:12:00	SPY	ETF	101.04	101.05	101.04	101.05	1110.0
2009-09-04 07:13:00	SPY	ETF	101.04	101.04	101.04	101.04	209.0
2009-09-04 07:15:00	SPY	ETF	101.1	101.1	101.06	101.09	5873.0
2009-09-04 07:16:00	SPY	ETF	101.09	101.09	101.09	101.09	100.0
2009-09-04 07:17:00	SPY	ETF	101.11	101.11	101.11	101.11	10000.0
2009-09-04 07:18:00	SPY	ETF	101.12	101.12	101.12	101.12	500.0
2009-09-04 07:19:00	SPY	ETF	101.09	101.1	101.08	101.1	10706.0
2009-09-04 07:20:00	SPY	ETF	101.08	101.08	101.08	101.08	100.0
2009-09-04 07:22:00	SPY	ETF	101.08	101.08	101.04	101.04	6300.0
2009-09-04 07:23:00	SPY	ETF	101.06	101.08	101.06	101.08	25100.0
2009-09-04 07:26:00	SPY	ETF	101.06	101.06	101.06	101.06	100.0
2009-09-04 07:27:00	SPY	ETF	101.05	101.08	101.05	101.05	3650.0
2009-09-04 07:28:00	SPY	ETF	101.03	101.05	101.01	101.02	1100.0
2009-09-04 07:29:00	SPY	ETF	101.03	101.03	101.01	101.01	634.0
2009-09-04 07:30:00	SPY	ETF	100.98	100.98	100.98	100.98	100.0
2009-09-04 07:31:00	SPY	ETF	100.97	101.0	100.97	101.0	15100.0
2009-09-04 07:32:00	SPY	ETF	101.0	101.0	100.98	100.98	10200.0
2009-09-04 07:34:00	SPY	ETF	100.97	100.97	100.97	100.97	600.0
2009-09-04 07:35:00	SPY	ETF	100.98	100.98	100.97	100.97	1397.0

> showing 50 of 85,615 rows — these rows as CSV

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