PREVIEW / etf_1min / 2011-07-20

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-07-20.parquet
  size:    1.8 MB
  rows:    99,956

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-07-20 04:00:00	SPY	ETF	133.0	133.02	133.0	133.02	214.0
2011-07-20 04:15:00	SPY	ETF	133.11	133.11	133.1	133.1	1000.0
2011-07-20 04:25:00	SPY	ETF	133.12	133.12	133.12	133.12	100.0
2011-07-20 04:30:00	SPY	ETF	133.1	133.1	133.1	133.1	700.0
2011-07-20 05:13:00	SPY	ETF	132.79	132.79	132.79	132.79	200.0
2011-07-20 05:28:00	SPY	ETF	132.98	132.98	132.98	132.98	100.0
2011-07-20 05:41:00	SPY	ETF	133.09	133.09	133.09	133.09	200.0
2011-07-20 06:01:00	SPY	ETF	133.02	133.02	133.02	133.02	1000.0
2011-07-20 06:08:00	SPY	ETF	132.99	132.99	132.99	132.99	250.0
2011-07-20 06:15:00	SPY	ETF	133.01	133.01	133.01	133.01	335.0
2011-07-20 06:23:00	SPY	ETF	133.01	133.01	133.01	133.01	100.0
2011-07-20 06:32:00	SPY	ETF	133.15	133.2	133.15	133.2	600.0
2011-07-20 06:36:00	SPY	ETF	133.23	133.27	133.14	133.27	2840.0
2011-07-20 06:39:00	SPY	ETF	133.34	133.34	133.34	133.34	200.0
2011-07-20 06:41:00	SPY	ETF	133.31	133.31	133.31	133.31	100.0
2011-07-20 06:42:00	SPY	ETF	133.35	133.35	133.35	133.35	400.0
2011-07-20 06:43:00	SPY	ETF	133.32	133.32	133.32	133.32	300.0
2011-07-20 06:48:00	SPY	ETF	133.31	133.31	133.31	133.31	100.0
2011-07-20 06:55:00	SPY	ETF	133.31	133.31	133.31	133.31	500.0
2011-07-20 06:56:00	SPY	ETF	133.31	133.33	133.31	133.33	1000.0
2011-07-20 06:59:00	SPY	ETF	133.32	133.32	133.29	133.3	10550.0
2011-07-20 07:00:00	SPY	ETF	133.32	133.34	133.32	133.34	700.0
2011-07-20 07:01:00	SPY	ETF	133.32	133.32	133.3	133.3	5200.0
2011-07-20 07:02:00	SPY	ETF	133.27	133.29	133.27	133.29	5700.0
2011-07-20 07:03:00	SPY	ETF	133.3	133.31	133.3	133.31	2500.0
2011-07-20 07:04:00	SPY	ETF	133.29	133.29	133.24	133.24	5200.0
2011-07-20 07:05:00	SPY	ETF	133.29	133.29	133.29	133.29	1000.0
2011-07-20 07:06:00	SPY	ETF	133.24	133.24	133.24	133.24	1300.0
2011-07-20 07:07:00	SPY	ETF	133.24	133.24	133.24	133.24	100.0
2011-07-20 07:10:00	SPY	ETF	133.27	133.27	133.25	133.27	900.0
2011-07-20 07:12:00	SPY	ETF	133.25	133.27	133.25	133.27	2400.0
2011-07-20 07:13:00	SPY	ETF	133.27	133.27	133.27	133.27	100.0
2011-07-20 07:14:00	SPY	ETF	133.27	133.27	133.27	133.27	3700.0
2011-07-20 07:15:00	SPY	ETF	133.29	133.3	133.29	133.3	2500.0
2011-07-20 07:16:00	SPY	ETF	133.3	133.32	133.3	133.32	1300.0
2011-07-20 07:17:00	SPY	ETF	133.33	133.35	133.33	133.34	101500.0
2011-07-20 07:18:00	SPY	ETF	133.34	133.34	133.31	133.32	66600.0
2011-07-20 07:19:00	SPY	ETF	133.36	133.38	133.36	133.37	131530.0
2011-07-20 07:20:00	SPY	ETF	133.38	133.38	133.32	133.32	31600.0
2011-07-20 07:21:00	SPY	ETF	133.32	133.32	133.32	133.32	116.0
2011-07-20 07:22:00	SPY	ETF	133.32	133.32	133.31	133.32	25032.0
2011-07-20 07:23:00	SPY	ETF	133.32	133.32	133.32	133.32	45000.0
2011-07-20 07:25:00	SPY	ETF	133.29	133.31	133.29	133.31	26800.0
2011-07-20 07:27:00	SPY	ETF	133.29	133.34	133.29	133.34	34044.0
2011-07-20 07:28:00	SPY	ETF	133.34	133.35	133.34	133.35	20000.0
2011-07-20 07:29:00	SPY	ETF	133.38	133.41	133.38	133.4	2290.0
2011-07-20 07:30:00	SPY	ETF	133.4	133.43	133.38	133.38	47610.0
2011-07-20 07:31:00	SPY	ETF	133.35	133.38	133.35	133.38	55900.0
2011-07-20 07:32:00	SPY	ETF	133.35	133.36	133.35	133.36	2500.0
2011-07-20 07:33:00	SPY	ETF	133.36	133.36	133.36	133.36	200.0

> showing 50 of 99,956 rows — these rows as CSV

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