PREVIEW / etf_1min / 2011-10-27

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-10-27.parquet
  size:    2.6 MB
  rows:    129,007

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-27 04:00:00	SPY	ETF	125.96	126.3	125.96	126.14	26707.0
2011-10-27 04:01:00	SPY	ETF	126.12	126.2	126.12	126.12	42980.0
2011-10-27 04:02:00	SPY	ETF	126.2	126.21	126.2	126.21	490.0
2011-10-27 04:03:00	SPY	ETF	126.21	126.21	126.21	126.21	112.0
2011-10-27 04:04:00	SPY	ETF	126.3	126.34	126.3	126.34	350.0
2011-10-27 04:05:00	SPY	ETF	126.36	126.38	126.36	126.38	390.0
2011-10-27 04:06:00	SPY	ETF	126.36	126.36	126.33	126.33	1100.0
2011-10-27 04:09:00	SPY	ETF	126.2	126.2	126.18	126.18	5000.0
2011-10-27 04:12:00	SPY	ETF	126.37	126.37	126.37	126.37	500.0
2011-10-27 04:15:00	SPY	ETF	126.38	126.41	126.38	126.41	1050.0
2011-10-27 04:17:00	SPY	ETF	126.36	126.36	126.36	126.36	2000.0
2011-10-27 04:18:00	SPY	ETF	126.41	126.44	126.41	126.41	13200.0
2011-10-27 04:19:00	SPY	ETF	126.41	126.41	126.34	126.34	18500.0
2011-10-27 04:20:00	SPY	ETF	126.41	126.41	126.38	126.38	4600.0
2011-10-27 04:22:00	SPY	ETF	126.41	126.43	126.41	126.43	1300.0
2011-10-27 04:23:00	SPY	ETF	126.43	126.43	126.43	126.43	100.0
2011-10-27 04:24:00	SPY	ETF	126.47	126.47	126.47	126.47	100.0
2011-10-27 04:25:00	SPY	ETF	126.46	126.5	126.46	126.48	400.0
2011-10-27 04:27:00	SPY	ETF	126.43	126.43	126.43	126.43	5000.0
2011-10-27 04:31:00	SPY	ETF	126.46	126.46	126.46	126.46	10000.0
2011-10-27 04:32:00	SPY	ETF	126.49	126.5	126.44	126.44	32300.0
2011-10-27 04:33:00	SPY	ETF	126.43	126.43	126.43	126.43	5000.0
2011-10-27 04:34:00	SPY	ETF	126.43	126.43	126.43	126.43	5000.0
2011-10-27 04:36:00	SPY	ETF	126.4	126.4	126.33	126.33	2400.0
2011-10-27 04:37:00	SPY	ETF	126.36	126.36	126.33	126.33	11000.0
2011-10-27 04:38:00	SPY	ETF	126.33	126.38	126.33	126.38	3000.0
2011-10-27 04:41:00	SPY	ETF	126.36	126.36	126.36	126.36	200.0
2011-10-27 04:45:00	SPY	ETF	126.28	126.28	126.21	126.21	5200.0
2011-10-27 04:46:00	SPY	ETF	126.21	126.21	126.21	126.21	200.0
2011-10-27 04:47:00	SPY	ETF	126.24	126.26	126.24	126.26	4000.0
2011-10-27 04:54:00	SPY	ETF	126.32	126.32	126.32	126.32	13400.0
2011-10-27 04:57:00	SPY	ETF	126.27	126.27	126.2	126.2	7000.0
2011-10-27 04:58:00	SPY	ETF	126.16	126.16	126.16	126.16	1950.0
2011-10-27 05:01:00	SPY	ETF	126.11	126.11	126.11	126.11	1500.0
2011-10-27 05:02:00	SPY	ETF	126.13	126.19	126.13	126.19	500.0
2011-10-27 05:08:00	SPY	ETF	126.31	126.31	126.31	126.31	700.0
2011-10-27 05:09:00	SPY	ETF	126.37	126.37	126.37	126.37	200.0
2011-10-27 05:11:00	SPY	ETF	126.43	126.43	126.43	126.43	100.0
2011-10-27 05:13:00	SPY	ETF	126.36	126.36	126.36	126.36	500.0
2011-10-27 05:23:00	SPY	ETF	126.29	126.29	126.29	126.29	700.0
2011-10-27 05:24:00	SPY	ETF	126.34	126.35	126.34	126.35	700.0
2011-10-27 05:26:00	SPY	ETF	126.33	126.34	126.33	126.33	600.0
2011-10-27 05:27:00	SPY	ETF	126.39	126.42	126.39	126.4	10200.0
2011-10-27 05:35:00	SPY	ETF	126.31	126.31	126.31	126.31	1000.0
2011-10-27 05:38:00	SPY	ETF	126.31	126.31	126.31	126.31	100.0
2011-10-27 05:39:00	SPY	ETF	126.41	126.41	126.41	126.41	100.0
2011-10-27 05:40:00	SPY	ETF	126.45	126.45	126.45	126.45	2750.0
2011-10-27 05:41:00	SPY	ETF	126.41	126.47	126.41	126.47	2338.0
2011-10-27 05:42:00	SPY	ETF	126.47	126.54	126.47	126.54	11438.0
2011-10-27 05:43:00	SPY	ETF	126.51	126.53	126.51	126.53	5300.0

> showing 50 of 129,007 rows — these rows as CSV

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