PREVIEW / etf_1min / 2012-08-01

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-08-01.parquet
  size:    1.8 MB
  rows:    96,999

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-08-01 04:00:00	SPY	ETF	138.17	138.24	138.17	138.24	440.0
2012-08-01 04:04:00	SPY	ETF	138.4	138.4	138.4	138.4	100.0
2012-08-01 04:05:00	SPY	ETF	138.29	138.29	138.29	138.29	700.0
2012-08-01 04:06:00	SPY	ETF	138.33	138.33	138.33	138.33	600.0
2012-08-01 04:07:00	SPY	ETF	138.44	138.44	138.44	138.44	100.0
2012-08-01 04:08:00	SPY	ETF	138.44	138.44	138.33	138.33	400.0
2012-08-01 04:09:00	SPY	ETF	138.44	138.44	138.44	138.44	200.0
2012-08-01 04:20:00	SPY	ETF	138.48	138.48	138.48	138.48	200.0
2012-08-01 04:24:00	SPY	ETF	138.46	138.46	138.46	138.46	2500.0
2012-08-01 04:27:00	SPY	ETF	138.41	138.41	138.41	138.41	5000.0
2012-08-01 04:30:00	SPY	ETF	138.36	138.36	138.32	138.32	300.0
2012-08-01 04:32:00	SPY	ETF	138.28	138.28	138.28	138.28	200.0
2012-08-01 04:35:00	SPY	ETF	138.18	138.18	138.1	138.1	5100.0
2012-08-01 04:38:00	SPY	ETF	138.13	138.13	138.13	138.13	500.0
2012-08-01 05:14:00	SPY	ETF	138.42	138.42	138.42	138.42	2000.0
2012-08-01 05:15:00	SPY	ETF	138.39	138.42	138.39	138.42	1000.0
2012-08-01 05:17:00	SPY	ETF	138.42	138.42	138.42	138.42	2200.0
2012-08-01 05:19:00	SPY	ETF	138.46	138.48	138.46	138.48	3875.0
2012-08-01 05:32:00	SPY	ETF	138.42	138.43	138.42	138.43	20000.0
2012-08-01 05:39:00	SPY	ETF	138.42	138.42	138.42	138.42	1000.0
2012-08-01 05:40:00	SPY	ETF	138.42	138.42	138.42	138.42	1000.0
2012-08-01 05:44:00	SPY	ETF	138.39	138.4	138.39	138.4	300.0
2012-08-01 05:45:00	SPY	ETF	138.42	138.42	138.42	138.42	2000.0
2012-08-01 05:46:00	SPY	ETF	138.44	138.44	138.44	138.44	200.0
2012-08-01 05:47:00	SPY	ETF	138.41	138.41	138.41	138.41	500.0
2012-08-01 05:54:00	SPY	ETF	138.45	138.45	138.45	138.45	990.0
2012-08-01 05:57:00	SPY	ETF	138.5	138.5	138.5	138.5	100.0
2012-08-01 05:58:00	SPY	ETF	138.53	138.53	138.53	138.53	1950.0
2012-08-01 06:05:00	SPY	ETF	138.52	138.52	138.52	138.52	904.0
2012-08-01 06:12:00	SPY	ETF	138.53	138.53	138.53	138.53	300.0
2012-08-01 06:15:00	SPY	ETF	138.5	138.5	138.5	138.5	386.0
2012-08-01 06:16:00	SPY	ETF	138.5	138.5	138.5	138.5	2500.0
2012-08-01 06:24:00	SPY	ETF	138.56	138.56	138.56	138.56	400.0
2012-08-01 06:26:00	SPY	ETF	138.57	138.57	138.57	138.57	1100.0
2012-08-01 06:28:00	SPY	ETF	138.59	138.59	138.59	138.59	2000.0
2012-08-01 06:31:00	SPY	ETF	138.59	138.59	138.58	138.59	26300.0
2012-08-01 06:32:00	SPY	ETF	138.59	138.6	138.59	138.6	200.0
2012-08-01 06:38:00	SPY	ETF	138.57	138.57	138.57	138.57	10000.0
2012-08-01 06:40:00	SPY	ETF	138.57	138.57	138.57	138.57	300.0
2012-08-01 06:41:00	SPY	ETF	138.52	138.52	138.52	138.52	700.0
2012-08-01 06:43:00	SPY	ETF	138.49	138.49	138.49	138.49	500.0
2012-08-01 06:55:00	SPY	ETF	138.42	138.42	138.42	138.42	4000.0
2012-08-01 06:56:00	SPY	ETF	138.42	138.42	138.42	138.42	500.0
2012-08-01 06:57:00	SPY	ETF	138.48	138.48	138.48	138.48	10000.0
2012-08-01 06:59:00	SPY	ETF	138.45	138.45	138.42	138.42	2500.0
2012-08-01 07:00:00	SPY	ETF	138.43	138.43	138.38	138.38	2100.0
2012-08-01 07:01:00	SPY	ETF	138.36	138.37	138.35	138.36	5408.0
2012-08-01 07:02:00	SPY	ETF	138.38	138.38	138.38	138.38	3000.0
2012-08-01 07:05:00	SPY	ETF	138.36	138.36	138.33	138.33	4100.0
2012-08-01 07:07:00	SPY	ETF	138.34	138.34	138.34	138.34	1100.0

> showing 50 of 96,999 rows — these rows as CSV

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