PREVIEW / etf_5min / 2012-09-24

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-09-24.parquet
  size:    850 KB
  rows:    36,246

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
2012-09-24 04:00:00	SPY	ETF	145.66	145.66	145.48	145.48	4770.0
2012-09-24 04:20:00	SPY	ETF	145.41	145.41	145.31	145.31	5916.0
2012-09-24 04:30:00	SPY	ETF	145.39	145.39	145.39	145.39	115.0
2012-09-24 04:35:00	SPY	ETF	145.37	145.39	145.37	145.39	250.0
2012-09-24 04:40:00	SPY	ETF	145.35	145.35	145.32	145.32	5200.0
2012-09-24 05:00:00	SPY	ETF	145.3	145.3	145.3	145.3	450.0
2012-09-24 05:15:00	SPY	ETF	145.31	145.31	145.31	145.31	200.0
2012-09-24 05:30:00	SPY	ETF	145.28	145.28	145.28	145.28	25000.0
2012-09-24 05:35:00	SPY	ETF	145.22	145.22	145.22	145.22	100.0
2012-09-24 05:50:00	SPY	ETF	145.25	145.25	145.1	145.1	2300.0
2012-09-24 05:55:00	SPY	ETF	145.08	145.12	145.07	145.1	6100.0
2012-09-24 06:00:00	SPY	ETF	145.07	145.12	145.07	145.12	6200.0
2012-09-24 06:05:00	SPY	ETF	145.12	145.14	145.1	145.12	2600.0
2012-09-24 06:20:00	SPY	ETF	145.14	145.14	145.14	145.14	150.0
2012-09-24 06:30:00	SPY	ETF	145.13	145.13	145.13	145.13	200.0
2012-09-24 06:35:00	SPY	ETF	145.14	145.14	145.14	145.14	1100.0
2012-09-24 06:40:00	SPY	ETF	145.12	145.12	145.12	145.12	1000.0
2012-09-24 06:45:00	SPY	ETF	145.14	145.14	145.14	145.14	3900.0
2012-09-24 06:50:00	SPY	ETF	145.19	145.19	145.17	145.19	6040.0
2012-09-24 06:55:00	SPY	ETF	145.15	145.17	145.15	145.17	3600.0
2012-09-24 07:00:00	SPY	ETF	145.17	145.22	145.15	145.2	2700.0
2012-09-24 07:05:00	SPY	ETF	145.22	145.22	145.21	145.21	880.0
2012-09-24 07:10:00	SPY	ETF	145.22	145.23	145.18	145.18	4200.0
2012-09-24 07:15:00	SPY	ETF	145.17	145.22	145.17	145.2	1300.0
2012-09-24 07:20:00	SPY	ETF	145.2	145.2	145.14	145.16	4500.0
2012-09-24 07:25:00	SPY	ETF	145.15	145.17	145.15	145.16	1100.0
2012-09-24 07:30:00	SPY	ETF	145.18	145.31	145.18	145.31	6790.0
2012-09-24 07:35:00	SPY	ETF	145.31	145.35	145.28	145.28	19325.0
2012-09-24 07:40:00	SPY	ETF	145.31	145.35	145.29	145.3	56490.0
2012-09-24 07:45:00	SPY	ETF	145.3	145.31	145.3	145.3	2300.0
2012-09-24 07:50:00	SPY	ETF	145.29	145.32	145.26	145.27	3000.0
2012-09-24 07:55:00	SPY	ETF	145.26	145.3	145.26	145.27	1650.0
2012-09-24 08:00:00	SPY	ETF	145.28	145.28	145.21	145.22	34834.0
2012-09-24 08:05:00	SPY	ETF	145.22	145.95	145.21	145.22	34000.0
2012-09-24 08:10:00	SPY	ETF	145.22	145.22	145.16	145.18	26239.0
2012-09-24 08:15:00	SPY	ETF	145.19	145.25	145.19	145.25	12660.0
2012-09-24 08:20:00	SPY	ETF	145.24	145.25	145.2	145.22	27774.0
2012-09-24 08:25:00	SPY	ETF	145.22	145.23	145.18	145.2	62020.0
2012-09-24 08:30:00	SPY	ETF	145.21	145.21	145.06	145.07	125341.0
2012-09-24 08:35:00	SPY	ETF	145.08	145.17	145.05	145.14	101524.0
2012-09-24 08:40:00	SPY	ETF	145.15	145.21	145.14	145.19	310657.0
2012-09-24 08:45:00	SPY	ETF	145.19	145.2	145.15	145.17	86054.0
2012-09-24 08:50:00	SPY	ETF	145.17	145.19	145.16	145.17	101590.0
2012-09-24 08:55:00	SPY	ETF	145.16	145.17	145.11	145.12	136258.0
2012-09-24 09:00:00	SPY	ETF	145.13	145.17	145.12	145.15	39300.0
2012-09-24 09:05:00	SPY	ETF	145.16	145.23	145.13	145.22	87498.0
2012-09-24 09:10:00	SPY	ETF	145.21	145.27	145.21	145.23	80124.0
2012-09-24 09:15:00	SPY	ETF	145.23	145.27	145.2	145.2	92011.0
2012-09-24 09:20:00	SPY	ETF	145.2	145.2	145.12	145.2	151803.0
2012-09-24 09:25:00	SPY	ETF	145.18	145.22	145.15	145.15	187151.0

> showing 50 of 36,246 rows — these rows as CSV

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