PREVIEW / etf_5min / 2012-04-04

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-04-04.parquet
  size:    897 KB
  rows:    38,487

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-04-04 04:00:00	SPY	ETF	140.67	140.67	140.51	140.51	1590.0
2012-04-04 04:05:00	SPY	ETF	140.55	140.55	140.55	140.55	100.0
2012-04-04 04:30:00	SPY	ETF	140.56	140.56	140.56	140.56	12000.0
2012-04-04 04:40:00	SPY	ETF	140.6	140.6	140.6	140.6	25000.0
2012-04-04 04:50:00	SPY	ETF	140.31	140.34	140.31	140.34	200.0
2012-04-04 04:55:00	SPY	ETF	140.29	140.29	140.29	140.29	10170.0
2012-04-04 05:05:00	SPY	ETF	140.32	140.32	140.32	140.32	100.0
2012-04-04 05:10:00	SPY	ETF	140.32	140.32	140.28	140.28	20200.0
2012-04-04 05:15:00	SPY	ETF	140.21	140.21	140.21	140.21	200.0
2012-04-04 05:20:00	SPY	ETF	140.29	140.37	140.29	140.37	5200.0
2012-04-04 05:25:00	SPY	ETF	140.32	140.33	140.32	140.33	144000.0
2012-04-04 05:35:00	SPY	ETF	140.28	140.28	140.28	140.28	8000.0
2012-04-04 05:40:00	SPY	ETF	140.26	140.26	140.26	140.26	24960.0
2012-04-04 05:45:00	SPY	ETF	140.33	140.33	140.33	140.33	100.0
2012-04-04 05:50:00	SPY	ETF	140.21	140.21	140.21	140.21	2000.0
2012-04-04 06:00:00	SPY	ETF	140.28	140.28	140.28	140.28	300.0
2012-04-04 06:05:00	SPY	ETF	140.29	140.33	140.25	140.25	3140.0
2012-04-04 06:10:00	SPY	ETF	140.25	140.25	140.25	140.25	200.0
2012-04-04 06:15:00	SPY	ETF	140.25	140.25	140.21	140.21	3100.0
2012-04-04 06:25:00	SPY	ETF	140.15	140.34	140.15	140.27	1510.0
2012-04-04 06:30:00	SPY	ETF	140.28	140.35	140.28	140.34	35950.0
2012-04-04 06:35:00	SPY	ETF	140.27	140.3	140.27	140.3	5400.0
2012-04-04 06:45:00	SPY	ETF	140.39	140.44	140.39	140.39	62000.0
2012-04-04 06:50:00	SPY	ETF	140.4	140.41	140.39	140.39	4300.0
2012-04-04 06:55:00	SPY	ETF	140.38	140.38	140.22	140.27	13500.0
2012-04-04 07:00:00	SPY	ETF	140.27	140.27	140.15	140.17	85750.0
2012-04-04 07:05:00	SPY	ETF	140.15	140.21	140.07	140.18	38835.0
2012-04-04 07:10:00	SPY	ETF	140.18	140.2	140.11	140.14	79650.0
2012-04-04 07:15:00	SPY	ETF	140.14	140.18	140.13	140.13	33900.0
2012-04-04 07:20:00	SPY	ETF	140.16	140.19	140.13	140.19	9290.0
2012-04-04 07:25:00	SPY	ETF	140.19	140.24	140.18	140.22	47920.0
2012-04-04 07:30:00	SPY	ETF	140.21	140.29	140.18	140.18	30600.0
2012-04-04 07:35:00	SPY	ETF	140.22	140.29	140.22	140.25	15397.0
2012-04-04 07:40:00	SPY	ETF	140.25	140.34	140.25	140.31	39500.0
2012-04-04 07:45:00	SPY	ETF	140.33	140.35	140.31	140.33	92506.0
2012-04-04 07:50:00	SPY	ETF	140.36	140.39	140.36	140.36	66310.0
2012-04-04 07:55:00	SPY	ETF	140.36	140.37	140.27	140.31	92574.0
2012-04-04 08:00:00	SPY	ETF	140.31	140.39	140.11	140.18	228230.0
2012-04-04 08:05:00	SPY	ETF	140.25	140.39	140.25	140.39	49385.0
2012-04-04 08:10:00	SPY	ETF	140.36	140.38	140.29	140.31	69100.0
2012-04-04 08:15:00	SPY	ETF	140.33	141.15	140.2	140.31	165052.0
2012-04-04 08:20:00	SPY	ETF	140.31	140.35	140.22	140.26	243382.0
2012-04-04 08:25:00	SPY	ETF	140.27	140.3	140.22	140.25	83815.0
2012-04-04 08:30:00	SPY	ETF	140.28	140.28	140.15	140.22	243169.0
2012-04-04 08:35:00	SPY	ETF	140.21	140.25	140.05	140.16	207988.0
2012-04-04 08:40:00	SPY	ETF	140.16	140.21	140.07	140.21	121998.0
2012-04-04 08:45:00	SPY	ETF	140.21	140.3	140.18	140.26	168851.0
2012-04-04 08:50:00	SPY	ETF	140.25	140.37	140.22	140.24	112586.0
2012-04-04 08:55:00	SPY	ETF	140.23	140.32	140.1	140.16	182345.0
2012-04-04 09:00:00	SPY	ETF	140.14	140.21	140.13	140.16	84096.0

> showing 50 of 38,487 rows — these rows as CSV

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