PREVIEW / etf_1min / 2011-06-16

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-06-16.parquet
  size:    2.1 MB
  rows:    110,242

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-06-16 04:00:00	SPY	ETF	127.0	127.0	127.0	127.0	4950.0
2011-06-16 04:01:00	SPY	ETF	127.16	127.16	127.16	127.16	600.0
2011-06-16 04:02:00	SPY	ETF	127.16	127.16	127.16	127.16	1600.0
2011-06-16 04:04:00	SPY	ETF	127.16	127.16	127.16	127.16	1000.0
2011-06-16 04:05:00	SPY	ETF	127.2	127.2	127.2	127.2	300.0
2011-06-16 04:09:00	SPY	ETF	127.29	127.29	127.29	127.29	3500.0
2011-06-16 04:16:00	SPY	ETF	127.3	127.34	127.3	127.34	1500.0
2011-06-16 04:19:00	SPY	ETF	127.37	127.37	127.37	127.37	700.0
2011-06-16 04:20:00	SPY	ETF	127.33	127.33	127.33	127.33	100.0
2011-06-16 04:22:00	SPY	ETF	127.37	127.37	127.37	127.37	500.0
2011-06-16 04:25:00	SPY	ETF	127.44	127.46	127.42	127.46	1554.0
2011-06-16 04:29:00	SPY	ETF	127.43	127.43	127.43	127.43	200.0
2011-06-16 04:36:00	SPY	ETF	127.43	127.43	127.43	127.43	448.0
2011-06-16 04:46:00	SPY	ETF	127.4	127.4	127.4	127.4	100.0
2011-06-16 04:55:00	SPY	ETF	127.35	127.35	127.35	127.35	500.0
2011-06-16 05:05:00	SPY	ETF	127.1	127.1	127.1	127.1	2500.0
2011-06-16 05:10:00	SPY	ETF	127.1	127.1	127.1	127.1	100.0
2011-06-16 05:11:00	SPY	ETF	127.05	127.05	127.05	127.05	200.0
2011-06-16 05:17:00	SPY	ETF	127.03	127.03	127.02	127.02	300.0
2011-06-16 05:20:00	SPY	ETF	126.9	126.9	126.9	126.9	1000.0
2011-06-16 05:24:00	SPY	ETF	126.95	126.95	126.95	126.95	500.0
2011-06-16 05:25:00	SPY	ETF	126.93	126.93	126.93	126.93	100.0
2011-06-16 05:27:00	SPY	ETF	126.96	126.96	126.96	126.96	100.0
2011-06-16 05:28:00	SPY	ETF	126.96	126.96	126.96	126.96	300.0
2011-06-16 05:33:00	SPY	ETF	126.85	126.85	126.85	126.85	1400.0
2011-06-16 05:34:00	SPY	ETF	126.85	126.85	126.85	126.85	3500.0
2011-06-16 05:35:00	SPY	ETF	126.85	126.85	126.85	126.85	100.0
2011-06-16 05:36:00	SPY	ETF	126.78	126.78	126.76	126.76	1000.0
2011-06-16 05:38:00	SPY	ETF	126.76	126.76	126.76	126.76	1000.0
2011-06-16 05:43:00	SPY	ETF	126.85	126.85	126.85	126.85	300.0
2011-06-16 05:45:00	SPY	ETF	126.88	126.88	126.88	126.88	100.0
2011-06-16 05:54:00	SPY	ETF	127.12	127.12	127.11	127.11	600.0
2011-06-16 05:59:00	SPY	ETF	126.95	126.95	126.95	126.95	200.0
2011-06-16 06:03:00	SPY	ETF	126.92	126.92	126.92	126.92	200.0
2011-06-16 06:05:00	SPY	ETF	126.85	126.85	126.85	126.85	200.0
2011-06-16 06:06:00	SPY	ETF	126.85	126.85	126.85	126.85	300.0
2011-06-16 06:16:00	SPY	ETF	126.85	126.93	126.85	126.93	10000.0
2011-06-16 06:21:00	SPY	ETF	126.84	126.88	126.84	126.88	1000.0
2011-06-16 06:22:00	SPY	ETF	126.85	126.97	126.85	126.97	4300.0
2011-06-16 06:27:00	SPY	ETF	126.95	126.95	126.95	126.95	100.0
2011-06-16 06:28:00	SPY	ETF	126.95	126.95	126.95	126.95	500.0
2011-06-16 06:30:00	SPY	ETF	126.9	126.9	126.84	126.84	800.0
2011-06-16 06:31:00	SPY	ETF	126.9	126.9	126.9	126.9	500.0
2011-06-16 06:32:00	SPY	ETF	126.87	126.95	126.87	126.9	5205.0
2011-06-16 06:33:00	SPY	ETF	126.89	126.89	126.89	126.89	3800.0
2011-06-16 06:35:00	SPY	ETF	126.85	126.88	126.82	126.88	8200.0
2011-06-16 06:36:00	SPY	ETF	126.9	126.9	126.9	126.9	100.0
2011-06-16 06:37:00	SPY	ETF	126.97	126.97	126.97	126.97	100.0
2011-06-16 06:38:00	SPY	ETF	127.04	127.04	127.04	127.04	400.0
2011-06-16 06:41:00	SPY	ETF	127.0	127.0	127.0	127.0	200.0

> showing 50 of 110,242 rows — these rows as CSV

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