PREVIEW / etf_1min / 2012-10-19

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-10-19.parquet
  size:    2.1 MB
  rows:    102,527

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-10-19 04:25:00	SPY	ETF	145.51	145.51	145.51	145.51	400.0
2012-10-19 04:28:00	SPY	ETF	145.48	145.48	145.48	145.48	1000.0
2012-10-19 04:34:00	SPY	ETF	145.49	145.49	145.49	145.49	1500.0
2012-10-19 04:48:00	SPY	ETF	145.45	145.45	145.45	145.45	10000.0
2012-10-19 04:50:00	SPY	ETF	145.44	145.44	145.44	145.44	100.0
2012-10-19 05:16:00	SPY	ETF	145.52	145.52	145.52	145.52	400.0
2012-10-19 05:28:00	SPY	ETF	145.58	145.58	145.58	145.58	10100.0
2012-10-19 05:31:00	SPY	ETF	145.58	145.58	145.58	145.58	1900.0
2012-10-19 05:40:00	SPY	ETF	145.6	145.63	145.6	145.63	1700.0
2012-10-19 05:51:00	SPY	ETF	145.56	145.58	145.56	145.58	1100.0
2012-10-19 05:52:00	SPY	ETF	145.58	145.58	145.58	145.58	500.0
2012-10-19 05:58:00	SPY	ETF	145.51	145.51	145.51	145.51	100.0
2012-10-19 06:03:00	SPY	ETF	145.51	145.51	145.47	145.47	12200.0
2012-10-19 06:04:00	SPY	ETF	145.5	145.52	145.5	145.52	11000.0
2012-10-19 06:08:00	SPY	ETF	145.48	145.48	145.48	145.48	1500.0
2012-10-19 06:10:00	SPY	ETF	145.45	145.45	145.45	145.45	500.0
2012-10-19 06:13:00	SPY	ETF	145.47	145.48	145.47	145.48	1000.0
2012-10-19 06:18:00	SPY	ETF	145.46	145.46	145.46	145.46	100.0
2012-10-19 06:21:00	SPY	ETF	145.48	145.48	145.48	145.48	100.0
2012-10-19 06:22:00	SPY	ETF	145.48	145.51	145.47	145.51	6000.0
2012-10-19 06:26:00	SPY	ETF	145.4	145.4	145.34	145.34	2700.0
2012-10-19 06:29:00	SPY	ETF	145.37	145.37	145.37	145.37	2000.0
2012-10-19 06:31:00	SPY	ETF	145.36	145.37	145.33	145.35	21900.0
2012-10-19 06:33:00	SPY	ETF	145.37	145.37	145.37	145.37	100.0
2012-10-19 06:35:00	SPY	ETF	145.38	145.38	145.38	145.38	100.0
2012-10-19 06:36:00	SPY	ETF	145.4	145.4	145.4	145.4	4200.0
2012-10-19 06:39:00	SPY	ETF	145.38	145.38	145.38	145.38	133.0
2012-10-19 06:42:00	SPY	ETF	145.4	145.4	145.4	145.4	100.0
2012-10-19 06:46:00	SPY	ETF	145.4	145.4	145.4	145.4	11000.0
2012-10-19 06:48:00	SPY	ETF	145.45	145.45	145.45	145.45	9800.0
2012-10-19 06:51:00	SPY	ETF	145.43	145.43	145.43	145.43	500.0
2012-10-19 06:53:00	SPY	ETF	145.43	145.43	145.4	145.4	1000.0
2012-10-19 06:54:00	SPY	ETF	145.4	145.41	145.4	145.41	10000.0
2012-10-19 07:00:00	SPY	ETF	145.44	145.44	145.44	145.44	100.0
2012-10-19 07:01:00	SPY	ETF	145.46	145.46	145.41	145.43	1510.0
2012-10-19 07:02:00	SPY	ETF	145.41	145.41	145.41	145.41	300.0
2012-10-19 07:03:00	SPY	ETF	145.38	145.38	145.37	145.37	560.0
2012-10-19 07:04:00	SPY	ETF	145.34	145.34	145.32	145.32	2100.0
2012-10-19 07:06:00	SPY	ETF	145.33	145.33	145.3	145.3	1972.0
2012-10-19 07:08:00	SPY	ETF	145.32	145.32	145.32	145.32	309.0
2012-10-19 07:09:00	SPY	ETF	145.33	145.34	145.32	145.34	800.0
2012-10-19 07:11:00	SPY	ETF	145.32	145.32	145.32	145.32	600.0
2012-10-19 07:12:00	SPY	ETF	145.32	145.32	145.3	145.3	10000.0
2012-10-19 07:13:00	SPY	ETF	145.31	145.31	145.3	145.3	1300.0
2012-10-19 07:15:00	SPY	ETF	145.32	145.36	145.32	145.36	11100.0
2012-10-19 07:16:00	SPY	ETF	145.33	145.33	145.33	145.33	400.0
2012-10-19 07:17:00	SPY	ETF	145.32	145.32	145.32	145.32	200.0
2012-10-19 07:18:00	SPY	ETF	145.34	145.36	145.34	145.36	15400.0
2012-10-19 07:19:00	SPY	ETF	145.36	145.36	145.36	145.36	5000.0
2012-10-19 07:20:00	SPY	ETF	145.36	145.36	145.32	145.32	10005.0

> showing 50 of 102,527 rows — these rows as CSV

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