PREVIEW / stock_1hour / 2013-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-15.parquet
  size:    996 KB
  rows:    45,712
  symbols: 3,466

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-03-15 04:00:00	AAPL	Stock	15.4393	15.4393	15.4393	15.4393	6720.0
2013-03-15 05:00:00	AAPL	Stock	15.4554	15.4636	15.4546	15.4629	60144.0
2013-03-15 06:00:00	AAPL	Stock	15.4643	15.5714	15.4643	15.5707	70028.0
2013-03-15 07:00:00	AAPL	Stock	15.5771	15.6714	15.5771	15.6304	1663732.0
2013-03-15 08:00:00	AAPL	Stock	15.6257	15.705	15.5804	15.705	5693044.0
2013-03-15 09:00:00	AAPL	Stock	15.7068	15.8036	15.6161	15.7411	194327700.0
2013-03-15 10:00:00	AAPL	Stock	15.7389	15.7729	15.6629	15.7179	105947660.0
2013-03-15 11:00:00	AAPL	Stock	15.715	15.7554	15.7069	15.7464	40861240.0
2013-03-15 12:00:00	AAPL	Stock	15.7512	15.8482	15.7389	15.8176	60298084.0
2013-03-15 13:00:00	AAPL	Stock	15.8171	15.8654	15.805	15.8425	37857316.0
2013-03-15 14:00:00	AAPL	Stock	15.8396	15.8454	15.7321	15.7547	52039148.0
2013-03-15 15:00:00	AAPL	Stock	15.7557	15.8536	15.7182	15.8518	89938296.0
2013-03-15 16:00:00	AAPL	Stock	15.8518	15.8846	15.7392	15.8764	40612852.0
2013-03-15 17:00:00	AAPL	Stock	15.8793	15.9107	15.845	15.9007	1301076.0
2013-03-15 18:00:00	AAPL	Stock	15.9089	15.9089	15.8839	15.8882	337820.0
2013-03-15 19:00:00	AAPL	Stock	15.8857	15.9014	15.8843	15.8964	778904.0
2013-03-15 07:00:00	MSFT	Stock	28.24	28.24	28.24	28.24	100.0
2013-03-15 08:00:00	MSFT	Stock	28.27	28.27	28.06	28.15	10725.0
2013-03-15 09:00:00	MSFT	Stock	28.15	28.15	27.98	28.04	26704144.0
2013-03-15 10:00:00	MSFT	Stock	28.04	28.16	28.02	28.055	11261745.0
2013-03-15 11:00:00	MSFT	Stock	28.05	28.07	28.02	28.048	6614355.0
2013-03-15 12:00:00	MSFT	Stock	28.04	28.07	28.03	28.045	4830153.0
2013-03-15 13:00:00	MSFT	Stock	28.05	28.105	28.04	28.04	4910429.0
2013-03-15 14:00:00	MSFT	Stock	28.04	28.06	28.03	28.04	7363640.0
2013-03-15 15:00:00	MSFT	Stock	28.05	28.07	28.03	28.06	14672800.0
2013-03-15 16:00:00	MSFT	Stock	28.04	28.15	28.0	28.07	13523444.0
2013-03-15 17:00:00	MSFT	Stock	28.02	28.076	28.02	28.035	183301.0
2013-03-15 18:00:00	MSFT	Stock	28.04	28.04	28.04	28.04	400.0
2013-03-15 19:00:00	MSFT	Stock	28.03	28.03	28.03	28.03	1700.0
2013-03-15 08:00:00	NVDA	Stock	0.3188	0.3188	0.3188	0.3188	80000.0
2013-03-15 09:00:00	NVDA	Stock	0.3188	0.3188	0.315	0.3163	95919720.0
2013-03-15 10:00:00	NVDA	Stock	0.3163	0.318	0.3153	0.3165	36781520.0
2013-03-15 11:00:00	NVDA	Stock	0.3166	0.318	0.3165	0.3166	24824480.0
2013-03-15 12:00:00	NVDA	Stock	0.3166	0.3173	0.3165	0.3165	23108280.0
2013-03-15 13:00:00	NVDA	Stock	0.3165	0.3168	0.3158	0.3159	15093560.0
2013-03-15 14:00:00	NVDA	Stock	0.316	0.3163	0.315	0.3153	38144360.0
2013-03-15 15:00:00	NVDA	Stock	0.3153	0.3165	0.3148	0.3163	70477840.0
2013-03-15 16:00:00	NVDA	Stock	0.3163	0.3173	0.3148	0.3163	50214880.0
2013-03-15 17:00:00	NVDA	Stock	0.3165	0.3165	0.316	0.3163	897040.0
2013-03-15 19:00:00	NVDA	Stock	0.3163	0.3163	0.3163	0.3163	17160.0
2013-03-15 06:00:00	AMZN	Stock	13.294	13.294	13.294	13.294	2000.0
2013-03-15 08:00:00	AMZN	Stock	13.325	13.325	13.306	13.325	84020.0
2013-03-15 09:00:00	AMZN	Stock	13.3175	13.363	13.1825	13.198	27449080.0
2013-03-15 10:00:00	AMZN	Stock	13.1935	13.239	13.1465	13.184	13349300.0
2013-03-15 11:00:00	AMZN	Stock	13.186	13.24	13.1695	13.1765	5016540.0
2013-03-15 12:00:00	AMZN	Stock	13.1735	13.2028	13.1515	13.167	4498240.0
2013-03-15 13:00:00	AMZN	Stock	13.168	13.1729	13.088	13.108	5745100.0
2013-03-15 14:00:00	AMZN	Stock	13.108	13.129	13.0025	13.03	9156440.0
2013-03-15 15:00:00	AMZN	Stock	13.0355	13.0995	13.0332	13.0965	13658880.0
2013-03-15 16:00:00	AMZN	Stock	13.099	13.2004	13.0406	13.1125	16272900.0

> showing 50 of 45,712 rows — these rows as CSV

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