PREVIEW / etf_1min / 2007-08-23

all etf 1-min files

  file:    by_date/etf_1min/2007/2007-08-23.parquet
  size:    746 KB
  rows:    49,171

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
2007-08-23 04:08:00	SPY	ETF	147.87	147.87	147.87	147.87	700.0
2007-08-23 04:53:00	SPY	ETF	147.7	147.7	147.7	147.7	1000.0
2007-08-23 05:02:00	SPY	ETF	147.77	147.77	147.77	147.77	1000.0
2007-08-23 05:53:00	SPY	ETF	148.0	148.0	148.0	148.0	1100.0
2007-08-23 06:08:00	SPY	ETF	148.05	148.05	147.99	147.99	900.0
2007-08-23 06:18:00	SPY	ETF	148.0	148.0	148.0	148.0	25000.0
2007-08-23 06:33:00	SPY	ETF	148.03	148.04	148.03	148.04	900.0
2007-08-23 06:37:00	SPY	ETF	148.03	148.03	148.03	148.03	500.0
2007-08-23 06:39:00	SPY	ETF	148.03	148.03	148.03	148.03	2500.0
2007-08-23 06:40:00	SPY	ETF	148.0	148.0	148.0	148.0	500.0
2007-08-23 06:46:00	SPY	ETF	147.89	147.89	147.89	147.89	1400.0
2007-08-23 06:48:00	SPY	ETF	147.87	147.92	147.85	147.92	1100.0
2007-08-23 06:54:00	SPY	ETF	147.89	147.89	147.89	147.89	1000.0
2007-08-23 06:56:00	SPY	ETF	147.89	147.89	147.89	147.89	2500.0
2007-08-23 07:00:00	SPY	ETF	147.88	147.88	147.88	147.88	2000.0
2007-08-23 07:01:00	SPY	ETF	147.88	147.88	147.88	147.88	27500.0
2007-08-23 07:02:00	SPY	ETF	147.84	147.89	147.84	147.89	6800.0
2007-08-23 07:03:00	SPY	ETF	147.87	147.89	147.87	147.89	4200.0
2007-08-23 07:04:00	SPY	ETF	147.89	147.89	147.84	147.84	104200.0
2007-08-23 07:05:00	SPY	ETF	147.83	147.83	147.82	147.82	10000.0
2007-08-23 07:06:00	SPY	ETF	147.82	147.82	147.82	147.82	1100.0
2007-08-23 07:07:00	SPY	ETF	147.82	147.84	147.82	147.84	3700.0
2007-08-23 07:08:00	SPY	ETF	147.85	147.9	147.85	147.89	30000.0
2007-08-23 07:09:00	SPY	ETF	147.84	147.87	147.84	147.87	18000.0
2007-08-23 07:10:00	SPY	ETF	147.84	147.84	147.82	147.82	50400.0
2007-08-23 07:11:00	SPY	ETF	147.83	147.87	147.8	147.87	6600.0
2007-08-23 07:12:00	SPY	ETF	147.84	147.84	147.83	147.83	2500.0
2007-08-23 07:13:00	SPY	ETF	147.84	147.86	147.84	147.86	4500.0
2007-08-23 07:14:00	SPY	ETF	147.87	147.9	147.87	147.9	2400.0
2007-08-23 07:15:00	SPY	ETF	147.88	147.9	147.88	147.9	800.0
2007-08-23 07:16:00	SPY	ETF	147.9	147.91	147.9	147.91	600.0
2007-08-23 07:17:00	SPY	ETF	147.93	147.98	147.93	147.96	36900.0
2007-08-23 07:19:00	SPY	ETF	147.97	147.97	147.95	147.96	4600.0
2007-08-23 07:20:00	SPY	ETF	147.95	147.99	147.95	147.99	25200.0
2007-08-23 07:21:00	SPY	ETF	148.0	148.0	147.99	148.0	53200.0
2007-08-23 07:22:00	SPY	ETF	147.98	148.02	147.98	148.0	36100.0
2007-08-23 07:23:00	SPY	ETF	148.0	148.0	147.98	147.99	15200.0
2007-08-23 07:25:00	SPY	ETF	147.94	147.99	147.94	147.99	35000.0
2007-08-23 07:26:00	SPY	ETF	147.94	147.98	147.94	147.98	10000.0
2007-08-23 07:27:00	SPY	ETF	147.96	148.02	147.96	147.98	25400.0
2007-08-23 07:28:00	SPY	ETF	148.0	148.02	148.0	148.02	20000.0
2007-08-23 07:29:00	SPY	ETF	147.97	147.99	147.97	147.97	6400.0
2007-08-23 07:30:00	SPY	ETF	148.0	148.0	147.97	147.99	20300.0
2007-08-23 07:31:00	SPY	ETF	148.01	148.02	147.99	148.0	16800.0
2007-08-23 07:32:00	SPY	ETF	148.0	148.03	148.0	148.02	29600.0
2007-08-23 07:34:00	SPY	ETF	148.03	148.03	148.03	148.03	6900.0
2007-08-23 07:35:00	SPY	ETF	148.0	148.0	147.99	147.99	16000.0
2007-08-23 07:36:00	SPY	ETF	147.99	148.01	147.99	148.01	3200.0
2007-08-23 07:37:00	SPY	ETF	148.01	148.02	148.0	148.0	22700.0
2007-08-23 07:38:00	SPY	ETF	148.0	148.0	148.0	148.0	100.0

> showing 50 of 49,171 rows — these rows as CSV

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