PREVIEW / etf_1min / 2011-01-12

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-01-12.parquet
  size:    2.0 MB
  rows:    105,991

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
2011-01-12 04:00:00	SPY	ETF	127.92	128.05	127.92	128.05	2800.0
2011-01-12 04:01:00	SPY	ETF	128.03	128.03	128.03	128.03	100.0
2011-01-12 04:10:00	SPY	ETF	128.09	128.1	128.09	128.1	3000.0
2011-01-12 04:14:00	SPY	ETF	128.05	128.05	128.05	128.05	100.0
2011-01-12 04:23:00	SPY	ETF	128.11	128.11	128.11	128.11	600.0
2011-01-12 04:25:00	SPY	ETF	128.14	128.14	128.14	128.14	1000.0
2011-01-12 04:41:00	SPY	ETF	128.25	128.29	128.25	128.29	21000.0
2011-01-12 04:50:00	SPY	ETF	128.25	128.25	128.25	128.25	100.0
2011-01-12 04:57:00	SPY	ETF	128.33	128.33	128.33	128.33	200.0
2011-01-12 05:00:00	SPY	ETF	128.35	128.36	128.35	128.36	2000.0
2011-01-12 05:12:00	SPY	ETF	128.3	128.3	128.3	128.3	100.0
2011-01-12 05:29:00	SPY	ETF	128.23	128.23	128.23	128.23	100.0
2011-01-12 05:41:00	SPY	ETF	128.24	128.24	128.24	128.24	2500.0
2011-01-12 05:45:00	SPY	ETF	128.21	128.21	128.21	128.21	200.0
2011-01-12 05:58:00	SPY	ETF	128.17	128.17	128.17	128.17	200.0
2011-01-12 06:16:00	SPY	ETF	128.12	128.12	128.12	128.12	500.0
2011-01-12 06:17:00	SPY	ETF	128.19	128.19	128.19	128.19	250.0
2011-01-12 06:19:00	SPY	ETF	128.2	128.2	128.2	128.2	500.0
2011-01-12 06:31:00	SPY	ETF	128.14	128.14	128.14	128.14	1500.0
2011-01-12 06:32:00	SPY	ETF	128.18	128.18	128.18	128.18	100.0
2011-01-12 06:34:00	SPY	ETF	128.11	128.11	128.0	128.0	400.0
2011-01-12 06:38:00	SPY	ETF	128.12	128.12	128.11	128.11	41000.0
2011-01-12 06:39:00	SPY	ETF	128.1	128.1	128.1	128.1	2400.0
2011-01-12 06:40:00	SPY	ETF	128.12	128.12	128.12	128.12	7000.0
2011-01-12 06:43:00	SPY	ETF	128.12	128.12	128.12	128.12	500.0
2011-01-12 06:44:00	SPY	ETF	128.15	128.15	128.15	128.15	100.0
2011-01-12 06:46:00	SPY	ETF	128.17	128.17	128.17	128.17	100.0
2011-01-12 06:49:00	SPY	ETF	128.16	128.16	128.16	128.16	5000.0
2011-01-12 06:53:00	SPY	ETF	128.12	128.12	128.1	128.1	200.0
2011-01-12 06:56:00	SPY	ETF	128.12	128.12	128.12	128.12	200.0
2011-01-12 07:00:00	SPY	ETF	128.16	128.16	128.15	128.16	41500.0
2011-01-12 07:01:00	SPY	ETF	128.16	128.16	128.15	128.15	1800.0
2011-01-12 07:02:00	SPY	ETF	128.16	128.18	128.16	128.18	4250.0
2011-01-12 07:03:00	SPY	ETF	128.16	128.16	128.15	128.15	5250.0
2011-01-12 07:04:00	SPY	ETF	128.15	128.15	128.12	128.12	2200.0
2011-01-12 07:05:00	SPY	ETF	128.13	128.13	128.13	128.13	100.0
2011-01-12 07:06:00	SPY	ETF	128.15	128.15	128.15	128.15	200.0
2011-01-12 07:07:00	SPY	ETF	128.18	128.2	128.18	128.2	1400.0
2011-01-12 07:08:00	SPY	ETF	128.18	128.18	128.18	128.18	5024.0
2011-01-12 07:09:00	SPY	ETF	128.18	128.18	128.18	128.18	10100.0
2011-01-12 07:10:00	SPY	ETF	128.16	128.16	128.16	128.16	500.0
2011-01-12 07:12:00	SPY	ETF	128.15	128.15	128.15	128.15	1000.0
2011-01-12 07:15:00	SPY	ETF	128.16	128.16	128.14	128.14	8500.0
2011-01-12 07:16:00	SPY	ETF	128.1	128.11	128.1	128.11	400.0
2011-01-12 07:17:00	SPY	ETF	128.1	128.1	128.1	128.1	1200.0
2011-01-12 07:19:00	SPY	ETF	128.1	128.1	128.1	128.1	10000.0
2011-01-12 07:21:00	SPY	ETF	128.11	128.13	128.1	128.1	2700.0
2011-01-12 07:22:00	SPY	ETF	128.16	128.16	128.16	128.16	5000.0
2011-01-12 07:23:00	SPY	ETF	128.12	128.12	128.12	128.12	2500.0
2011-01-12 07:26:00	SPY	ETF	128.12	128.12	128.12	128.12	100.0

> showing 50 of 105,991 rows — these rows as CSV

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