PREVIEW / etf_5min / 2012-09-07

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-09-07.parquet
  size:    878 KB
  rows:    37,995

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-07 04:00:00	SPY	ETF	144.01	144.05	144.01	144.05	775.0
2012-09-07 04:25:00	SPY	ETF	144.15	144.15	144.15	144.15	1000.0
2012-09-07 04:30:00	SPY	ETF	144.15	144.2	144.15	144.2	1600.0
2012-09-07 04:35:00	SPY	ETF	144.21	144.21	144.21	144.21	200.0
2012-09-07 04:45:00	SPY	ETF	144.15	144.15	144.15	144.15	100.0
2012-09-07 04:50:00	SPY	ETF	144.12	144.15	144.12	144.15	35100.0
2012-09-07 05:05:00	SPY	ETF	144.12	144.12	144.12	144.12	19258.0
2012-09-07 05:20:00	SPY	ETF	144.14	144.14	144.14	144.14	300.0
2012-09-07 05:30:00	SPY	ETF	144.21	144.24	144.21	144.24	7565.0
2012-09-07 05:50:00	SPY	ETF	144.2	144.2	144.15	144.15	400.0
2012-09-07 06:00:00	SPY	ETF	144.24	144.25	144.24	144.25	600.0
2012-09-07 06:05:00	SPY	ETF	144.29	144.3	144.29	144.3	30200.0
2012-09-07 06:10:00	SPY	ETF	144.3	144.3	144.27	144.27	9600.0
2012-09-07 06:15:00	SPY	ETF	144.25	144.25	144.25	144.25	100.0
2012-09-07 06:20:00	SPY	ETF	144.21	144.21	144.21	144.21	25000.0
2012-09-07 06:25:00	SPY	ETF	144.27	144.27	144.27	144.27	550.0
2012-09-07 06:30:00	SPY	ETF	144.26	144.3	144.26	144.3	35850.0
2012-09-07 06:40:00	SPY	ETF	144.25	144.25	144.23	144.23	2600.0
2012-09-07 06:45:00	SPY	ETF	144.26	144.34	144.26	144.31	5500.0
2012-09-07 06:50:00	SPY	ETF	144.29	144.29	144.29	144.29	2500.0
2012-09-07 06:55:00	SPY	ETF	144.28	144.3	144.28	144.3	1300.0
2012-09-07 07:00:00	SPY	ETF	144.24	144.24	144.21	144.21	7029.0
2012-09-07 07:05:00	SPY	ETF	144.24	144.25	144.23	144.23	2126.0
2012-09-07 07:10:00	SPY	ETF	144.18	144.24	144.18	144.24	4000.0
2012-09-07 07:15:00	SPY	ETF	144.23	144.23	144.19	144.21	1000.0
2012-09-07 07:20:00	SPY	ETF	144.22	144.24	144.22	144.22	1600.0
2012-09-07 07:25:00	SPY	ETF	144.22	144.24	144.22	144.22	800.0
2012-09-07 07:30:00	SPY	ETF	144.25	144.31	144.25	144.31	58551.0
2012-09-07 07:35:00	SPY	ETF	144.31	144.35	144.29	144.35	110620.0
2012-09-07 07:40:00	SPY	ETF	144.36	144.36	144.29	144.34	26783.0
2012-09-07 07:45:00	SPY	ETF	144.34	144.39	144.3	144.32	51900.0
2012-09-07 07:50:00	SPY	ETF	144.32	144.37	144.3	144.37	10800.0
2012-09-07 07:55:00	SPY	ETF	144.35	144.38	144.32	144.35	56906.0
2012-09-07 08:00:00	SPY	ETF	144.36	144.38	144.15	144.22	534646.0
2012-09-07 08:05:00	SPY	ETF	144.23	144.28	144.22	144.28	163135.0
2012-09-07 08:10:00	SPY	ETF	144.26	144.29	144.23	144.29	33332.0
2012-09-07 08:15:00	SPY	ETF	144.29	144.3	144.2	144.23	89967.0
2012-09-07 08:20:00	SPY	ETF	144.23	144.26	144.19	144.25	145687.0
2012-09-07 08:25:00	SPY	ETF	144.26	144.37	144.26	144.31	170796.0
2012-09-07 08:30:00	SPY	ETF	144.25	144.38	143.43	143.94	2765163.0
2012-09-07 08:35:00	SPY	ETF	143.95	144.12	143.89	144.02	702599.0
2012-09-07 08:40:00	SPY	ETF	144.03	144.43	144.03	144.3	863312.0
2012-09-07 08:45:00	SPY	ETF	144.3	144.35	144.17	144.21	333941.0
2012-09-07 08:50:00	SPY	ETF	144.21	144.21	144.07	144.14	462625.0
2012-09-07 08:55:00	SPY	ETF	144.15	144.16	143.99	144.02	412316.0
2012-09-07 09:00:00	SPY	ETF	144.02	144.15	144.0	144.05	129219.0
2012-09-07 09:05:00	SPY	ETF	144.05	144.12	143.95	144.01	255728.0
2012-09-07 09:10:00	SPY	ETF	144.01	144.14	144.0	144.08	184907.0
2012-09-07 09:15:00	SPY	ETF	144.07	144.09	144.01	144.07	206012.0
2012-09-07 09:20:00	SPY	ETF	144.07	144.1	144.03	144.1	157210.0

> showing 50 of 37,995 rows — these rows as CSV

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