PREVIEW / etf_1min / 2012-12-03

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-12-03.parquet
  size:    2.0 MB
  rows:    104,745

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-12-03 04:00:00	SPY	ETF	142.33	142.33	142.33	142.33	150.0
2012-12-03 04:41:00	SPY	ETF	142.11	142.13	142.11	142.13	2200.0
2012-12-03 04:54:00	SPY	ETF	142.11	142.11	142.11	142.11	200.0
2012-12-03 04:55:00	SPY	ETF	142.1	142.1	142.1	142.1	200.0
2012-12-03 04:56:00	SPY	ETF	142.1	142.1	142.1	142.1	1800.0
2012-12-03 04:59:00	SPY	ETF	142.16	142.16	142.16	142.16	500.0
2012-12-03 05:02:00	SPY	ETF	142.11	142.11	142.11	142.11	200.0
2012-12-03 05:03:00	SPY	ETF	142.11	142.11	142.11	142.11	1800.0
2012-12-03 05:17:00	SPY	ETF	142.17	142.17	142.17	142.17	2500.0
2012-12-03 05:22:00	SPY	ETF	142.22	142.22	142.22	142.22	2000.0
2012-12-03 05:35:00	SPY	ETF	142.25	142.25	142.25	142.25	2800.0
2012-12-03 05:57:00	SPY	ETF	142.41	142.41	142.41	142.41	100.0
2012-12-03 05:58:00	SPY	ETF	142.38	142.38	142.38	142.38	4000.0
2012-12-03 06:25:00	SPY	ETF	142.37	142.37	142.37	142.37	180.0
2012-12-03 06:39:00	SPY	ETF	142.39	142.39	142.38	142.38	500.0
2012-12-03 06:40:00	SPY	ETF	142.4	142.4	142.4	142.4	4945.0
2012-12-03 06:44:00	SPY	ETF	142.42	142.42	142.42	142.42	6000.0
2012-12-03 06:45:00	SPY	ETF	142.43	142.43	142.43	142.43	2500.0
2012-12-03 06:47:00	SPY	ETF	142.44	142.45	142.44	142.45	15000.0
2012-12-03 06:48:00	SPY	ETF	142.43	142.49	142.43	142.49	5204.0
2012-12-03 06:49:00	SPY	ETF	142.46	142.5	142.46	142.48	69496.0
2012-12-03 06:52:00	SPY	ETF	142.48	142.48	142.48	142.48	200.0
2012-12-03 06:54:00	SPY	ETF	142.5	142.5	142.49	142.5	11750.0
2012-12-03 06:55:00	SPY	ETF	142.5	142.5	142.49	142.5	26186.0
2012-12-03 06:56:00	SPY	ETF	142.54	142.54	142.51	142.51	2200.0
2012-12-03 07:00:00	SPY	ETF	142.53	142.54	142.53	142.54	5244.0
2012-12-03 07:01:00	SPY	ETF	142.54	142.55	142.54	142.54	10300.0
2012-12-03 07:02:00	SPY	ETF	142.54	142.54	142.54	142.54	5000.0
2012-12-03 07:03:00	SPY	ETF	142.53	142.53	142.53	142.53	6800.0
2012-12-03 07:06:00	SPY	ETF	142.53	142.56	142.53	142.56	7600.0
2012-12-03 07:07:00	SPY	ETF	142.53	142.55	142.53	142.55	6100.0
2012-12-03 07:08:00	SPY	ETF	142.54	142.54	142.54	142.54	500.0
2012-12-03 07:10:00	SPY	ETF	142.51	142.53	142.51	142.53	2000.0
2012-12-03 07:11:00	SPY	ETF	142.53	142.54	142.53	142.54	1200.0
2012-12-03 07:12:00	SPY	ETF	142.53	142.54	142.53	142.54	6000.0
2012-12-03 07:13:00	SPY	ETF	142.51	142.51	142.51	142.51	300.0
2012-12-03 07:14:00	SPY	ETF	142.5	142.52	142.5	142.52	900.0
2012-12-03 07:15:00	SPY	ETF	142.52	142.52	142.52	142.52	300.0
2012-12-03 07:17:00	SPY	ETF	142.54	142.55	142.54	142.55	10800.0
2012-12-03 07:18:00	SPY	ETF	142.55	142.58	142.55	142.58	27000.0
2012-12-03 07:19:00	SPY	ETF	142.58	142.58	142.58	142.58	1520.0
2012-12-03 07:20:00	SPY	ETF	142.58	142.58	142.58	142.58	536.0
2012-12-03 07:22:00	SPY	ETF	142.58	142.7	142.58	142.7	184392.0
2012-12-03 07:23:00	SPY	ETF	142.68	142.68	142.68	142.68	200.0
2012-12-03 07:24:00	SPY	ETF	142.66	142.66	142.65	142.65	39700.0
2012-12-03 07:25:00	SPY	ETF	142.63	142.65	142.63	142.65	6225.0
2012-12-03 07:26:00	SPY	ETF	142.6	142.6	142.58	142.58	15650.0
2012-12-03 07:27:00	SPY	ETF	142.56	142.58	142.56	142.58	5100.0
2012-12-03 07:28:00	SPY	ETF	142.55	142.56	142.52	142.53	94850.0
2012-12-03 07:29:00	SPY	ETF	142.6	142.6	142.6	142.6	1100.0

> showing 50 of 104,745 rows — these rows as CSV

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