PREVIEW / etf_5min / 2013-07-29

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-07-29.parquet
  size:    922 KB
  rows:    39,043

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.69	168.69	4700.0
2013-07-29 04:05:00	SPY	ETF	168.73	168.73	168.65	168.65	4430.0
2013-07-29 04:10:00	SPY	ETF	168.63	168.64	168.63	168.64	1800.0
2013-07-29 04:15:00	SPY	ETF	168.6	168.64	168.58	168.64	1200.0
2013-07-29 04:20:00	SPY	ETF	168.58	168.58	168.54	168.54	900.0
2013-07-29 04:30:00	SPY	ETF	168.64	168.65	168.63	168.65	2700.0
2013-07-29 04:35:00	SPY	ETF	168.68	168.68	168.68	168.68	200.0
2013-07-29 04:40: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:50:00	SPY	ETF	168.63	168.68	168.63	168.68	2800.0
2013-07-29 04:55:00	SPY	ETF	168.73	168.73	168.73	168.73	5100.0
2013-07-29 05:00:00	SPY	ETF	168.74	168.83	168.74	168.83	1900.0
2013-07-29 05:05:00	SPY	ETF	168.9	168.9	168.88	168.88	3000.0
2013-07-29 05:15: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.84	168.84	300.0
2013-07-29 05:25:00	SPY	ETF	168.83	168.83	168.83	168.83	200.0
2013-07-29 05:30:00	SPY	ETF	168.88	168.88	168.88	168.88	200.0
2013-07-29 05:35:00	SPY	ETF	168.85	168.85	168.82	168.82	800.0
2013-07-29 05:40: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.7	168.7	800.0
2013-07-29 05:50:00	SPY	ETF	168.73	168.73	168.6	168.6	37000.0
2013-07-29 05:55:00	SPY	ETF	168.61	168.63	168.6	168.63	6200.0
2013-07-29 06:00:00	SPY	ETF	168.68	168.69	168.6	168.6	67100.0
2013-07-29 06:05:00	SPY	ETF	168.61	168.61	168.61	168.61	3000.0
2013-07-29 06:10:00	SPY	ETF	168.6	168.6	168.6	168.6	5500.0
2013-07-29 06:15:00	SPY	ETF	168.58	168.63	168.56	168.63	1000.0
2013-07-29 06:20:00	SPY	ETF	168.64	168.65	168.64	168.65	15000.0
2013-07-29 06:25:00	SPY	ETF	168.65	168.68	168.65	168.68	500.0
2013-07-29 06:30:00	SPY	ETF	168.73	168.73	168.68	168.68	3300.0
2013-07-29 06:35:00	SPY	ETF	168.65	168.65	168.64	168.64	1000.0
2013-07-29 06:40:00	SPY	ETF	168.68	168.68	168.64	168.67	1250.0
2013-07-29 06:45:00	SPY	ETF	168.72	168.75	168.72	168.75	5500.0
2013-07-29 06:50:00	SPY	ETF	168.77	168.83	168.77	168.78	4370.0
2013-07-29 06:55:00	SPY	ETF	168.81	168.85	168.81	168.85	4500.0
2013-07-29 07:00:00	SPY	ETF	168.83	168.83	168.75	168.77	26404.0
2013-07-29 07:05:00	SPY	ETF	168.78	168.78	168.72	168.72	36830.0
2013-07-29 07:10:00	SPY	ETF	168.74	168.8	168.72	168.79	13048.0
2013-07-29 07:15:00	SPY	ETF	168.8	168.85	168.78	168.84	10600.0
2013-07-29 07:20:00	SPY	ETF	168.84	168.84	168.75	168.79	8850.0
2013-07-29 07:25:00	SPY	ETF	168.75	168.75	168.75	168.75	1600.0
2013-07-29 07:30:00	SPY	ETF	168.74	168.74	168.65	168.69	9700.0
2013-07-29 07:35:00	SPY	ETF	168.68	168.72	168.67	168.72	800.0
2013-07-29 07:40:00	SPY	ETF	168.73	168.77	168.7	168.7	10370.0
2013-07-29 07:45:00	SPY	ETF	168.75	168.75	168.73	168.73	12550.0
2013-07-29 07:50:00	SPY	ETF	168.75	168.78	168.75	168.78	10450.0
2013-07-29 07:55:00	SPY	ETF	168.78	168.81	168.78	168.81	31950.0
2013-07-29 08:00:00	SPY	ETF	168.83	168.83	168.72	168.78	31770.0
2013-07-29 08:05:00	SPY	ETF	168.77	168.78	168.74	168.74	29300.0
2013-07-29 08:10:00	SPY	ETF	168.74	168.75	168.69	168.72	47190.0
2013-07-29 08:15:00	SPY	ETF	168.7	168.78	168.7	168.78	17406.0

> showing 50 of 39,043 rows — these rows as CSV

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