PREVIEW / etf_1min / 2014-07-21

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-07-21.parquet
  size:    2.0 MB
  rows:    107,309

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
2014-07-21 04:00:00	SPY	ETF	197.51	197.51	197.14	197.14	10762.0
2014-07-21 04:01:00	SPY	ETF	197.19	197.2	197.14	197.16	12900.0
2014-07-21 04:02:00	SPY	ETF	197.16	197.17	197.16	197.17	454.0
2014-07-21 04:05:00	SPY	ETF	197.17	197.17	197.17	197.17	249.0
2014-07-21 04:07:00	SPY	ETF	197.17	197.17	197.17	197.17	100.0
2014-07-21 04:23:00	SPY	ETF	197.14	197.14	197.14	197.14	200.0
2014-07-21 04:28:00	SPY	ETF	197.23	197.24	197.23	197.24	5000.0
2014-07-21 04:29:00	SPY	ETF	197.13	197.13	197.13	197.13	3200.0
2014-07-21 04:30:00	SPY	ETF	197.13	197.17	197.13	197.17	3400.0
2014-07-21 04:32:00	SPY	ETF	197.17	197.17	197.17	197.17	100.0
2014-07-21 04:35:00	SPY	ETF	197.21	197.21	197.19	197.21	5000.0
2014-07-21 04:36:00	SPY	ETF	197.21	197.21	197.21	197.21	500.0
2014-07-21 04:38:00	SPY	ETF	197.13	197.18	197.13	197.18	600.0
2014-07-21 04:39:00	SPY	ETF	197.17	197.17	197.17	197.17	100.0
2014-07-21 04:40:00	SPY	ETF	197.18	197.19	197.18	197.19	241.0
2014-07-21 04:44:00	SPY	ETF	197.24	197.24	197.24	197.24	1100.0
2014-07-21 04:48:00	SPY	ETF	197.32	197.32	197.32	197.32	100.0
2014-07-21 04:49:00	SPY	ETF	197.27	197.27	197.27	197.27	137.0
2014-07-21 04:51:00	SPY	ETF	197.29	197.29	197.28	197.28	305.0
2014-07-21 04:53:00	SPY	ETF	197.21	197.21	197.21	197.21	100.0
2014-07-21 04:59:00	SPY	ETF	197.2	197.21	197.2	197.21	1000.0
2014-07-21 05:02:00	SPY	ETF	197.25	197.25	197.25	197.25	1000.0
2014-07-21 05:06:00	SPY	ETF	197.3	197.32	197.3	197.32	200.0
2014-07-21 05:11:00	SPY	ETF	197.29	197.29	197.29	197.29	150.0
2014-07-21 05:12:00	SPY	ETF	197.25	197.25	197.25	197.25	165.0
2014-07-21 05:31:00	SPY	ETF	197.4	197.4	197.4	197.4	100.0
2014-07-21 05:38:00	SPY	ETF	197.49	197.49	197.49	197.49	100.0
2014-07-21 05:46:00	SPY	ETF	197.49	197.49	197.49	197.49	206.0
2014-07-21 05:48:00	SPY	ETF	197.48	197.48	197.48	197.48	10000.0
2014-07-21 05:54:00	SPY	ETF	197.4	197.4	197.4	197.4	100.0
2014-07-21 05:58:00	SPY	ETF	197.41	197.41	197.41	197.41	200.0
2014-07-21 06:05:00	SPY	ETF	197.32	197.32	197.31	197.31	287.0
2014-07-21 06:08:00	SPY	ETF	197.3	197.31	197.3	197.31	500.0
2014-07-21 06:10:00	SPY	ETF	197.27	197.27	197.26	197.26	350.0
2014-07-21 06:13:00	SPY	ETF	197.23	197.23	197.23	197.23	100.0
2014-07-21 06:18:00	SPY	ETF	197.3	197.3	197.29	197.29	200.0
2014-07-21 06:27:00	SPY	ETF	197.31	197.31	197.31	197.31	200.0
2014-07-21 06:30:00	SPY	ETF	197.34	197.34	197.34	197.34	211.0
2014-07-21 06:31:00	SPY	ETF	197.39	197.39	197.39	197.39	2600.0
2014-07-21 06:34:00	SPY	ETF	197.36	197.37	197.36	197.37	2311.0
2014-07-21 06:38:00	SPY	ETF	197.39	197.4	197.39	197.4	6464.0
2014-07-21 06:41:00	SPY	ETF	197.39	197.39	197.38	197.38	700.0
2014-07-21 06:42:00	SPY	ETF	197.38	197.38	197.38	197.38	500.0
2014-07-21 06:43:00	SPY	ETF	197.37	197.37	197.37	197.37	249.0
2014-07-21 06:44:00	SPY	ETF	197.36	197.36	197.36	197.36	500.0
2014-07-21 06:45:00	SPY	ETF	197.35	197.35	197.34	197.34	6700.0
2014-07-21 06:46:00	SPY	ETF	197.36	197.37	197.36	197.36	4400.0
2014-07-21 06:47:00	SPY	ETF	197.37	197.37	197.33	197.33	6404.0
2014-07-21 06:48:00	SPY	ETF	197.31	197.31	197.27	197.28	1600.0
2014-07-21 06:49:00	SPY	ETF	197.36	197.36	197.36	197.36	100.0

> showing 50 of 107,309 rows — these rows as CSV

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