PREVIEW / etf_5min / 2013-04-01

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-04-01.parquet
  size:    968 KB
  rows:    41,208

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-04-01 04:00:00	SPY	ETF	156.64	156.64	156.45	156.45	1850.0
2013-04-01 04:10:00	SPY	ETF	156.44	156.44	156.44	156.44	200.0
2013-04-01 04:15:00	SPY	ETF	156.39	156.39	156.39	156.39	300.0
2013-04-01 04:40:00	SPY	ETF	156.39	156.39	156.39	156.39	400.0
2013-04-01 04:55:00	SPY	ETF	156.44	156.44	156.42	156.42	770.0
2013-04-01 05:00:00	SPY	ETF	156.42	156.42	156.4	156.4	1830.0
2013-04-01 05:10:00	SPY	ETF	156.46	156.46	156.46	156.46	1150.0
2013-04-01 05:25:00	SPY	ETF	156.44	156.44	156.44	156.44	300.0
2013-04-01 05:40:00	SPY	ETF	156.42	156.42	156.38	156.38	1200.0
2013-04-01 05:45:00	SPY	ETF	156.38	156.38	156.38	156.38	200.0
2013-04-01 05:55:00	SPY	ETF	156.41	156.41	156.41	156.41	100.0
2013-04-01 06:00:00	SPY	ETF	156.42	156.42	156.42	156.42	700.0
2013-04-01 06:15:00	SPY	ETF	156.47	156.47	156.47	156.47	300.0
2013-04-01 06:30:00	SPY	ETF	156.53	156.53	156.53	156.53	400.0
2013-04-01 06:45:00	SPY	ETF	156.56	156.56	156.54	156.56	6980.0
2013-04-01 06:50:00	SPY	ETF	156.58	156.61	156.58	156.59	3000.0
2013-04-01 07:00:00	SPY	ETF	156.57	156.62	156.57	156.61	2900.0
2013-04-01 07:05:00	SPY	ETF	156.61	156.61	156.59	156.59	4445.0
2013-04-01 07:10:00	SPY	ETF	156.59	156.59	156.59	156.59	917.0
2013-04-01 07:15:00	SPY	ETF	156.59	156.66	156.59	156.66	2300.0
2013-04-01 07:20:00	SPY	ETF	156.67	156.71	156.67	156.71	8100.0
2013-04-01 07:25:00	SPY	ETF	156.71	156.71	156.67	156.67	310.0
2013-04-01 07:30:00	SPY	ETF	156.67	156.76	156.67	156.76	7810.0
2013-04-01 07:35:00	SPY	ETF	156.76	156.81	156.76	156.77	22649.0
2013-04-01 07:40:00	SPY	ETF	156.76	156.79	156.75	156.77	59900.0
2013-04-01 07:45:00	SPY	ETF	156.77	156.77	156.72	156.72	59700.0
2013-04-01 07:55:00	SPY	ETF	156.71	156.72	156.67	156.69	46100.0
2013-04-01 08:00:00	SPY	ETF	156.69	156.7	156.38	156.67	479250.0
2013-04-01 08:05:00	SPY	ETF	156.67	156.69	156.64	156.69	82100.0
2013-04-01 08:10:00	SPY	ETF	156.7	156.7	156.67	156.69	46375.0
2013-04-01 08:15:00	SPY	ETF	156.68	156.7	156.66	156.66	12110.0
2013-04-01 08:20:00	SPY	ETF	156.66	156.77	156.66	156.76	85180.0
2013-04-01 08:25:00	SPY	ETF	156.75	156.75	156.74	156.74	12100.0
2013-04-01 08:30:00	SPY	ETF	156.74	156.74	156.66	156.68	87974.0
2013-04-01 08:35:00	SPY	ETF	156.67	156.69	156.65	156.69	15132.0
2013-04-01 08:40:00	SPY	ETF	156.7	156.7	156.68	156.68	14930.0
2013-04-01 08:45:00	SPY	ETF	156.68	156.68	156.63	156.66	66145.0
2013-04-01 08:50:00	SPY	ETF	156.66	156.66	156.62	156.63	15250.0
2013-04-01 08:55:00	SPY	ETF	156.67	156.7	156.66	156.67	14680.0
2013-04-01 09:00:00	SPY	ETF	156.66	156.67	156.66	156.66	3700.0
2013-04-01 09:05:00	SPY	ETF	156.66	156.66	156.59	156.62	31801.0
2013-04-01 09:10:00	SPY	ETF	156.61	156.63	156.6	156.61	29050.0
2013-04-01 09:15:00	SPY	ETF	156.61	156.68	156.6	156.64	458913.0
2013-04-01 09:20:00	SPY	ETF	156.63	156.68	156.61	156.63	133422.0
2013-04-01 09:25:00	SPY	ETF	156.63	156.65	156.54	156.58	212523.0
2013-04-01 09:30:00	SPY	ETF	156.59	156.69	156.54	156.64	2314364.0
2013-04-01 09:35:00	SPY	ETF	156.635	156.86	156.63	156.841	1500203.0
2013-04-01 09:40:00	SPY	ETF	156.84	156.91	156.78	156.87	997373.0
2013-04-01 09:45:00	SPY	ETF	156.87	156.875	156.76	156.78	1047805.0
2013-04-01 09:50:00	SPY	ETF	156.785	156.82	156.75	156.78	868472.0

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

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