PREVIEW / etf_1min / 2013-07-29

all etf 1-min files

  file:    by_date/etf_1min/2013/2013-07-29.parquet
  size:    2.0 MB
  rows:    102,523

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
2013-07-29 04:00:00	SPY	ETF	169.07	169.07	168.7	168.75	800.0
2013-07-29 04:02:00	SPY	ETF	168.75	168.75	168.7	168.7	3400.0
2013-07-29 04:03:00	SPY	ETF	168.69	168.69	168.69	168.69	500.0
2013-07-29 04:05:00	SPY	ETF	168.73	168.73	168.7	168.73	2100.0
2013-07-29 04:07:00	SPY	ETF	168.7	168.7	168.7	168.7	100.0
2013-07-29 04:08:00	SPY	ETF	168.69	168.69	168.68	168.68	1900.0
2013-07-29 04:09:00	SPY	ETF	168.67	168.67	168.65	168.65	330.0
2013-07-29 04:10:00	SPY	ETF	168.63	168.63	168.63	168.63	300.0
2013-07-29 04:11:00	SPY	ETF	168.64	168.64	168.64	168.64	1000.0
2013-07-29 04:12:00	SPY	ETF	168.64	168.64	168.64	168.64	500.0
2013-07-29 04:15:00	SPY	ETF	168.6	168.6	168.58	168.59	1050.0
2013-07-29 04:18:00	SPY	ETF	168.64	168.64	168.64	168.64	150.0
2013-07-29 04:20:00	SPY	ETF	168.58	168.58	168.58	168.58	400.0
2013-07-29 04:21:00	SPY	ETF	168.57	168.57	168.54	168.54	500.0
2013-07-29 04:33:00	SPY	ETF	168.64	168.64	168.63	168.64	700.0
2013-07-29 04:34:00	SPY	ETF	168.65	168.65	168.65	168.65	2000.0
2013-07-29 04:38:00	SPY	ETF	168.68	168.68	168.68	168.68	200.0
2013-07-29 04:41:00	SPY	ETF	168.63	168.63	168.63	168.63	200.0
2013-07-29 04:45:00	SPY	ETF	168.64	168.64	168.64	168.64	400.0
2013-07-29 04:52:00	SPY	ETF	168.63	168.63	168.63	168.63	2500.0
2013-07-29 04:54:00	SPY	ETF	168.67	168.68	168.67	168.68	300.0
2013-07-29 04:55:00	SPY	ETF	168.73	168.73	168.73	168.73	4800.0
2013-07-29 04:56:00	SPY	ETF	168.73	168.73	168.73	168.73	300.0
2013-07-29 05:02:00	SPY	ETF	168.74	168.74	168.74	168.74	400.0
2013-07-29 05:03:00	SPY	ETF	168.76	168.76	168.74	168.74	400.0
2013-07-29 05:04:00	SPY	ETF	168.78	168.83	168.78	168.83	1100.0
2013-07-29 05:06:00	SPY	ETF	168.9	168.9	168.88	168.88	3000.0
2013-07-29 05:17:00	SPY	ETF	168.86	168.86	168.86	168.86	200.0
2013-07-29 05:20:00	SPY	ETF	168.87	168.87	168.87	168.87	100.0
2013-07-29 05:24:00	SPY	ETF	168.84	168.84	168.84	168.84	200.0
2013-07-29 05:28:00	SPY	ETF	168.83	168.83	168.83	168.83	200.0
2013-07-29 05:32:00	SPY	ETF	168.88	168.88	168.88	168.88	200.0
2013-07-29 05:37:00	SPY	ETF	168.85	168.85	168.83	168.83	500.0
2013-07-29 05:39:00	SPY	ETF	168.82	168.82	168.82	168.82	300.0
2013-07-29 05:42:00	SPY	ETF	168.81	168.81	168.81	168.81	500.0
2013-07-29 05:45:00	SPY	ETF	168.78	168.78	168.73	168.73	600.0
2013-07-29 05:46:00	SPY	ETF	168.7	168.7	168.7	168.7	200.0
2013-07-29 05:51:00	SPY	ETF	168.73	168.73	168.73	168.73	10000.0
2013-07-29 05:52:00	SPY	ETF	168.7	168.7	168.68	168.68	15700.0
2013-07-29 05:53:00	SPY	ETF	168.66	168.68	168.66	168.68	6000.0
2013-07-29 05:54:00	SPY	ETF	168.63	168.63	168.6	168.6	5300.0
2013-07-29 05:56:00	SPY	ETF	168.61	168.61	168.6	168.6	5200.0
2013-07-29 05:57:00	SPY	ETF	168.63	168.63	168.63	168.63	1000.0
2013-07-29 06:00:00	SPY	ETF	168.68	168.68	168.68	168.68	2000.0
2013-07-29 06:01:00	SPY	ETF	168.68	168.69	168.68	168.69	1300.0
2013-07-29 06:02:00	SPY	ETF	168.67	168.67	168.63	168.63	62800.0
2013-07-29 06:04:00	SPY	ETF	168.6	168.6	168.6	168.6	1000.0
2013-07-29 06:09:00	SPY	ETF	168.61	168.61	168.61	168.61	3000.0
2013-07-29 06:13:00	SPY	ETF	168.6	168.6	168.6	168.6	5500.0
2013-07-29 06:15:00	SPY	ETF	168.58	168.58	168.56	168.56	600.0

> showing 50 of 102,523 rows — these rows as CSV

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