PREVIEW / etf_1min / 2008-07-31

all etf 1-min files

  file:    by_date/etf_1min/2008/2008-07-31.parquet
  size:    1.1 MB
  rows:    72,892

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
2008-07-31 04:15:00	SPY	ETF	128.25	128.25	128.25	128.25	200.0
2008-07-31 04:39:00	SPY	ETF	128.26	128.26	128.26	128.26	7383.0
2008-07-31 05:14:00	SPY	ETF	128.29	128.29	128.29	128.29	7500.0
2008-07-31 05:21:00	SPY	ETF	128.29	128.29	128.29	128.29	100.0
2008-07-31 05:55:00	SPY	ETF	128.26	128.28	128.26	128.28	10000.0
2008-07-31 05:56:00	SPY	ETF	128.3	128.3	128.3	128.3	5000.0
2008-07-31 06:26:00	SPY	ETF	128.37	128.49	128.37	128.49	10300.0
2008-07-31 06:53:00	SPY	ETF	128.58	128.58	128.58	128.58	1000.0
2008-07-31 06:55:00	SPY	ETF	128.55	128.55	128.55	128.55	1000.0
2008-07-31 07:00:00	SPY	ETF	128.47	128.47	128.47	128.47	7500.0
2008-07-31 07:02:00	SPY	ETF	128.54	128.58	128.54	128.58	300.0
2008-07-31 07:03:00	SPY	ETF	128.55	128.55	128.55	128.55	5000.0
2008-07-31 07:04:00	SPY	ETF	128.6	128.6	128.6	128.6	20000.0
2008-07-31 07:09:00	SPY	ETF	128.63	128.63	128.63	128.63	200.0
2008-07-31 07:10:00	SPY	ETF	128.65	128.68	128.65	128.67	50100.0
2008-07-31 07:11:00	SPY	ETF	128.69	128.69	128.69	128.69	100.0
2008-07-31 07:12:00	SPY	ETF	128.67	128.7	128.67	128.7	25300.0
2008-07-31 07:15:00	SPY	ETF	128.69	128.74	128.69	128.74	165000.0
2008-07-31 07:16:00	SPY	ETF	128.74	128.75	128.74	128.75	44948.0
2008-07-31 07:17:00	SPY	ETF	128.79	128.8	128.76	128.79	185000.0
2008-07-31 07:18:00	SPY	ETF	128.78	128.78	128.78	128.78	25000.0
2008-07-31 07:19:00	SPY	ETF	128.75	128.8	128.75	128.8	2600.0
2008-07-31 07:20:00	SPY	ETF	128.81	128.83	128.77	128.77	51200.0
2008-07-31 07:23:00	SPY	ETF	128.75	128.75	128.75	128.75	17500.0
2008-07-31 07:24:00	SPY	ETF	128.75	128.75	128.75	128.75	82500.0
2008-07-31 07:25:00	SPY	ETF	128.76	128.77	128.76	128.77	8900.0
2008-07-31 07:27:00	SPY	ETF	128.78	128.78	128.78	128.78	1000.0
2008-07-31 07:28:00	SPY	ETF	128.76	128.76	128.76	128.76	205.0
2008-07-31 07:33:00	SPY	ETF	128.75	128.75	128.75	128.75	1000.0
2008-07-31 07:35:00	SPY	ETF	128.75	128.75	128.75	128.75	8000.0
2008-07-31 07:36:00	SPY	ETF	128.71	128.71	128.71	128.71	16000.0
2008-07-31 07:37:00	SPY	ETF	128.71	128.78	128.71	128.78	35205.0
2008-07-31 07:38:00	SPY	ETF	128.79	128.79	128.79	128.79	21200.0
2008-07-31 07:39:00	SPY	ETF	128.79	128.8	128.79	128.8	130500.0
2008-07-31 07:40:00	SPY	ETF	128.79	128.79	128.75	128.75	12952.0
2008-07-31 07:41:00	SPY	ETF	128.76	128.76	128.76	128.76	200.0
2008-07-31 07:42:00	SPY	ETF	128.77	128.78	128.77	128.78	79300.0
2008-07-31 07:43:00	SPY	ETF	128.79	128.83	128.78	128.78	80400.0
2008-07-31 07:45:00	SPY	ETF	128.79	128.79	128.79	128.79	1000.0
2008-07-31 07:46:00	SPY	ETF	128.81	128.81	128.81	128.81	1000.0
2008-07-31 07:47:00	SPY	ETF	128.78	128.78	128.78	128.78	700.0
2008-07-31 07:48:00	SPY	ETF	128.78	128.78	128.75	128.75	31049.0
2008-07-31 07:49:00	SPY	ETF	128.77	128.77	128.77	128.77	5000.0
2008-07-31 07:54:00	SPY	ETF	128.81	128.83	128.79	128.83	23000.0
2008-07-31 07:55:00	SPY	ETF	128.83	128.83	128.83	128.83	7370.0
2008-07-31 07:56:00	SPY	ETF	128.84	128.84	128.84	128.84	11870.0
2008-07-31 07:57:00	SPY	ETF	128.84	128.84	128.83	128.83	26851.0
2008-07-31 07:58:00	SPY	ETF	128.82	128.85	128.82	128.85	5600.0
2008-07-31 07:59:00	SPY	ETF	128.85	128.88	128.8	128.83	22946.0
2008-07-31 08:00:00	SPY	ETF	128.85	128.85	128.65	128.67	28688.0

> showing 50 of 72,892 rows — these rows as CSV

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