PREVIEW / etf_1min / 2010-10-27

all etf 1-min files

  file:    by_date/etf_1min/2010/2010-10-27.parquet
  size:    1.8 MB
  rows:    98,715

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
2010-10-27 04:00:00	SPY	ETF	118.67	118.67	118.24	118.24	1250.0
2010-10-27 04:01:00	SPY	ETF	118.09	118.1	118.09	118.1	1375.0
2010-10-27 04:02:00	SPY	ETF	118.11	118.14	118.11	118.14	200.0
2010-10-27 04:09:00	SPY	ETF	118.06	118.06	118.06	118.06	100.0
2010-10-27 04:20:00	SPY	ETF	118.05	118.05	118.05	118.05	250.0
2010-10-27 04:31:00	SPY	ETF	118.11	118.11	118.11	118.11	500.0
2010-10-27 04:32:00	SPY	ETF	118.11	118.11	118.11	118.11	500.0
2010-10-27 04:44:00	SPY	ETF	118.1	118.14	118.08	118.08	16200.0
2010-10-27 04:52:00	SPY	ETF	118.0	118.0	117.99	117.99	1300.0
2010-10-27 04:57:00	SPY	ETF	117.99	118.01	117.99	118.01	250.0
2010-10-27 05:00:00	SPY	ETF	118.03	118.03	118.03	118.03	100.0
2010-10-27 05:10:00	SPY	ETF	118.03	118.03	118.03	118.03	100.0
2010-10-27 05:15:00	SPY	ETF	118.0	118.0	118.0	118.0	2853.0
2010-10-27 05:17:00	SPY	ETF	117.99	117.99	117.96	117.96	848.0
2010-10-27 05:20:00	SPY	ETF	117.9	117.93	117.9	117.93	3600.0
2010-10-27 05:28:00	SPY	ETF	118.0	118.0	118.0	118.0	200.0
2010-10-27 05:37:00	SPY	ETF	118.25	118.25	118.25	118.25	100.0
2010-10-27 05:38:00	SPY	ETF	118.28	118.38	118.28	118.38	2200.0
2010-10-27 05:40:00	SPY	ETF	118.33	118.33	118.33	118.33	800.0
2010-10-27 05:42:00	SPY	ETF	118.34	118.38	118.34	118.38	1000.0
2010-10-27 05:46:00	SPY	ETF	118.3	118.3	118.3	118.3	100.0
2010-10-27 05:52:00	SPY	ETF	118.38	118.38	118.38	118.38	500.0
2010-10-27 06:00:00	SPY	ETF	118.24	118.32	118.2	118.24	27200.0
2010-10-27 06:01:00	SPY	ETF	118.24	118.24	118.24	118.24	400.0
2010-10-27 06:02:00	SPY	ETF	118.23	118.23	118.23	118.23	2000.0
2010-10-27 06:03:00	SPY	ETF	118.25	118.25	118.25	118.25	25000.0
2010-10-27 06:06:00	SPY	ETF	118.23	118.23	118.23	118.23	2000.0
2010-10-27 06:08:00	SPY	ETF	118.24	118.25	118.24	118.25	5000.0
2010-10-27 06:18:00	SPY	ETF	118.28	118.28	118.28	118.28	500.0
2010-10-27 06:19:00	SPY	ETF	118.26	118.26	118.26	118.26	100.0
2010-10-27 06:25:00	SPY	ETF	118.27	118.27	118.27	118.27	1000.0
2010-10-27 06:28:00	SPY	ETF	118.25	118.25	118.25	118.25	1000.0
2010-10-27 06:34:00	SPY	ETF	118.24	118.24	118.24	118.24	900.0
2010-10-27 06:35:00	SPY	ETF	118.23	118.23	118.23	118.23	1000.0
2010-10-27 06:38:00	SPY	ETF	118.25	118.25	118.25	118.25	500.0
2010-10-27 06:39:00	SPY	ETF	118.27	118.27	118.27	118.27	5000.0
2010-10-27 06:42:00	SPY	ETF	118.24	118.24	118.24	118.24	500.0
2010-10-27 06:44:00	SPY	ETF	118.29	118.31	118.29	118.31	300.0
2010-10-27 06:47:00	SPY	ETF	118.35	118.35	118.35	118.35	900.0
2010-10-27 06:48:00	SPY	ETF	118.35	118.39	118.35	118.39	13100.0
2010-10-27 06:49:00	SPY	ETF	118.35	118.35	118.35	118.35	500.0
2010-10-27 06:50:00	SPY	ETF	118.36	118.36	118.34	118.36	550.0
2010-10-27 06:51:00	SPY	ETF	118.37	118.37	118.37	118.37	2000.0
2010-10-27 07:00:00	SPY	ETF	118.3	118.32	118.3	118.32	6000.0
2010-10-27 07:01:00	SPY	ETF	118.31	118.31	118.29	118.29	1100.0
2010-10-27 07:02:00	SPY	ETF	118.27	118.28	118.26	118.28	11300.0
2010-10-27 07:03:00	SPY	ETF	118.28	118.28	118.25	118.26	4800.0
2010-10-27 07:04:00	SPY	ETF	118.28	118.29	118.28	118.28	2100.0
2010-10-27 07:05:00	SPY	ETF	118.28	118.3	118.28	118.3	700.0
2010-10-27 07:06:00	SPY	ETF	118.29	118.32	118.29	118.32	1900.0

> showing 50 of 98,715 rows — these rows as CSV

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