PREVIEW / etf_1min / 2014-08-14

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-08-14.parquet
  size:    2.0 MB
  rows:    103,389

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-14 04:00:00	SPY	ETF	194.9	194.9	194.9	194.9	238.0
2014-08-14 04:21:00	SPY	ETF	194.86	194.93	194.86	194.93	827.0
2014-08-14 04:36:00	SPY	ETF	195.01	195.01	195.01	195.01	100.0
2014-08-14 04:46:00	SPY	ETF	194.97	194.97	194.96	194.96	600.0
2014-08-14 05:03:00	SPY	ETF	194.89	194.89	194.89	194.89	400.0
2014-08-14 05:10:00	SPY	ETF	194.88	194.88	194.88	194.88	800.0
2014-08-14 05:13:00	SPY	ETF	194.91	194.91	194.91	194.91	1500.0
2014-08-14 05:15:00	SPY	ETF	194.89	194.89	194.89	194.89	163.0
2014-08-14 05:16:00	SPY	ETF	194.89	194.89	194.89	194.89	1553.0
2014-08-14 05:23:00	SPY	ETF	194.93	194.93	194.93	194.93	300.0
2014-08-14 05:34:00	SPY	ETF	194.87	194.87	194.87	194.87	200.0
2014-08-14 05:39:00	SPY	ETF	194.87	194.87	194.87	194.87	400.0
2014-08-14 05:40:00	SPY	ETF	194.87	194.87	194.87	194.87	1200.0
2014-08-14 06:03:00	SPY	ETF	194.98	194.98	194.98	194.98	100.0
2014-08-14 06:04:00	SPY	ETF	195.0	195.0	195.0	195.0	207.0
2014-08-14 06:06:00	SPY	ETF	195.0	195.0	195.0	195.0	100.0
2014-08-14 06:07:00	SPY	ETF	195.06	195.15	195.06	195.15	700.0
2014-08-14 06:16:00	SPY	ETF	195.17	195.17	195.17	195.17	124.0
2014-08-14 06:26:00	SPY	ETF	195.34	195.34	195.34	195.34	3710.0
2014-08-14 06:27:00	SPY	ETF	195.3	195.3	195.3	195.3	15000.0
2014-08-14 06:28:00	SPY	ETF	195.33	195.4	195.31	195.4	700.0
2014-08-14 06:30:00	SPY	ETF	195.35	195.35	195.35	195.35	1000.0
2014-08-14 06:37:00	SPY	ETF	195.31	195.38	195.31	195.38	3069.0
2014-08-14 06:38:00	SPY	ETF	195.38	195.4	195.38	195.4	10130.0
2014-08-14 06:39:00	SPY	ETF	195.35	195.35	195.35	195.35	200.0
2014-08-14 06:40:00	SPY	ETF	195.35	195.35	195.35	195.35	300.0
2014-08-14 06:45:00	SPY	ETF	195.32	195.32	195.31	195.32	10500.0
2014-08-14 06:47:00	SPY	ETF	195.31	195.31	195.31	195.31	600.0
2014-08-14 06:48:00	SPY	ETF	195.31	195.31	195.31	195.31	100.0
2014-08-14 06:49:00	SPY	ETF	195.31	195.31	195.31	195.31	2000.0
2014-08-14 06:50:00	SPY	ETF	195.36	195.36	195.36	195.36	1600.0
2014-08-14 06:52:00	SPY	ETF	195.31	195.31	195.31	195.31	11940.0
2014-08-14 06:54:00	SPY	ETF	195.36	195.36	195.36	195.36	3606.0
2014-08-14 06:55:00	SPY	ETF	195.27	195.27	195.27	195.27	280.0
2014-08-14 06:56:00	SPY	ETF	195.28	195.28	195.28	195.28	200.0
2014-08-14 06:58:00	SPY	ETF	195.28	195.28	195.28	195.28	500.0
2014-08-14 07:00:00	SPY	ETF	195.36	195.36	195.33	195.33	700.0
2014-08-14 07:01:00	SPY	ETF	195.33	195.33	195.32	195.33	3300.0
2014-08-14 07:02:00	SPY	ETF	195.28	195.28	195.28	195.28	1000.0
2014-08-14 07:03:00	SPY	ETF	195.26	195.29	195.26	195.28	4300.0
2014-08-14 07:04:00	SPY	ETF	195.28	195.28	195.28	195.28	1000.0
2014-08-14 07:05:00	SPY	ETF	195.28	195.28	195.28	195.28	1200.0
2014-08-14 07:06:00	SPY	ETF	195.29	195.29	195.28	195.28	15000.0
2014-08-14 07:07:00	SPY	ETF	195.26	195.26	195.26	195.26	5000.0
2014-08-14 07:09:00	SPY	ETF	195.33	195.34	195.33	195.34	2500.0
2014-08-14 07:10:00	SPY	ETF	195.34	195.34	195.34	195.34	2550.0
2014-08-14 07:11:00	SPY	ETF	195.31	195.31	195.31	195.31	2950.0
2014-08-14 07:18:00	SPY	ETF	195.24	195.24	195.23	195.23	11500.0
2014-08-14 07:19:00	SPY	ETF	195.2	195.23	195.2	195.23	750.0
2014-08-14 07:20:00	SPY	ETF	195.2	195.21	195.2	195.21	2850.0

> showing 50 of 103,389 rows — these rows as CSV

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