PREVIEW / stock_1hour / 2013-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-22.parquet
  size:    912 KB
  rows:    42,582
  symbols: 3,505

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-08-22 04:00:00	AAPL	Stock	17.9771	18.0475	17.9771	18.0	29960.0
2013-08-22 05:00:00	AAPL	Stock	18.0225	18.0321	18.0225	18.0268	26600.0
2013-08-22 06:00:00	AAPL	Stock	18.0311	18.0321	18.0311	18.0321	18872.0
2013-08-22 07:00:00	AAPL	Stock	18.0075	18.0671	17.9946	18.0604	373296.0
2013-08-22 08:00:00	AAPL	Stock	18.0571	18.0571	17.9846	18.0493	1409352.0
2013-08-22 09:00:00	AAPL	Stock	18.0482	18.0568	17.8982	17.9296	56119420.0
2013-08-22 10:00:00	AAPL	Stock	17.9296	17.9911	17.8889	17.9523	45924648.0
2013-08-22 11:00:00	AAPL	Stock	17.955	17.9711	17.8168	17.8454	43598156.0
2013-08-22 12:00:00	AAPL	Stock	17.8454	17.8518	17.7929	17.8218	14083244.0
2013-08-22 13:00:00	AAPL	Stock	17.8214	17.8214	17.8214	17.8214	2800.0
2013-08-22 15:00:00	AAPL	Stock	17.8929	18.0036	17.8225	17.9629	67906244.0
2013-08-22 16:00:00	AAPL	Stock	17.9629	17.9821	17.9134	17.9714	12490240.0
2013-08-22 17:00:00	AAPL	Stock	17.9746	17.9821	17.9629	17.9779	238952.0
2013-08-22 18:00:00	AAPL	Stock	17.9754	17.9875	17.9696	17.9707	451220.0
2013-08-22 19:00:00	AAPL	Stock	17.9811	17.9875	17.975	17.9875	260876.0
2013-08-22 06:00:00	MSFT	Stock	32.0	32.04	31.9	32.04	27543.0
2013-08-22 07:00:00	MSFT	Stock	32.0	32.14	32.0	32.1	51801.0
2013-08-22 08:00:00	MSFT	Stock	32.1	32.22	32.01	32.19	62277.0
2013-08-22 09:00:00	MSFT	Stock	32.19	32.3	32.1	32.255	6091792.0
2013-08-22 10:00:00	MSFT	Stock	32.26	32.49	32.2	32.383	6844921.0
2013-08-22 11:00:00	MSFT	Stock	32.38	32.4	32.27	32.36	4795291.0
2013-08-22 12:00:00	MSFT	Stock	32.328	32.37	32.27	32.299	1388693.0
2013-08-22 15:00:00	MSFT	Stock	32.25	32.46	32.13	32.39	7861558.0
2013-08-22 16:00:00	MSFT	Stock	32.39	32.397	32.29	32.3	3739907.0
2013-08-22 17:00:00	MSFT	Stock	32.35	32.4	32.29	32.4	28450.0
2013-08-22 18:00:00	MSFT	Stock	32.39	32.39	32.36	32.39	2275.0
2013-08-22 19:00:00	MSFT	Stock	32.39	32.4	32.39	32.39	2105.0
2013-08-22 08:00:00	NVDA	Stock	0.372	0.372	0.366	0.366	16000.0
2013-08-22 09:00:00	NVDA	Stock	0.3735	0.3775	0.3715	0.3754	24174800.0
2013-08-22 10:00:00	NVDA	Stock	0.3753	0.3763	0.3745	0.3746	36843600.0
2013-08-22 11:00:00	NVDA	Stock	0.3746	0.375	0.3728	0.3733	17590680.0
2013-08-22 12:00:00	NVDA	Stock	0.3732	0.3738	0.373	0.3735	4356160.0
2013-08-22 15:00:00	NVDA	Stock	0.3725	0.3745	0.3725	0.3738	38969320.0
2013-08-22 16:00:00	NVDA	Stock	0.374	0.3741	0.374	0.374	2100600.0
2013-08-22 17:00:00	NVDA	Stock	0.374	0.374	0.374	0.374	382960.0
2013-08-22 08:00:00	AMZN	Stock	14.3	14.3185	14.275	14.277	64020.0
2013-08-22 09:00:00	AMZN	Stock	14.27	14.4	14.231	14.3855	5304960.0
2013-08-22 10:00:00	AMZN	Stock	14.3885	14.433	14.345	14.433	6323600.0
2013-08-22 11:00:00	AMZN	Stock	14.4305	14.4805	14.381	14.4444	5704100.0
2013-08-22 12:00:00	AMZN	Stock	14.4445	14.4595	14.4405	14.442	751260.0
2013-08-22 15:00:00	AMZN	Stock	14.425	14.4935	14.378	14.4875	6719380.0
2013-08-22 16:00:00	AMZN	Stock	14.4865	14.4894	14.4283	14.4894	185380.0
2013-08-22 17:00:00	AMZN	Stock	14.4865	14.4865	14.4865	14.4865	26120.0
2013-08-22 18:00:00	AMZN	Stock	14.5	14.5	14.5	14.5	7360.0
2013-08-22 04:00:00	META	Stock	38.21	38.5	38.21	38.45	1100.0
2013-08-22 05:00:00	META	Stock	38.49	38.49	38.48	38.48	207.0
2013-08-22 06:00:00	META	Stock	38.49	38.49	38.49	38.49	1100.0
2013-08-22 07:00:00	META	Stock	38.45	38.45	38.23	38.37	41149.0
2013-08-22 08:00:00	META	Stock	38.35	38.45	38.3	38.35	119394.0
2013-08-22 09:00:00	META	Stock	38.33	38.75	38.32	38.38	6916682.0

> showing 50 of 42,582 rows — these rows as CSV

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