PREVIEW / etf_1min / 2011-08-08

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-08-08.parquet
  size:    3.2 MB
  rows:    161,030

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-08 04:00:00	SPY	ETF	118.1	118.7	118.1	118.7	10438.0
2011-08-08 04:02:00	SPY	ETF	118.5	118.5	118.5	118.5	100.0
2011-08-08 04:04:00	SPY	ETF	118.65	118.67	118.65	118.67	455.0
2011-08-08 04:05:00	SPY	ETF	118.7	118.7	118.7	118.7	428.0
2011-08-08 04:07:00	SPY	ETF	118.6	118.6	118.6	118.6	190.0
2011-08-08 04:08:00	SPY	ETF	118.77	118.77	118.77	118.77	100.0
2011-08-08 04:10:00	SPY	ETF	118.71	118.71	118.71	118.71	100.0
2011-08-08 04:11:00	SPY	ETF	118.6	118.6	118.6	118.6	420.0
2011-08-08 04:12:00	SPY	ETF	118.74	118.74	118.74	118.74	2000.0
2011-08-08 04:19:00	SPY	ETF	118.25	118.25	118.25	118.25	500.0
2011-08-08 04:20:00	SPY	ETF	118.22	118.29	118.22	118.29	700.0
2011-08-08 04:21:00	SPY	ETF	118.24	118.24	118.21	118.21	2100.0
2011-08-08 04:24:00	SPY	ETF	118.39	118.59	118.39	118.59	6100.0
2011-08-08 04:27:00	SPY	ETF	118.5	118.54	118.5	118.54	1600.0
2011-08-08 04:29:00	SPY	ETF	118.51	118.51	118.45	118.45	200.0
2011-08-08 04:30:00	SPY	ETF	118.49	118.5	118.49	118.5	1100.0
2011-08-08 04:32:00	SPY	ETF	118.5	118.5	118.5	118.5	200.0
2011-08-08 04:35:00	SPY	ETF	118.55	118.55	118.5	118.5	400.0
2011-08-08 04:36:00	SPY	ETF	118.54	118.54	118.52	118.52	400.0
2011-08-08 04:37:00	SPY	ETF	118.38	118.38	118.38	118.38	100.0
2011-08-08 04:40:00	SPY	ETF	118.52	118.52	118.52	118.52	100.0
2011-08-08 04:41:00	SPY	ETF	118.49	118.55	118.49	118.55	1500.0
2011-08-08 04:44:00	SPY	ETF	118.34	118.34	118.34	118.34	100.0
2011-08-08 04:49:00	SPY	ETF	118.29	118.29	118.29	118.29	300.0
2011-08-08 04:55:00	SPY	ETF	118.07	118.07	118.07	118.07	200.0
2011-08-08 04:56:00	SPY	ETF	118.06	118.06	118.06	118.06	100.0
2011-08-08 04:57:00	SPY	ETF	118.09	118.09	118.09	118.09	100.0
2011-08-08 04:59:00	SPY	ETF	118.0	118.0	117.78	117.78	2100.0
2011-08-08 05:01:00	SPY	ETF	117.85	117.85	117.82	117.82	2100.0
2011-08-08 05:03:00	SPY	ETF	117.95	117.95	117.95	117.95	500.0
2011-08-08 05:04:00	SPY	ETF	118.08	118.08	118.08	118.08	300.0
2011-08-08 05:07:00	SPY	ETF	117.91	117.91	117.9	117.9	1200.0
2011-08-08 05:08:00	SPY	ETF	117.89	117.89	117.85	117.85	200.0
2011-08-08 05:12:00	SPY	ETF	117.8	117.8	117.75	117.75	5120.0
2011-08-08 05:13:00	SPY	ETF	117.66	117.66	117.65	117.65	400.0
2011-08-08 05:14:00	SPY	ETF	117.47	117.47	117.47	117.47	200.0
2011-08-08 05:16:00	SPY	ETF	117.71	117.72	117.71	117.72	5000.0
2011-08-08 05:17:00	SPY	ETF	117.6	117.6	117.59	117.59	300.0
2011-08-08 05:18:00	SPY	ETF	117.45	117.45	117.45	117.45	300.0
2011-08-08 05:20:00	SPY	ETF	117.39	117.39	117.39	117.39	200.0
2011-08-08 05:21:00	SPY	ETF	117.4	117.75	117.07	117.75	3840.0
2011-08-08 05:25:00	SPY	ETF	117.33	117.33	117.25	117.25	10500.0
2011-08-08 05:26:00	SPY	ETF	117.07	117.21	116.98	117.21	1800.0
2011-08-08 05:27:00	SPY	ETF	117.15	117.15	117.05	117.15	2000.0
2011-08-08 05:29:00	SPY	ETF	117.37	117.42	117.37	117.42	1100.0
2011-08-08 05:30:00	SPY	ETF	117.45	117.49	117.45	117.49	1600.0
2011-08-08 05:31:00	SPY	ETF	117.5	117.5	117.5	117.5	9700.0
2011-08-08 05:32:00	SPY	ETF	117.34	117.34	117.34	117.34	1000.0
2011-08-08 05:33:00	SPY	ETF	117.27	117.27	117.17	117.17	7000.0
2011-08-08 05:34:00	SPY	ETF	117.4	117.4	117.4	117.4	1000.0

> showing 50 of 161,030 rows — these rows as CSV

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