PREVIEW / etf_1min / 2011-07-29

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-07-29.parquet
  size:    2.2 MB
  rows:    116,702

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-29 04:00:00	SPY	ETF	130.05	130.05	129.5	129.55	2000.0
2011-07-29 04:01:00	SPY	ETF	129.49	129.49	129.42	129.42	1200.0
2011-07-29 04:03:00	SPY	ETF	129.47	129.47	129.45	129.45	300.0
2011-07-29 04:15:00	SPY	ETF	129.55	129.55	129.55	129.55	1000.0
2011-07-29 04:18:00	SPY	ETF	129.7	129.7	129.7	129.7	100.0
2011-07-29 04:48:00	SPY	ETF	129.65	129.65	129.64	129.64	300.0
2011-07-29 04:58:00	SPY	ETF	129.83	129.83	129.83	129.83	200.0
2011-07-29 05:23:00	SPY	ETF	129.65	129.65	129.65	129.65	100.0
2011-07-29 05:30:00	SPY	ETF	129.5	129.5	129.5	129.5	100.0
2011-07-29 05:34:00	SPY	ETF	129.53	129.53	129.53	129.53	100.0
2011-07-29 05:54:00	SPY	ETF	129.67	129.67	129.65	129.65	200.0
2011-07-29 05:55:00	SPY	ETF	129.7	129.75	129.7	129.75	600.0
2011-07-29 05:56:00	SPY	ETF	129.71	129.8	129.71	129.8	1600.0
2011-07-29 05:57:00	SPY	ETF	129.73	129.73	129.73	129.73	100.0
2011-07-29 06:01:00	SPY	ETF	129.74	129.74	129.74	129.74	100.0
2011-07-29 06:26:00	SPY	ETF	129.63	129.63	129.63	129.63	100.0
2011-07-29 06:28:00	SPY	ETF	129.62	129.62	129.61	129.61	200.0
2011-07-29 06:29:00	SPY	ETF	129.51	129.51	129.51	129.51	500.0
2011-07-29 06:31:00	SPY	ETF	129.51	129.51	129.51	129.51	250.0
2011-07-29 06:43:00	SPY	ETF	129.52	129.52	129.48	129.51	4900.0
2011-07-29 06:45:00	SPY	ETF	129.5	129.5	129.5	129.5	100.0
2011-07-29 06:46:00	SPY	ETF	129.48	129.48	129.45	129.45	400.0
2011-07-29 06:48:00	SPY	ETF	129.42	129.42	129.18	129.18	550.0
2011-07-29 06:51:00	SPY	ETF	129.45	129.52	129.45	129.52	10600.0
2011-07-29 06:56:00	SPY	ETF	129.46	129.57	129.4	129.54	52200.0
2011-07-29 06:58:00	SPY	ETF	129.41	129.41	129.41	129.41	400.0
2011-07-29 07:00:00	SPY	ETF	129.48	129.48	129.48	129.48	400.0
2011-07-29 07:01:00	SPY	ETF	129.45	129.48	129.41	129.41	3670.0
2011-07-29 07:02:00	SPY	ETF	129.41	129.44	129.38	129.38	27200.0
2011-07-29 07:03:00	SPY	ETF	129.45	129.45	129.41	129.42	12450.0
2011-07-29 07:04:00	SPY	ETF	129.45	129.45	129.41	129.45	2800.0
2011-07-29 07:05:00	SPY	ETF	129.42	129.47	129.41	129.47	3250.0
2011-07-29 07:06:00	SPY	ETF	129.47	129.47	129.45	129.45	25100.0
2011-07-29 07:07:00	SPY	ETF	129.46	129.5	129.43	129.47	13700.0
2011-07-29 07:08:00	SPY	ETF	129.44	129.49	129.43	129.43	7700.0
2011-07-29 07:09:00	SPY	ETF	129.43	129.44	129.41	129.44	13400.0
2011-07-29 07:10:00	SPY	ETF	129.43	129.44	129.43	129.44	2000.0
2011-07-29 07:11:00	SPY	ETF	129.43	129.53	129.43	129.53	1550.0
2011-07-29 07:12:00	SPY	ETF	129.54	129.54	129.5	129.5	700.0
2011-07-29 07:13:00	SPY	ETF	129.5	129.5	129.5	129.5	10500.0
2011-07-29 07:14:00	SPY	ETF	129.51	129.51	129.51	129.51	500.0
2011-07-29 07:15:00	SPY	ETF	129.58	129.58	129.58	129.58	100.0
2011-07-29 07:16:00	SPY	ETF	129.55	129.56	129.53	129.56	16100.0
2011-07-29 07:17:00	SPY	ETF	129.57	129.67	129.56	129.66	10100.0
2011-07-29 07:18:00	SPY	ETF	129.67	129.72	129.65	129.65	7350.0
2011-07-29 07:19:00	SPY	ETF	129.68	129.68	129.6	129.6	1700.0
2011-07-29 07:20:00	SPY	ETF	129.63	129.66	129.63	129.65	14400.0
2011-07-29 07:21:00	SPY	ETF	129.6	129.63	129.6	129.63	500.0
2011-07-29 07:22:00	SPY	ETF	129.6	129.64	129.6	129.64	2502.0
2011-07-29 07:26:00	SPY	ETF	129.6	129.6	129.58	129.6	1400.0

> showing 50 of 116,702 rows — these rows as CSV

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