PREVIEW / etf_5min / 2011-08-09

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-08-09.parquet
  size:    1.1 MB
  rows:    47,573

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
2011-08-09 04:00:00	SPY	ETF	111.6	112.24	111.6	112.2	4829.0
2011-08-09 04:05:00	SPY	ETF	112.2	112.89	112.18	112.89	4900.0
2011-08-09 04:10:00	SPY	ETF	112.98	113.09	112.66	112.77	3300.0
2011-08-09 04:15:00	SPY	ETF	112.48	112.65	112.4	112.65	900.0
2011-08-09 04:20:00	SPY	ETF	111.91	112.23	111.83	112.21	2601.0
2011-08-09 04:25:00	SPY	ETF	112.5	112.5	112.5	112.5	100.0
2011-08-09 04:30:00	SPY	ETF	112.25	112.27	110.66	110.66	18901.0
2011-08-09 04:35:00	SPY	ETF	110.84	111.41	110.84	111.25	4692.0
2011-08-09 04:40:00	SPY	ETF	111.26	111.39	111.26	111.35	3300.0
2011-08-09 04:45:00	SPY	ETF	111.47	111.92	111.19	111.19	12900.0
2011-08-09 04:50:00	SPY	ETF	111.46	111.52	111.46	111.52	1300.0
2011-08-09 04:55:00	SPY	ETF	111.65	111.99	111.65	111.77	8200.0
2011-08-09 05:00:00	SPY	ETF	111.6	111.6	110.39	110.52	6702.0
2011-08-09 05:05:00	SPY	ETF	110.65	111.0	110.65	111.0	1000.0
2011-08-09 05:10:00	SPY	ETF	110.83	110.85	110.66	110.85	9600.0
2011-08-09 05:15:00	SPY	ETF	110.76	110.76	110.23	110.23	6427.0
2011-08-09 05:20:00	SPY	ETF	110.21	110.21	110.21	110.21	100.0
2011-08-09 05:25:00	SPY	ETF	110.49	110.49	110.35	110.35	2600.0
2011-08-09 05:30:00	SPY	ETF	110.57	111.07	110.5	111.07	21600.0
2011-08-09 05:35:00	SPY	ETF	111.3	111.4	111.22	111.22	5900.0
2011-08-09 05:40:00	SPY	ETF	111.24	111.65	111.24	111.65	29200.0
2011-08-09 05:45:00	SPY	ETF	111.57	112.22	111.57	111.95	35200.0
2011-08-09 05:50:00	SPY	ETF	112.01	112.21	111.43	111.43	13370.0
2011-08-09 05:55:00	SPY	ETF	111.72	111.86	111.58	111.86	14700.0
2011-08-09 06:00:00	SPY	ETF	111.84	112.06	111.84	112.06	1700.0
2011-08-09 06:05:00	SPY	ETF	111.93	112.14	111.93	112.07	1300.0
2011-08-09 06:10:00	SPY	ETF	111.7	111.74	111.66	111.74	1900.0
2011-08-09 06:15:00	SPY	ETF	112.01	112.01	111.7	111.7	4100.0
2011-08-09 06:20:00	SPY	ETF	111.68	111.86	111.66	111.86	12000.0
2011-08-09 06:25:00	SPY	ETF	112.04	112.19	112.02	112.14	70100.0
2011-08-09 06:30:00	SPY	ETF	112.15	112.24	111.94	112.19	56600.0
2011-08-09 06:35:00	SPY	ETF	112.29	112.37	111.9	111.91	74300.0
2011-08-09 06:40:00	SPY	ETF	112.14	112.52	112.08	112.52	35200.0
2011-08-09 06:45:00	SPY	ETF	112.55	112.95	112.53	112.95	89466.0
2011-08-09 06:50:00	SPY	ETF	112.87	113.09	112.6	112.76	199600.0
2011-08-09 06:55:00	SPY	ETF	112.72	113.07	112.7	113.03	278590.0
2011-08-09 07:00:00	SPY	ETF	113.03	113.54	113.03	113.45	551010.0
2011-08-09 07:05:00	SPY	ETF	113.33	113.42	113.04	113.09	190400.0
2011-08-09 07:10:00	SPY	ETF	113.07	113.59	112.9	113.57	299039.0
2011-08-09 07:15:00	SPY	ETF	113.43	113.72	113.32	113.62	776730.0
2011-08-09 07:20:00	SPY	ETF	113.63	114.17	113.6	113.8	837129.0
2011-08-09 07:25:00	SPY	ETF	113.76	113.79	113.35	113.51	539930.0
2011-08-09 07:30:00	SPY	ETF	113.48	113.78	113.46	113.77	836565.0
2011-08-09 07:35:00	SPY	ETF	113.78	113.79	113.35	113.46	197037.0
2011-08-09 07:40:00	SPY	ETF	113.43	113.46	113.13	113.13	187527.0
2011-08-09 07:45:00	SPY	ETF	113.13	113.13	112.57	112.82	558650.0
2011-08-09 07:50:00	SPY	ETF	112.82	113.2	112.79	113.15	426501.0
2011-08-09 07:55:00	SPY	ETF	113.15	113.5	112.9	113.48	628341.0
2011-08-09 08:00:00	SPY	ETF	113.44	114.0	112.83	113.23	1413628.0
2011-08-09 08:05:00	SPY	ETF	113.22	113.5	113.02	113.45	731707.0

> showing 50 of 47,573 rows — these rows as CSV

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