PREVIEW / etf_1min / 2011-08-22

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-08-22.parquet
  size:    2.2 MB
  rows:    117,483

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-08-22 04:00:00	SPY	ETF	113.5	113.95	113.5	113.95	2139.0
2011-08-22 04:05:00	SPY	ETF	113.8	113.8	113.8	113.8	311.0
2011-08-22 04:09:00	SPY	ETF	113.83	113.83	113.83	113.83	100.0
2011-08-22 04:10:00	SPY	ETF	113.83	113.83	113.83	113.83	208.0
2011-08-22 04:14:00	SPY	ETF	113.88	113.88	113.88	113.88	100.0
2011-08-22 04:15:00	SPY	ETF	114.02	114.02	114.02	114.02	300.0
2011-08-22 04:21:00	SPY	ETF	113.83	113.85	113.83	113.85	620.0
2011-08-22 04:28:00	SPY	ETF	113.7	113.7	113.7	113.7	500.0
2011-08-22 04:29:00	SPY	ETF	113.72	113.72	113.72	113.72	100.0
2011-08-22 04:33:00	SPY	ETF	113.77	113.77	113.77	113.77	100.0
2011-08-22 04:34:00	SPY	ETF	113.85	113.85	113.85	113.85	400.0
2011-08-22 04:36:00	SPY	ETF	113.85	113.85	113.85	113.85	7600.0
2011-08-22 04:40:00	SPY	ETF	113.77	113.77	113.77	113.77	276.0
2011-08-22 04:42:00	SPY	ETF	113.75	113.75	113.75	113.75	2500.0
2011-08-22 04:44:00	SPY	ETF	113.83	113.83	113.83	113.83	2500.0
2011-08-22 04:50:00	SPY	ETF	113.88	113.88	113.88	113.88	100.0
2011-08-22 04:51:00	SPY	ETF	113.93	113.93	113.93	113.93	200.0
2011-08-22 05:00:00	SPY	ETF	114.0	114.0	114.0	114.0	200.0
2011-08-22 05:02:00	SPY	ETF	113.97	113.97	113.97	113.97	200.0
2011-08-22 05:03:00	SPY	ETF	114.0	114.03	114.0	114.03	1100.0
2011-08-22 05:05:00	SPY	ETF	114.02	114.02	114.02	114.02	200.0
2011-08-22 05:12:00	SPY	ETF	114.07	114.08	114.07	114.08	300.0
2011-08-22 05:16:00	SPY	ETF	113.96	113.96	113.96	113.96	500.0
2011-08-22 05:17:00	SPY	ETF	114.0	114.08	114.0	114.08	200.0
2011-08-22 05:21:00	SPY	ETF	113.97	113.97	113.97	113.97	100.0
2011-08-22 05:23:00	SPY	ETF	113.9	113.9	113.9	113.9	200.0
2011-08-22 05:32:00	SPY	ETF	113.93	113.93	113.93	113.93	213.0
2011-08-22 05:41:00	SPY	ETF	113.87	113.87	113.87	113.87	200.0
2011-08-22 05:44:00	SPY	ETF	113.98	113.98	113.98	113.98	300.0
2011-08-22 05:54:00	SPY	ETF	113.87	113.87	113.87	113.87	100.0
2011-08-22 05:56:00	SPY	ETF	114.0	114.0	113.95	113.95	1000.0
2011-08-22 05:57:00	SPY	ETF	113.83	113.83	113.83	113.83	200.0
2011-08-22 05:58:00	SPY	ETF	113.8	113.8	113.8	113.8	100.0
2011-08-22 06:00:00	SPY	ETF	113.67	113.68	113.67	113.68	5700.0
2011-08-22 06:04:00	SPY	ETF	113.62	113.62	113.62	113.62	500.0
2011-08-22 06:07:00	SPY	ETF	113.78	113.78	113.78	113.78	100.0
2011-08-22 06:08:00	SPY	ETF	113.67	113.67	113.67	113.67	100.0
2011-08-22 06:14:00	SPY	ETF	113.88	113.88	113.85	113.85	500.0
2011-08-22 06:17:00	SPY	ETF	113.8	113.88	113.8	113.85	4490.0
2011-08-22 06:18:00	SPY	ETF	113.77	113.77	113.77	113.77	100.0
2011-08-22 06:19:00	SPY	ETF	113.88	113.88	113.88	113.88	1000.0
2011-08-22 06:21:00	SPY	ETF	113.87	113.87	113.87	113.87	300.0
2011-08-22 06:22:00	SPY	ETF	113.9	113.9	113.9	113.9	1500.0
2011-08-22 06:25:00	SPY	ETF	113.92	113.92	113.92	113.92	10000.0
2011-08-22 06:28:00	SPY	ETF	114.03	114.03	114.03	114.03	7500.0
2011-08-22 06:29:00	SPY	ETF	114.0	114.0	114.0	114.0	500.0
2011-08-22 06:30:00	SPY	ETF	114.08	114.08	114.08	114.08	300.0
2011-08-22 06:37:00	SPY	ETF	113.92	113.92	113.92	113.92	2500.0
2011-08-22 06:39:00	SPY	ETF	113.9	113.9	113.9	113.9	400.0
2011-08-22 06:40:00	SPY	ETF	113.9	113.9	113.9	113.9	200.0

> showing 50 of 117,483 rows — these rows as CSV

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