PREVIEW / stock_1hour / 2014-05-30

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-30.parquet
  size:    1.0 MB
  rows:    48,076
  symbols: 3,560

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
2014-05-30 04:00:00	AAPL	Stock	22.7571	22.7682	22.7571	22.7682	16240.0
2014-05-30 05:00:00	AAPL	Stock	22.7768	22.7768	22.74	22.7457	56000.0
2014-05-30 06:00:00	AAPL	Stock	22.7411	22.8196	22.7411	22.8054	527856.0
2014-05-30 07:00:00	AAPL	Stock	22.8	22.8379	22.7214	22.7432	662116.0
2014-05-30 08:00:00	AAPL	Stock	22.75	22.8214	22.7218	22.7486	2027620.0
2014-05-30 09:00:00	AAPL	Stock	22.7486	22.8154	22.6875	22.7557	58596104.0
2014-05-30 10:00:00	AAPL	Stock	22.7557	22.9568	22.7443	22.9339	67612944.0
2014-05-30 11:00:00	AAPL	Stock	22.9357	23.0061	22.9268	22.9561	45338048.0
2014-05-30 12:00:00	AAPL	Stock	22.9593	22.9786	22.6217	22.6989	70279748.0
2014-05-30 13:00:00	AAPL	Stock	22.6964	22.7125	22.4607	22.5969	73413228.0
2014-05-30 14:00:00	AAPL	Stock	22.5994	22.6848	22.5255	22.6175	41137376.0
2014-05-30 15:00:00	AAPL	Stock	22.6184	22.6804	22.5446	22.6071	57308048.0
2014-05-30 16:00:00	AAPL	Stock	22.6068	22.9554	22.5814	22.59	21285152.0
2014-05-30 17:00:00	AAPL	Stock	22.5911	22.616	22.59	22.6061	1025108.0
2014-05-30 18:00:00	AAPL	Stock	22.6004	22.6154	22.5982	22.6125	150864.0
2014-05-30 19:00:00	AAPL	Stock	22.6146	22.625	22.6107	22.625	110544.0
2014-05-30 07:00:00	MSFT	Stock	40.32	40.35	40.32	40.35	750.0
2014-05-30 08:00:00	MSFT	Stock	40.32	40.34	40.25	40.32	16337.0
2014-05-30 09:00:00	MSFT	Stock	40.32	40.54	40.25	40.45	3059958.0
2014-05-30 10:00:00	MSFT	Stock	40.45	40.94	40.43	40.74	6816240.0
2014-05-30 11:00:00	MSFT	Stock	40.74	40.81	40.6	40.67	3385562.0
2014-05-30 12:00:00	MSFT	Stock	40.665	40.8	40.63	40.71	2657616.0
2014-05-30 13:00:00	MSFT	Stock	40.71	40.82	40.675	40.81	1705534.0
2014-05-30 14:00:00	MSFT	Stock	40.805	40.88	40.73	40.8	2268295.0
2014-05-30 15:00:00	MSFT	Stock	40.805	40.97	40.78	40.93	7363750.0
2014-05-30 16:00:00	MSFT	Stock	40.94	40.97	40.34	40.94	5934709.0
2014-05-30 17:00:00	MSFT	Stock	40.94	40.98	40.844	40.98	70853.0
2014-05-30 18:00:00	MSFT	Stock	40.98	40.99	40.94	40.94	10197.0
2014-05-30 19:00:00	MSFT	Stock	40.95	40.96	40.95	40.96	1600.0
2014-05-30 09:00:00	NVDA	Stock	0.4742	0.4748	0.4713	0.4729	16901640.0
2014-05-30 10:00:00	NVDA	Stock	0.4728	0.4756	0.4715	0.4755	44251000.0
2014-05-30 11:00:00	NVDA	Stock	0.4755	0.4763	0.4745	0.4751	24309080.0
2014-05-30 12:00:00	NVDA	Stock	0.4753	0.4758	0.474	0.4742	34906480.0
2014-05-30 13:00:00	NVDA	Stock	0.474	0.4744	0.4713	0.4713	21063880.0
2014-05-30 14:00:00	NVDA	Stock	0.4713	0.4748	0.4713	0.4742	21563680.0
2014-05-30 15:00:00	NVDA	Stock	0.4744	0.476	0.4742	0.4751	44723720.0
2014-05-30 16:00:00	NVDA	Stock	0.475	0.4752	0.4748	0.4749	4174800.0
2014-05-30 17:00:00	NVDA	Stock	0.4752	0.4752	0.4752	0.4752	857200.0
2014-05-30 05:00:00	AMZN	Stock	15.75	15.75	15.75	15.75	6000.0
2014-05-30 06:00:00	AMZN	Stock	15.75	15.75	15.75	15.75	14820.0
2014-05-30 08:00:00	AMZN	Stock	15.8215	15.8215	15.6665	15.6665	32880.0
2014-05-30 09:00:00	AMZN	Stock	15.7115	15.742	15.5195	15.5268	8164380.0
2014-05-30 10:00:00	AMZN	Stock	15.5335	15.5932	15.439	15.455	8599800.0
2014-05-30 11:00:00	AMZN	Stock	15.4505	15.522	15.4175	15.5068	7739420.0
2014-05-30 12:00:00	AMZN	Stock	15.512	15.534	15.4075	15.4235	5409460.0
2014-05-30 13:00:00	AMZN	Stock	15.4265	15.435	15.3785	15.4225	6578360.0
2014-05-30 14:00:00	AMZN	Stock	15.4205	15.505	15.4085	15.488	5302520.0
2014-05-30 15:00:00	AMZN	Stock	15.488	15.6355	15.481	15.6215	15307120.0
2014-05-30 16:00:00	AMZN	Stock	15.6215	15.6306	15.6031	15.6215	19371460.0
2014-05-30 17:00:00	AMZN	Stock	15.6295	15.6295	15.605	15.605	951940.0

> showing 50 of 48,076 rows — these rows as CSV

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