PREVIEW / etf_5min / 2012-04-25

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-04-25.parquet
  size:    844 KB
  rows:    35,868

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-25 04:00:00	SPY	ETF	138.3	138.3	138.3	138.3	650.0
2012-04-25 04:05:00	SPY	ETF	138.39	138.55	138.39	138.53	1488.0
2012-04-25 04:10:00	SPY	ETF	138.55	138.6	138.5	138.6	800.0
2012-04-25 04:20:00	SPY	ETF	138.59	138.62	138.59	138.6	5100.0
2012-04-25 04:25:00	SPY	ETF	138.68	138.7	138.61	138.61	478.0
2012-04-25 04:30:00	SPY	ETF	138.48	138.48	138.45	138.45	200.0
2012-04-25 04:35:00	SPY	ETF	138.4	138.4	138.4	138.4	10000.0
2012-04-25 04:45:00	SPY	ETF	138.45	138.45	138.45	138.45	1000.0
2012-04-25 04:50:00	SPY	ETF	138.44	138.54	138.44	138.54	1340.0
2012-04-25 04:55:00	SPY	ETF	138.6	138.6	138.56	138.6	700.0
2012-04-25 05:05:00	SPY	ETF	138.54	138.54	138.53	138.53	300.0
2012-04-25 05:25:00	SPY	ETF	138.45	138.45	138.43	138.43	400.0
2012-04-25 05:30:00	SPY	ETF	138.53	138.53	138.48	138.53	5000.0
2012-04-25 05:50:00	SPY	ETF	138.41	138.41	138.31	138.36	1100.0
2012-04-25 05:55:00	SPY	ETF	138.4	138.4	138.4	138.4	500.0
2012-04-25 06:00:00	SPY	ETF	138.42	138.42	138.42	138.42	400.0
2012-04-25 06:15:00	SPY	ETF	138.44	138.44	138.44	138.44	500.0
2012-04-25 06:20:00	SPY	ETF	138.43	138.45	138.43	138.45	1000.0
2012-04-25 06:25:00	SPY	ETF	138.45	138.45	138.45	138.45	500.0
2012-04-25 06:30:00	SPY	ETF	138.43	138.43	138.43	138.43	300.0
2012-04-25 06:35:00	SPY	ETF	138.45	138.45	138.45	138.45	600.0
2012-04-25 06:40:00	SPY	ETF	138.45	138.45	138.45	138.45	4100.0
2012-04-25 06:45:00	SPY	ETF	138.45	138.46	138.45	138.46	990.0
2012-04-25 06:50:00	SPY	ETF	138.46	138.47	138.45	138.45	3700.0
2012-04-25 06:55:00	SPY	ETF	138.45	138.45	138.45	138.45	100.0
2012-04-25 07:00:00	SPY	ETF	138.45	138.51	138.45	138.48	106140.0
2012-04-25 07:05:00	SPY	ETF	138.47	138.52	138.47	138.52	3000.0
2012-04-25 07:10:00	SPY	ETF	138.51	138.53	138.51	138.52	9100.0
2012-04-25 07:15:00	SPY	ETF	138.52	138.57	138.52	138.52	17000.0
2012-04-25 07:20:00	SPY	ETF	138.51	138.57	138.51	138.54	38790.0
2012-04-25 07:25:00	SPY	ETF	138.54	138.55	138.5	138.5	14100.0
2012-04-25 07:30:00	SPY	ETF	138.5	138.51	138.41	138.44	96638.0
2012-04-25 07:35:00	SPY	ETF	138.47	138.47	138.39	138.4	78440.0
2012-04-25 07:40:00	SPY	ETF	138.4	138.5	138.38	138.47	56240.0
2012-04-25 07:45:00	SPY	ETF	138.49	138.49	138.43	138.45	18897.0
2012-04-25 07:50:00	SPY	ETF	138.44	138.46	138.38	138.45	22900.0
2012-04-25 07:55:00	SPY	ETF	138.43	138.44	138.37	138.37	21600.0
2012-04-25 08:00:00	SPY	ETF	138.45	138.57	138.39	138.43	36100.0
2012-04-25 08:05:00	SPY	ETF	138.44	138.47	138.43	138.47	24581.0
2012-04-25 08:10:00	SPY	ETF	138.46	138.48	138.41	138.47	16795.0
2012-04-25 08:15:00	SPY	ETF	138.46	138.46	138.37	138.4	28740.0
2012-04-25 08:20:00	SPY	ETF	138.4	138.44	138.39	138.43	33650.0
2012-04-25 08:25:00	SPY	ETF	138.44	138.51	138.43	138.5	116687.0
2012-04-25 08:30:00	SPY	ETF	138.51	138.51	138.05	138.3	500369.0
2012-04-25 08:35:00	SPY	ETF	138.31	138.41	138.28	138.33	198352.0
2012-04-25 08:40:00	SPY	ETF	138.34	138.36	138.29	138.3	89728.0
2012-04-25 08:45:00	SPY	ETF	138.3	138.3	138.21	138.25	141674.0
2012-04-25 08:50:00	SPY	ETF	138.24	138.34	138.23	138.32	104883.0
2012-04-25 08:55:00	SPY	ETF	138.33	138.39	138.32	138.36	235979.0
2012-04-25 09:00:00	SPY	ETF	138.35	138.48	138.32	138.46	112886.0

> showing 50 of 35,868 rows — these rows as CSV

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