PREVIEW / etf_1min / 2014-08-05

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-08-05.parquet
  size:    2.4 MB
  rows:    121,020

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-08-05 04:00:00	SPY	ETF	193.65	193.65	193.59	193.59	360.0
2014-08-05 04:02:00	SPY	ETF	193.59	193.59	193.59	193.59	517.0
2014-08-05 04:06:00	SPY	ETF	193.59	193.59	193.59	193.59	975.0
2014-08-05 04:28:00	SPY	ETF	193.8	193.8	193.8	193.8	100.0
2014-08-05 04:40:00	SPY	ETF	193.69	193.7	193.69	193.7	200.0
2014-08-05 04:54:00	SPY	ETF	193.76	193.76	193.76	193.76	205.0
2014-08-05 05:00:00	SPY	ETF	193.77	193.77	193.77	193.77	500.0
2014-08-05 05:02:00	SPY	ETF	193.72	193.72	193.72	193.72	1000.0
2014-08-05 05:07:00	SPY	ETF	193.71	193.71	193.71	193.71	135.0
2014-08-05 05:19:00	SPY	ETF	193.79	193.79	193.79	193.79	300.0
2014-08-05 05:20:00	SPY	ETF	193.81	193.81	193.81	193.81	137.0
2014-08-05 05:30:00	SPY	ETF	193.67	193.67	193.67	193.67	100.0
2014-08-05 05:46:00	SPY	ETF	193.65	193.65	193.65	193.65	164.0
2014-08-05 05:52:00	SPY	ETF	193.58	193.58	193.57	193.57	1357.0
2014-08-05 06:08:00	SPY	ETF	193.51	193.51	193.48	193.48	15000.0
2014-08-05 06:12:00	SPY	ETF	193.48	193.48	193.48	193.48	5000.0
2014-08-05 06:14:00	SPY	ETF	193.44	193.44	193.44	193.44	185.0
2014-08-05 06:18:00	SPY	ETF	193.42	193.42	193.41	193.41	600.0
2014-08-05 06:19:00	SPY	ETF	193.41	193.41	193.41	193.41	425.0
2014-08-05 06:22:00	SPY	ETF	193.41	193.41	193.4	193.41	700.0
2014-08-05 06:26:00	SPY	ETF	193.44	193.44	193.44	193.44	300.0
2014-08-05 06:28:00	SPY	ETF	193.45	193.45	193.45	193.45	1500.0
2014-08-05 06:29:00	SPY	ETF	193.48	193.48	193.48	193.48	9100.0
2014-08-05 06:33:00	SPY	ETF	193.52	193.52	193.52	193.52	167.0
2014-08-05 06:39:00	SPY	ETF	193.39	193.39	193.39	193.39	500.0
2014-08-05 06:40:00	SPY	ETF	193.43	193.46	193.43	193.43	5000.0
2014-08-05 06:43:00	SPY	ETF	193.42	193.42	193.39	193.39	1300.0
2014-08-05 06:49:00	SPY	ETF	193.34	193.34	193.34	193.34	3000.0
2014-08-05 06:53:00	SPY	ETF	193.38	193.41	193.38	193.41	700.0
2014-08-05 06:54:00	SPY	ETF	193.45	193.45	193.45	193.45	200.0
2014-08-05 06:55:00	SPY	ETF	193.42	193.45	193.42	193.45	666.0
2014-08-05 06:56:00	SPY	ETF	193.48	193.48	193.44	193.44	1287.0
2014-08-05 07:00:00	SPY	ETF	193.42	193.42	193.42	193.42	1000.0
2014-08-05 07:01:00	SPY	ETF	193.41	193.41	193.41	193.41	100.0
2014-08-05 07:02:00	SPY	ETF	193.4	193.43	193.4	193.43	3900.0
2014-08-05 07:03:00	SPY	ETF	193.4	193.4	193.4	193.4	100.0
2014-08-05 07:04:00	SPY	ETF	193.36	193.36	193.36	193.36	3000.0
2014-08-05 07:07:00	SPY	ETF	193.41	193.41	193.41	193.41	100.0
2014-08-05 07:08:00	SPY	ETF	193.4	193.4	193.37	193.37	7925.0
2014-08-05 07:09:00	SPY	ETF	193.37	193.37	193.32	193.32	12050.0
2014-08-05 07:10:00	SPY	ETF	193.32	193.32	193.31	193.31	2100.0
2014-08-05 07:11:00	SPY	ETF	193.27	193.3	193.27	193.3	1100.0
2014-08-05 07:13:00	SPY	ETF	193.28	193.31	193.28	193.31	1000.0
2014-08-05 07:14:00	SPY	ETF	193.32	193.34	193.32	193.32	1808.0
2014-08-05 07:15:00	SPY	ETF	193.32	193.32	193.32	193.32	4080.0
2014-08-05 07:16:00	SPY	ETF	193.29	193.29	193.29	193.29	100.0
2014-08-05 07:17:00	SPY	ETF	193.33	193.33	193.27	193.27	1774.0
2014-08-05 07:18:00	SPY	ETF	193.3	193.3	193.27	193.27	1900.0
2014-08-05 07:20:00	SPY	ETF	193.27	193.27	193.25	193.27	51500.0
2014-08-05 07:21:00	SPY	ETF	193.28	193.28	193.22	193.22	13800.0

> showing 50 of 121,020 rows — these rows as CSV

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