PREVIEW / etf_1min / 2012-07-05

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-07-05.parquet
  size:    1.9 MB
  rows:    99,981

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
2012-07-05 04:05:00	SPY	ETF	137.37	137.37	137.37	137.37	300.0
2012-07-05 04:08:00	SPY	ETF	137.3	137.3	137.3	137.3	200.0
2012-07-05 04:12:00	SPY	ETF	137.37	137.37	137.37	137.37	200.0
2012-07-05 04:18:00	SPY	ETF	137.25	137.25	137.25	137.25	100.0
2012-07-05 04:20:00	SPY	ETF	137.31	137.31	137.29	137.29	800.0
2012-07-05 04:26:00	SPY	ETF	137.28	137.28	137.28	137.28	200.0
2012-07-05 04:28:00	SPY	ETF	137.31	137.31	137.31	137.31	200.0
2012-07-05 04:38:00	SPY	ETF	137.39	137.39	137.39	137.39	200.0
2012-07-05 04:39:00	SPY	ETF	137.41	137.41	137.41	137.41	100.0
2012-07-05 04:43:00	SPY	ETF	137.39	137.39	137.39	137.39	200.0
2012-07-05 04:50:00	SPY	ETF	137.42	137.42	137.42	137.42	200.0
2012-07-05 04:52:00	SPY	ETF	137.35	137.35	137.35	137.35	100.0
2012-07-05 05:02:00	SPY	ETF	137.36	137.36	137.33	137.35	6000.0
2012-07-05 05:16:00	SPY	ETF	137.41	137.41	137.41	137.41	300.0
2012-07-05 05:35:00	SPY	ETF	137.46	137.46	137.45	137.45	700.0
2012-07-05 05:44:00	SPY	ETF	137.41	137.41	137.41	137.41	100.0
2012-07-05 05:45:00	SPY	ETF	137.36	137.36	137.36	137.36	100.0
2012-07-05 05:54:00	SPY	ETF	137.38	137.38	137.36	137.36	500.0
2012-07-05 06:02:00	SPY	ETF	137.4	137.4	137.4	137.4	26000.0
2012-07-05 06:21:00	SPY	ETF	137.37	137.37	137.37	137.37	1000.0
2012-07-05 06:22:00	SPY	ETF	137.33	137.33	137.33	137.33	500.0
2012-07-05 06:24:00	SPY	ETF	137.36	137.36	137.36	137.36	600.0
2012-07-05 06:30:00	SPY	ETF	137.35	137.35	137.3	137.3	10000.0
2012-07-05 06:35:00	SPY	ETF	137.29	137.29	137.28	137.28	25000.0
2012-07-05 06:36:00	SPY	ETF	137.31	137.31	137.31	137.31	100.0
2012-07-05 06:37:00	SPY	ETF	137.31	137.31	137.31	137.31	100.0
2012-07-05 06:39:00	SPY	ETF	137.31	137.31	137.31	137.31	100.0
2012-07-05 06:41:00	SPY	ETF	137.33	137.33	137.33	137.33	100.0
2012-07-05 06:45:00	SPY	ETF	137.35	137.36	137.35	137.36	2000.0
2012-07-05 06:46:00	SPY	ETF	137.31	137.31	137.3	137.3	5000.0
2012-07-05 06:48:00	SPY	ETF	137.33	137.34	137.33	137.34	1000.0
2012-07-05 06:49:00	SPY	ETF	137.36	137.36	137.36	137.36	200.0
2012-07-05 06:54:00	SPY	ETF	137.33	137.33	137.3	137.3	600.0
2012-07-05 06:59:00	SPY	ETF	137.3	137.85	137.3	137.85	4500.0
2012-07-05 07:00:00	SPY	ETF	137.76	137.79	137.64	137.75	35000.0
2012-07-05 07:01:00	SPY	ETF	137.76	138.0	137.71	138.0	67003.0
2012-07-05 07:02:00	SPY	ETF	138.01	138.06	137.89	137.91	52500.0
2012-07-05 07:03:00	SPY	ETF	137.89	137.95	137.88	137.95	17900.0
2012-07-05 07:04:00	SPY	ETF	137.94	138.04	137.89	138.04	27600.0
2012-07-05 07:05:00	SPY	ETF	137.99	137.99	137.88	137.88	12500.0
2012-07-05 07:06:00	SPY	ETF	137.88	137.88	137.68	137.69	37100.0
2012-07-05 07:07:00	SPY	ETF	137.62	137.68	137.48	137.59	33000.0
2012-07-05 07:08:00	SPY	ETF	137.56	137.73	137.55	137.73	30400.0
2012-07-05 07:09:00	SPY	ETF	137.71	137.76	137.7	137.75	18410.0
2012-07-05 07:10:00	SPY	ETF	137.76	137.82	137.76	137.79	2316.0
2012-07-05 07:11:00	SPY	ETF	137.79	137.79	137.73	137.73	16984.0
2012-07-05 07:12:00	SPY	ETF	137.73	137.84	137.73	137.83	3268.0
2012-07-05 07:13:00	SPY	ETF	137.79	137.82	137.76	137.76	2226.0
2012-07-05 07:14:00	SPY	ETF	137.81	137.83	137.81	137.83	800.0
2012-07-05 07:15:00	SPY	ETF	137.78	137.78	137.76	137.76	499.0

> showing 50 of 99,981 rows — these rows as CSV

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