PREVIEW / etf_1min / 2012-11-29

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-11-29.parquet
  size:    1.9 MB
  rows:    103,783

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-11-29 04:00:00	SPY	ETF	142.21	142.21	142.21	142.21	380.0
2012-11-29 04:02:00	SPY	ETF	142.28	142.28	142.27	142.27	350.0
2012-11-29 04:03:00	SPY	ETF	142.29	142.29	142.29	142.29	100.0
2012-11-29 04:05:00	SPY	ETF	142.3	142.37	142.3	142.37	300.0
2012-11-29 04:08:00	SPY	ETF	142.26	142.28	142.26	142.28	3615.0
2012-11-29 04:10:00	SPY	ETF	142.25	142.25	142.25	142.25	100.0
2012-11-29 04:15:00	SPY	ETF	142.24	142.24	142.24	142.24	400.0
2012-11-29 04:19:00	SPY	ETF	142.23	142.23	142.23	142.23	150.0
2012-11-29 04:25:00	SPY	ETF	142.23	142.23	142.23	142.23	300.0
2012-11-29 04:26:00	SPY	ETF	142.21	142.21	142.21	142.21	150.0
2012-11-29 04:31:00	SPY	ETF	142.22	142.22	142.22	142.22	200.0
2012-11-29 04:33:00	SPY	ETF	142.26	142.26	142.26	142.26	172.0
2012-11-29 04:38:00	SPY	ETF	142.32	142.32	142.32	142.32	14000.0
2012-11-29 04:47:00	SPY	ETF	142.28	142.28	142.28	142.28	300.0
2012-11-29 04:50:00	SPY	ETF	142.29	142.29	142.29	142.29	2500.0
2012-11-29 04:52:00	SPY	ETF	142.29	142.29	142.29	142.29	30000.0
2012-11-29 04:53:00	SPY	ETF	142.32	142.34	142.32	142.34	200.0
2012-11-29 04:55:00	SPY	ETF	142.31	142.31	142.31	142.31	28176.0
2012-11-29 05:11:00	SPY	ETF	142.23	142.23	142.23	142.23	1000.0
2012-11-29 05:12:00	SPY	ETF	142.24	142.25	142.24	142.25	18000.0
2012-11-29 05:13:00	SPY	ETF	142.25	142.26	142.25	142.26	18000.0
2012-11-29 05:15:00	SPY	ETF	142.18	142.18	142.18	142.18	100.0
2012-11-29 05:16:00	SPY	ETF	142.15	142.15	142.15	142.15	2500.0
2012-11-29 05:17:00	SPY	ETF	142.13	142.13	142.13	142.13	9948.0
2012-11-29 05:18:00	SPY	ETF	142.15	142.16	142.14	142.14	15000.0
2012-11-29 05:19:00	SPY	ETF	142.15	142.15	142.15	142.15	2500.0
2012-11-29 05:20:00	SPY	ETF	142.17	142.17	142.17	142.17	1000.0
2012-11-29 05:21:00	SPY	ETF	142.2	142.2	142.2	142.2	100.0
2012-11-29 05:24:00	SPY	ETF	142.23	142.24	142.23	142.24	200.0
2012-11-29 05:30:00	SPY	ETF	142.22	142.23	142.22	142.23	11675.0
2012-11-29 05:31:00	SPY	ETF	142.23	142.25	142.23	142.23	4825.0
2012-11-29 05:32:00	SPY	ETF	142.18	142.18	142.18	142.18	5000.0
2012-11-29 05:33:00	SPY	ETF	142.15	142.18	142.15	142.18	14000.0
2012-11-29 05:35:00	SPY	ETF	142.22	142.22	142.22	142.22	100.0
2012-11-29 05:36:00	SPY	ETF	142.2	142.2	142.2	142.2	9000.0
2012-11-29 05:37:00	SPY	ETF	142.2	142.2	142.2	142.2	9000.0
2012-11-29 05:44:00	SPY	ETF	142.17	142.17	142.17	142.17	500.0
2012-11-29 05:49:00	SPY	ETF	142.2	142.2	142.2	142.2	18000.0
2012-11-29 05:50:00	SPY	ETF	142.25	142.25	142.25	142.25	575.0
2012-11-29 05:51:00	SPY	ETF	142.2	142.2	142.2	142.2	100.0
2012-11-29 05:52:00	SPY	ETF	142.2	142.2	142.2	142.2	9000.0
2012-11-29 05:53:00	SPY	ETF	142.19	142.2	142.19	142.2	18100.0
2012-11-29 05:55:00	SPY	ETF	142.17	142.17	142.17	142.17	500.0
2012-11-29 05:56:00	SPY	ETF	142.17	142.17	142.17	142.17	3700.0
2012-11-29 05:57:00	SPY	ETF	142.17	142.17	142.17	142.17	2500.0
2012-11-29 05:59:00	SPY	ETF	142.17	142.17	142.17	142.17	9000.0
2012-11-29 06:00:00	SPY	ETF	142.18	142.18	142.18	142.18	100.0
2012-11-29 06:05:00	SPY	ETF	142.23	142.23	142.23	142.23	200.0
2012-11-29 06:06:00	SPY	ETF	142.23	142.23	142.23	142.23	200.0
2012-11-29 06:07:00	SPY	ETF	142.23	142.23	142.22	142.22	14000.0

> showing 50 of 103,783 rows — these rows as CSV

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