PREVIEW / etf_5min / 2012-08-07

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-08-07.parquet
  size:    858 KB
  rows:    36,522

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-08-07 04:30:00	SPY	ETF	140.02	140.02	140.02	140.02	234.0
2012-08-07 04:50:00	SPY	ETF	139.89	139.89	139.89	139.89	357.0
2012-08-07 05:25:00	SPY	ETF	139.9	139.9	139.9	139.9	400.0
2012-08-07 05:30:00	SPY	ETF	139.91	139.91	139.91	139.91	100.0
2012-08-07 05:35:00	SPY	ETF	139.89	139.89	139.89	139.89	1000.0
2012-08-07 05:40:00	SPY	ETF	139.8	139.8	139.8	139.8	1000.0
2012-08-07 05:45:00	SPY	ETF	139.75	139.83	139.75	139.83	6000.0
2012-08-07 06:05:00	SPY	ETF	139.69	139.69	139.65	139.65	1600.0
2012-08-07 06:15:00	SPY	ETF	139.81	139.87	139.81	139.86	5600.0
2012-08-07 06:25:00	SPY	ETF	139.98	140.0	139.97	140.0	2900.0
2012-08-07 06:30:00	SPY	ETF	139.97	139.97	139.96	139.96	10000.0
2012-08-07 06:35:00	SPY	ETF	140.0	140.01	139.96	139.96	10100.0
2012-08-07 06:40:00	SPY	ETF	139.96	140.01	139.96	139.96	11925.0
2012-08-07 06:45:00	SPY	ETF	140.0	140.02	140.0	140.02	5600.0
2012-08-07 06:55:00	SPY	ETF	140.0	140.0	140.0	140.0	100.0
2012-08-07 07:00:00	SPY	ETF	140.0	140.04	139.99	140.0	39200.0
2012-08-07 07:05:00	SPY	ETF	140.0	140.0	140.0	140.0	325.0
2012-08-07 07:10:00	SPY	ETF	140.03	140.03	139.97	139.99	7475.0
2012-08-07 07:15:00	SPY	ETF	140.01	140.02	139.96	139.96	1300.0
2012-08-07 07:20:00	SPY	ETF	139.95	140.01	139.95	140.01	2600.0
2012-08-07 07:25:00	SPY	ETF	140.0	140.1	140.0	140.08	66900.0
2012-08-07 07:30:00	SPY	ETF	140.08	140.13	140.08	140.1	47200.0
2012-08-07 07:35:00	SPY	ETF	140.11	140.15	140.09	140.15	16956.0
2012-08-07 07:40:00	SPY	ETF	140.16	140.16	140.08	140.13	9000.0
2012-08-07 07:45:00	SPY	ETF	140.11	140.18	140.11	140.13	19040.0
2012-08-07 07:50:00	SPY	ETF	140.1	140.11	140.02	140.09	33460.0
2012-08-07 07:55:00	SPY	ETF	140.07	140.07	140.05	140.06	52940.0
2012-08-07 08:00:00	SPY	ETF	140.05	140.09	140.05	140.09	24834.0
2012-08-07 08:05:00	SPY	ETF	140.06	140.09	140.04	140.06	82802.0
2012-08-07 08:10:00	SPY	ETF	140.07	140.13	140.06	140.12	49559.0
2012-08-07 08:15:00	SPY	ETF	140.12	140.15	140.1	140.14	23047.0
2012-08-07 08:20:00	SPY	ETF	140.13	140.17	140.11	140.14	529720.0
2012-08-07 08:25:00	SPY	ETF	140.13	140.17	140.13	140.16	128210.0
2012-08-07 08:30:00	SPY	ETF	140.16	140.26	140.16	140.21	65110.0
2012-08-07 08:35:00	SPY	ETF	140.2	140.31	140.18	140.27	106345.0
2012-08-07 08:40:00	SPY	ETF	140.28	140.37	140.28	140.33	152550.0
2012-08-07 08:45:00	SPY	ETF	140.34	140.34	140.26	140.26	34370.0
2012-08-07 08:50:00	SPY	ETF	140.26	140.27	140.24	140.24	20812.0
2012-08-07 08:55:00	SPY	ETF	140.24	140.24	140.14	140.14	118400.0
2012-08-07 09:00:00	SPY	ETF	140.14	140.2	140.11	140.13	148150.0
2012-08-07 09:05:00	SPY	ETF	140.12	140.17	140.11	140.16	59107.0
2012-08-07 09:10:00	SPY	ETF	140.16	140.18	140.13	140.17	94400.0
2012-08-07 09:15:00	SPY	ETF	140.17	140.19	140.14	140.17	135317.0
2012-08-07 09:20:00	SPY	ETF	140.17	140.24	140.14	140.21	156985.0
2012-08-07 09:25:00	SPY	ETF	140.2	140.2	140.1	140.18	512583.0
2012-08-07 09:30:00	SPY	ETF	140.18	140.33	140.15	140.32	2845395.0
2012-08-07 09:35:00	SPY	ETF	140.32	140.4	140.25	140.255	2485098.0
2012-08-07 09:40:00	SPY	ETF	140.25	140.43	140.25	140.42	1891163.0
2012-08-07 09:45:00	SPY	ETF	140.41	140.48	140.27	140.34	2174789.0
2012-08-07 09:50:00	SPY	ETF	140.34	140.43	140.29	140.37	1748241.0

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

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