PREVIEW / etf_1min / 2011-10-31

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-10-31.parquet
  size:    2.1 MB
  rows:    111,987

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
2011-10-31 04:00:00	SPY	ETF	128.1	128.1	128.0	128.0	500.0
2011-10-31 04:02:00	SPY	ETF	127.76	127.76	127.76	127.76	200.0
2011-10-31 04:03:00	SPY	ETF	127.7	127.7	127.65	127.65	1161.0
2011-10-31 04:18:00	SPY	ETF	127.6	127.6	127.6	127.6	100.0
2011-10-31 04:21:00	SPY	ETF	127.53	127.53	127.5	127.5	2200.0
2011-10-31 04:22:00	SPY	ETF	127.5	127.5	127.5	127.5	100.0
2011-10-31 04:26:00	SPY	ETF	127.53	127.53	127.53	127.53	392.0
2011-10-31 04:35:00	SPY	ETF	127.46	127.46	127.46	127.46	100.0
2011-10-31 04:40:00	SPY	ETF	127.45	127.45	127.45	127.45	200.0
2011-10-31 04:42:00	SPY	ETF	127.4	127.4	127.4	127.4	1000.0
2011-10-31 04:44:00	SPY	ETF	127.4	127.4	127.4	127.4	500.0
2011-10-31 04:58:00	SPY	ETF	127.43	127.43	127.43	127.43	6000.0
2011-10-31 04:59:00	SPY	ETF	127.43	127.46	127.43	127.46	2400.0
2011-10-31 05:00:00	SPY	ETF	127.4	127.4	127.4	127.4	200.0
2011-10-31 05:01:00	SPY	ETF	127.41	127.41	127.36	127.36	555.0
2011-10-31 05:03:00	SPY	ETF	127.36	127.36	127.36	127.36	100.0
2011-10-31 05:06:00	SPY	ETF	127.46	127.48	127.46	127.48	2000.0
2011-10-31 05:13:00	SPY	ETF	127.4	127.44	127.4	127.44	1000.0
2011-10-31 05:14:00	SPY	ETF	127.33	127.33	127.31	127.31	6563.0
2011-10-31 05:18:00	SPY	ETF	127.3	127.3	127.3	127.3	600.0
2011-10-31 05:20:00	SPY	ETF	127.27	127.27	127.27	127.27	100.0
2011-10-31 05:22:00	SPY	ETF	127.25	127.25	127.25	127.25	200.0
2011-10-31 05:26:00	SPY	ETF	127.28	127.28	127.28	127.28	100.0
2011-10-31 05:31:00	SPY	ETF	127.4	127.4	127.4	127.4	1400.0
2011-10-31 05:32:00	SPY	ETF	127.4	127.4	127.4	127.4	800.0
2011-10-31 05:33:00	SPY	ETF	127.31	127.31	127.31	127.31	200.0
2011-10-31 05:36:00	SPY	ETF	127.34	127.35	127.34	127.35	15000.0
2011-10-31 05:37:00	SPY	ETF	127.33	127.33	127.3	127.3	1240.0
2011-10-31 05:39:00	SPY	ETF	127.25	127.25	127.25	127.25	500.0
2011-10-31 05:40:00	SPY	ETF	127.25	127.26	127.23	127.23	1300.0
2011-10-31 05:46:00	SPY	ETF	127.3	127.3	127.3	127.3	600.0
2011-10-31 05:47:00	SPY	ETF	127.3	127.3	127.3	127.3	600.0
2011-10-31 05:48:00	SPY	ETF	127.21	127.21	127.21	127.21	100.0
2011-10-31 05:52:00	SPY	ETF	127.21	127.21	127.21	127.21	100.0
2011-10-31 05:53:00	SPY	ETF	127.3	127.3	127.3	127.3	1000.0
2011-10-31 06:02:00	SPY	ETF	127.39	127.39	127.39	127.39	100.0
2011-10-31 06:03:00	SPY	ETF	127.35	127.35	127.35	127.35	200.0
2011-10-31 06:06:00	SPY	ETF	127.35	127.35	127.35	127.35	800.0
2011-10-31 06:08:00	SPY	ETF	127.39	127.39	127.39	127.39	5000.0
2011-10-31 06:15:00	SPY	ETF	127.3	127.3	127.3	127.3	100.0
2011-10-31 06:16:00	SPY	ETF	127.44	127.44	127.44	127.44	100.0
2011-10-31 06:18:00	SPY	ETF	127.4	127.4	127.4	127.4	500.0
2011-10-31 06:20:00	SPY	ETF	127.38	127.38	127.38	127.38	10000.0
2011-10-31 06:21:00	SPY	ETF	127.36	127.38	127.36	127.38	800.0
2011-10-31 06:24:00	SPY	ETF	127.44	127.44	127.44	127.44	1500.0
2011-10-31 06:25:00	SPY	ETF	127.45	127.45	127.45	127.45	500.0
2011-10-31 06:26:00	SPY	ETF	127.45	127.48	127.45	127.48	1600.0
2011-10-31 06:27:00	SPY	ETF	127.51	127.51	127.51	127.51	900.0
2011-10-31 06:30:00	SPY	ETF	127.46	127.46	127.46	127.46	100.0
2011-10-31 06:33:00	SPY	ETF	127.46	127.46	127.46	127.46	500.0

> showing 50 of 111,987 rows — these rows as CSV

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