PREVIEW / etf_5min / 2013-05-08

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-05-08.parquet
  size:    963 KB
  rows:    41,764

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-05-08 04:10:00	SPY	ETF	162.4	162.4	162.4	162.4	100.0
2013-05-08 04:25:00	SPY	ETF	162.43	162.43	162.43	162.43	300.0
2013-05-08 04:45:00	SPY	ETF	162.49	162.49	162.49	162.49	100.0
2013-05-08 04:50:00	SPY	ETF	162.49	162.49	162.48	162.49	400.0
2013-05-08 04:55:00	SPY	ETF	162.49	162.54	162.49	162.54	1100.0
2013-05-08 05:05:00	SPY	ETF	162.51	162.51	162.51	162.51	1000.0
2013-05-08 05:10:00	SPY	ETF	162.54	162.54	162.49	162.49	1100.0
2013-05-08 05:15:00	SPY	ETF	162.5	162.5	162.5	162.5	500.0
2013-05-08 05:25:00	SPY	ETF	162.54	162.54	162.54	162.54	100.0
2013-05-08 05:30:00	SPY	ETF	162.54	162.54	162.54	162.54	200.0
2013-05-08 05:40:00	SPY	ETF	162.52	162.52	162.5	162.51	3600.0
2013-05-08 05:45:00	SPY	ETF	162.54	162.54	162.53	162.53	3000.0
2013-05-08 05:50:00	SPY	ETF	162.55	162.6	162.55	162.6	8900.0
2013-05-08 05:55:00	SPY	ETF	162.6	162.6	162.59	162.6	5000.0
2013-05-08 06:00:00	SPY	ETF	162.6	162.63	162.6	162.63	1400.0
2013-05-08 06:05:00	SPY	ETF	162.63	162.63	162.58	162.58	1800.0
2013-05-08 06:20:00	SPY	ETF	162.58	162.6	162.58	162.6	1100.0
2013-05-08 06:25:00	SPY	ETF	162.58	162.58	162.58	162.58	100.0
2013-05-08 06:30:00	SPY	ETF	162.57	162.6	162.57	162.6	5200.0
2013-05-08 06:35:00	SPY	ETF	162.62	162.63	162.62	162.63	700.0
2013-05-08 06:40:00	SPY	ETF	162.64	162.68	162.64	162.65	8100.0
2013-05-08 06:45:00	SPY	ETF	162.68	162.68	162.63	162.63	9000.0
2013-05-08 06:50:00	SPY	ETF	162.62	162.63	162.62	162.63	400.0
2013-05-08 07:00:00	SPY	ETF	162.63	162.65	162.58	162.58	18100.0
2013-05-08 07:05:00	SPY	ETF	162.6	162.65	162.6	162.6	8100.0
2013-05-08 07:10:00	SPY	ETF	162.6	162.6	162.6	162.6	600.0
2013-05-08 07:15:00	SPY	ETF	162.62	162.62	162.58	162.58	16500.0
2013-05-08 07:20:00	SPY	ETF	162.6	162.6	162.57	162.57	12075.0
2013-05-08 07:25:00	SPY	ETF	162.59	162.63	162.59	162.62	8400.0
2013-05-08 07:30:00	SPY	ETF	162.63	162.65	162.62	162.63	68405.0
2013-05-08 07:35:00	SPY	ETF	162.62	162.66	162.62	162.64	150615.0
2013-05-08 07:40:00	SPY	ETF	162.62	162.62	162.6	162.6	995.0
2013-05-08 07:45:00	SPY	ETF	162.6	162.63	162.6	162.6	50590.0
2013-05-08 07:50:00	SPY	ETF	162.6	162.61	162.58	162.61	22205.0
2013-05-08 07:55:00	SPY	ETF	162.58	162.58	162.57	162.57	3495.0
2013-05-08 08:00:00	SPY	ETF	162.57	162.63	162.55	162.57	21104.0
2013-05-08 08:05:00	SPY	ETF	162.58	162.63	162.58	162.61	132990.0
2013-05-08 08:10:00	SPY	ETF	162.61	162.61	162.54	162.54	90688.0
2013-05-08 08:15:00	SPY	ETF	162.53	162.56	162.46	162.46	16787.0
2013-05-08 08:20:00	SPY	ETF	162.46	162.46	162.35	162.4	104085.0
2013-05-08 08:25:00	SPY	ETF	162.38	162.41	162.36	162.41	22075.0
2013-05-08 08:30:00	SPY	ETF	162.41	162.43	162.33	162.34	89824.0
2013-05-08 08:35:00	SPY	ETF	162.34	162.4	162.33	162.37	45220.0
2013-05-08 08:40:00	SPY	ETF	162.38	162.42	162.35	162.42	19631.0
2013-05-08 08:45:00	SPY	ETF	162.4	162.46	162.36	162.46	39747.0
2013-05-08 08:50:00	SPY	ETF	162.44	162.46	162.27	162.28	101151.0
2013-05-08 08:55:00	SPY	ETF	162.27	162.27	162.19	162.22	159429.0
2013-05-08 09:00:00	SPY	ETF	162.24	162.28	162.24	162.25	39912.0
2013-05-08 09:05:00	SPY	ETF	162.26	162.27	162.22	162.25	84957.0
2013-05-08 09:10:00	SPY	ETF	162.27	162.34	162.26	162.32	71696.0

> showing 50 of 41,764 rows — these rows as CSV

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