PREVIEW / etf_5min / 2013-03-20

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-03-20.parquet
  size:    918 KB
  rows:    40,300

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-03-20 04:00:00	SPY	ETF	154.7	155.01	154.7	155.01	1100.0
2013-03-20 04:05:00	SPY	ETF	155.01	155.09	155.01	155.05	2900.0
2013-03-20 04:10:00	SPY	ETF	155.1	155.19	155.1	155.19	10100.0
2013-03-20 04:15:00	SPY	ETF	155.16	155.16	155.16	155.16	2400.0
2013-03-20 04:20:00	SPY	ETF	155.16	155.16	155.16	155.16	200.0
2013-03-20 04:25:00	SPY	ETF	155.24	155.24	155.24	155.24	400.0
2013-03-20 04:40:00	SPY	ETF	155.14	155.14	155.14	155.14	100.0
2013-03-20 04:45:00	SPY	ETF	155.14	155.14	155.14	155.14	5900.0
2013-03-20 04:50:00	SPY	ETF	155.06	155.06	155.05	155.06	2000.0
2013-03-20 04:55:00	SPY	ETF	155.14	155.14	155.14	155.14	244.0
2013-03-20 05:00:00	SPY	ETF	155.18	155.2	155.18	155.2	1200.0
2013-03-20 05:15:00	SPY	ETF	155.07	155.1	155.07	155.1	2100.0
2013-03-20 05:25:00	SPY	ETF	155.06	155.06	155.06	155.06	100.0
2013-03-20 05:30:00	SPY	ETF	155.11	155.11	155.11	155.11	200.0
2013-03-20 05:35:00	SPY	ETF	155.2	155.24	155.2	155.24	1000.0
2013-03-20 05:40:00	SPY	ETF	155.2	155.2	155.2	155.2	500.0
2013-03-20 05:45:00	SPY	ETF	155.24	155.24	155.19	155.19	10200.0
2013-03-20 05:50:00	SPY	ETF	155.18	155.18	155.18	155.18	500.0
2013-03-20 05:55:00	SPY	ETF	155.14	155.14	155.14	155.14	200.0
2013-03-20 06:00:00	SPY	ETF	155.11	155.16	155.11	155.16	400.0
2013-03-20 06:05:00	SPY	ETF	155.2	155.2	155.2	155.2	2000.0
2013-03-20 06:10:00	SPY	ETF	155.21	155.21	155.21	155.21	1000.0
2013-03-20 06:15:00	SPY	ETF	155.2	155.22	155.2	155.22	700.0
2013-03-20 06:20:00	SPY	ETF	155.22	155.25	155.22	155.24	2200.0
2013-03-20 06:25:00	SPY	ETF	155.29	155.32	155.29	155.32	7000.0
2013-03-20 06:30:00	SPY	ETF	155.33	155.34	155.26	155.28	14200.0
2013-03-20 06:35:00	SPY	ETF	155.28	155.28	155.2	155.2	4400.0
2013-03-20 06:40:00	SPY	ETF	155.17	155.17	155.13	155.13	5000.0
2013-03-20 06:45:00	SPY	ETF	155.15	155.2	155.15	155.17	28575.0
2013-03-20 06:50:00	SPY	ETF	155.14	155.14	155.11	155.12	5800.0
2013-03-20 06:55:00	SPY	ETF	155.1	155.14	155.06	155.14	1000.0
2013-03-20 07:00:00	SPY	ETF	155.09	155.13	155.08	155.11	24701.0
2013-03-20 07:05:00	SPY	ETF	155.11	155.14	155.08	155.09	35265.0
2013-03-20 07:10:00	SPY	ETF	155.09	155.12	155.09	155.12	29700.0
2013-03-20 07:15:00	SPY	ETF	155.11	155.16	155.1	155.16	8907.0
2013-03-20 07:20:00	SPY	ETF	155.15	155.19	155.15	155.15	46150.0
2013-03-20 07:25:00	SPY	ETF	155.17	155.19	155.15	155.16	26600.0
2013-03-20 07:30:00	SPY	ETF	155.16	155.16	155.02	155.04	255973.0
2013-03-20 07:35:00	SPY	ETF	155.02	155.06	154.98	154.99	108195.0
2013-03-20 07:40:00	SPY	ETF	154.97	154.97	154.94	154.94	24950.0
2013-03-20 07:45:00	SPY	ETF	154.95	155.02	154.93	155.02	18163.0
2013-03-20 07:50:00	SPY	ETF	155.06	155.06	154.96	154.96	6700.0
2013-03-20 07:55:00	SPY	ETF	155.0	155.01	154.97	154.97	24400.0
2013-03-20 08:00:00	SPY	ETF	154.95	155.15	154.65	155.0	149500.0
2013-03-20 08:05:00	SPY	ETF	155.0	155.55	155.0	155.51	706355.0
2013-03-20 08:10:00	SPY	ETF	155.51	155.58	155.41	155.55	586615.0
2013-03-20 08:15:00	SPY	ETF	155.55	155.66	155.5	155.5	195880.0
2013-03-20 08:20:00	SPY	ETF	155.5	155.5	155.42	155.45	177389.0
2013-03-20 08:25:00	SPY	ETF	155.45	155.45	155.25	155.35	745372.0
2013-03-20 08:30:00	SPY	ETF	155.35	155.38	155.26	155.26	175231.0

> showing 50 of 40,300 rows — these rows as CSV

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