PREVIEW / etf_1min / 2010-07-09

all etf 1-min files

  file:    by_date/etf_1min/2010/2010-07-09.parquet
  size:    1.6 MB
  rows:    88,762

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-07-09 04:15:00	SPY	ETF	107.29	107.29	107.29	107.29	100.0
2010-07-09 04:35:00	SPY	ETF	107.17	107.17	107.17	107.17	300.0
2010-07-09 04:36:00	SPY	ETF	107.2	107.2	107.18	107.18	1500.0
2010-07-09 04:43:00	SPY	ETF	107.15	107.15	107.15	107.15	200.0
2010-07-09 04:46:00	SPY	ETF	107.14	107.14	107.14	107.14	200.0
2010-07-09 05:05:00	SPY	ETF	107.02	107.02	107.02	107.02	100.0
2010-07-09 05:28:00	SPY	ETF	107.15	107.15	107.15	107.15	100.0
2010-07-09 05:54:00	SPY	ETF	107.15	107.15	107.15	107.15	200.0
2010-07-09 05:57:00	SPY	ETF	107.16	107.16	107.16	107.16	200.0
2010-07-09 06:00:00	SPY	ETF	107.15	107.15	107.15	107.15	200.0
2010-07-09 06:21:00	SPY	ETF	107.22	107.22	107.22	107.22	200.0
2010-07-09 06:28:00	SPY	ETF	107.17	107.17	107.15	107.15	300.0
2010-07-09 06:36:00	SPY	ETF	107.21	107.21	107.21	107.21	200.0
2010-07-09 06:40:00	SPY	ETF	107.08	107.11	107.08	107.11	2200.0
2010-07-09 06:46:00	SPY	ETF	107.12	107.12	107.12	107.12	200.0
2010-07-09 06:48:00	SPY	ETF	107.08	107.08	107.08	107.08	1800.0
2010-07-09 06:52:00	SPY	ETF	107.1	107.1	107.08	107.08	2200.0
2010-07-09 06:56:00	SPY	ETF	107.08	107.08	107.08	107.08	400.0
2010-07-09 06:59:00	SPY	ETF	107.06	107.06	107.06	107.06	100.0
2010-07-09 07:00:00	SPY	ETF	107.06	107.06	107.06	107.06	400.0
2010-07-09 07:01:00	SPY	ETF	107.09	107.15	107.09	107.12	1374.0
2010-07-09 07:02:00	SPY	ETF	107.15	107.15	107.15	107.15	100.0
2010-07-09 07:03:00	SPY	ETF	107.25	107.25	107.25	107.25	700.0
2010-07-09 07:04:00	SPY	ETF	107.27	107.28	107.23	107.28	3800.0
2010-07-09 07:06:00	SPY	ETF	107.28	107.28	107.28	107.28	100.0
2010-07-09 07:08:00	SPY	ETF	107.32	107.35	107.32	107.35	100965.0
2010-07-09 07:09:00	SPY	ETF	107.35	107.35	107.31	107.31	10100.0
2010-07-09 07:11:00	SPY	ETF	107.31	107.31	107.31	107.31	1000.0
2010-07-09 07:13:00	SPY	ETF	107.31	107.31	107.29	107.29	4700.0
2010-07-09 07:15:00	SPY	ETF	107.3	107.32	107.3	107.32	3600.0
2010-07-09 07:16:00	SPY	ETF	107.32	107.32	107.32	107.32	100.0
2010-07-09 07:18:00	SPY	ETF	107.32	107.32	107.3	107.3	600.0
2010-07-09 07:21:00	SPY	ETF	107.31	107.31	107.31	107.31	100.0
2010-07-09 07:22:00	SPY	ETF	107.34	107.34	107.31	107.31	300.0
2010-07-09 07:23:00	SPY	ETF	107.32	107.34	107.32	107.34	500.0
2010-07-09 07:24:00	SPY	ETF	107.35	107.38	107.35	107.38	5400.0
2010-07-09 07:25:00	SPY	ETF	107.34	107.34	107.34	107.34	1500.0
2010-07-09 07:26:00	SPY	ETF	107.31	107.32	107.31	107.32	325.0
2010-07-09 07:27:00	SPY	ETF	107.31	107.31	107.28	107.29	3815.0
2010-07-09 07:28:00	SPY	ETF	107.29	107.29	107.29	107.29	1000.0
2010-07-09 07:30:00	SPY	ETF	107.27	107.27	107.24	107.24	10400.0
2010-07-09 07:31:00	SPY	ETF	107.26	107.26	107.26	107.26	300.0
2010-07-09 07:32:00	SPY	ETF	107.29	107.34	107.29	107.34	1100.0
2010-07-09 07:33:00	SPY	ETF	107.34	107.34	107.34	107.34	100.0
2010-07-09 07:38:00	SPY	ETF	107.31	107.31	107.31	107.31	200.0
2010-07-09 07:41:00	SPY	ETF	107.34	107.36	107.34	107.36	99999.0
2010-07-09 07:43:00	SPY	ETF	107.32	107.32	107.28	107.28	1000.0
2010-07-09 07:44:00	SPY	ETF	107.26	107.31	107.26	107.31	27100.0
2010-07-09 07:45:00	SPY	ETF	107.32	107.32	107.32	107.32	20112.0
2010-07-09 07:46:00	SPY	ETF	107.31	107.32	107.29	107.29	5906.0

> showing 50 of 88,762 rows — these rows as CSV

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