PREVIEW / stock_1hour / 2012-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-21.parquet
  size:    935 KB
  rows:    43,942
  symbols: 3,463

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
2012-08-21 04:00:00	AAPL	Stock	23.8714	23.9286	23.8232	23.85	235060.0
2012-08-21 05:00:00	AAPL	Stock	23.8614	23.8818	23.8614	23.8679	127960.0
2012-08-21 06:00:00	AAPL	Stock	23.8679	23.9075	23.8679	23.8929	154000.0
2012-08-21 07:00:00	AAPL	Stock	23.8929	23.9232	23.8682	23.9011	1134532.0
2012-08-21 08:00:00	AAPL	Stock	23.9014	23.9757	23.8464	23.9661	5807620.0
2012-08-21 09:00:00	AAPL	Stock	23.9643	24.1029	23.8704	23.9754	135103220.0
2012-08-21 10:00:00	AAPL	Stock	23.9784	24.0054	23.5839	23.6284	141352680.0
2012-08-21 11:00:00	AAPL	Stock	23.6277	23.73	23.4825	23.5643	140291620.0
2012-08-21 12:00:00	AAPL	Stock	23.5675	23.5811	23.3218	23.4218	94454780.0
2012-08-21 13:00:00	AAPL	Stock	23.4214	23.4457	23.2261	23.3611	78958740.0
2012-08-21 14:00:00	AAPL	Stock	23.3636	23.5725	23.3443	23.44	102676980.0
2012-08-21 15:00:00	AAPL	Stock	23.4436	23.5268	23.3036	23.4357	89225696.0
2012-08-21 16:00:00	AAPL	Stock	23.4364	23.7624	23.4236	23.4782	10303244.0
2012-08-21 17:00:00	AAPL	Stock	23.4366	23.5382	23.4307	23.4596	3095456.0
2012-08-21 18:00:00	AAPL	Stock	23.4596	23.4629	23.4286	23.4286	417088.0
2012-08-21 19:00:00	AAPL	Stock	23.4357	23.4429	23.3929	23.4	533708.0
2012-08-21 07:00:00	MSFT	Stock	30.81	30.82	30.81	30.82	478.0
2012-08-21 08:00:00	MSFT	Stock	30.82	30.85	30.82	30.85	6839.0
2012-08-21 09:00:00	MSFT	Stock	30.88	30.88	30.61	30.84	3568821.0
2012-08-21 10:00:00	MSFT	Stock	30.85	30.94	30.8	30.92	4629223.0
2012-08-21 11:00:00	MSFT	Stock	30.92	30.96	30.79	30.809	3641003.0
2012-08-21 12:00:00	MSFT	Stock	30.81	30.828	30.75	30.8	2142908.0
2012-08-21 13:00:00	MSFT	Stock	30.79	30.83	30.735	30.76	3115264.0
2012-08-21 14:00:00	MSFT	Stock	30.76	30.8	30.74	30.78	2566308.0
2012-08-21 15:00:00	MSFT	Stock	30.771	30.81	30.68	30.81	5631860.0
2012-08-21 16:00:00	MSFT	Stock	30.8	30.84	30.63	30.8	2378666.0
2012-08-21 17:00:00	MSFT	Stock	30.8	30.8	30.68	30.75	460449.0
2012-08-21 18:00:00	MSFT	Stock	30.68	30.68	30.68	30.68	700.0
2012-08-21 19:00:00	MSFT	Stock	30.68	30.74	30.68	30.74	900.0
2012-08-21 08:00:00	NVDA	Stock	0.3668	0.367	0.3668	0.367	27600.0
2012-08-21 09:00:00	NVDA	Stock	0.3662	0.3685	0.3662	0.368	21631040.0
2012-08-21 10:00:00	NVDA	Stock	0.368	0.3698	0.3676	0.3688	43120920.0
2012-08-21 11:00:00	NVDA	Stock	0.369	0.369	0.3662	0.3662	50347520.0
2012-08-21 12:00:00	NVDA	Stock	0.3662	0.3672	0.3655	0.3655	30965040.0
2012-08-21 13:00:00	NVDA	Stock	0.3658	0.3658	0.3638	0.3648	32392440.0
2012-08-21 14:00:00	NVDA	Stock	0.3648	0.365	0.3635	0.364	27831880.0
2012-08-21 15:00:00	NVDA	Stock	0.3638	0.3655	0.3615	0.3652	99008520.0
2012-08-21 16:00:00	NVDA	Stock	0.3652	0.3658	0.3645	0.3652	9096360.0
2012-08-21 17:00:00	NVDA	Stock	0.3652	0.3663	0.3642	0.3642	21724000.0
2012-08-21 18:00:00	NVDA	Stock	0.3642	0.3642	0.3642	0.3642	4000.0
2012-08-21 08:00:00	AMZN	Stock	12.029	12.05	12.0195	12.0475	89500.0
2012-08-21 09:00:00	AMZN	Stock	12.06	12.1925	12.0385	12.106	8380600.0
2012-08-21 10:00:00	AMZN	Stock	12.112	12.1365	12.045	12.057	9168420.0
2012-08-21 11:00:00	AMZN	Stock	12.0585	12.074	12.028	12.032	6956580.0
2012-08-21 12:00:00	AMZN	Stock	12.0305	12.0499	11.9805	12.0008	6079200.0
2012-08-21 13:00:00	AMZN	Stock	11.9988	12.001	11.9275	11.9615	5416040.0
2012-08-21 14:00:00	AMZN	Stock	11.9635	11.9965	11.955	11.985	2296360.0
2012-08-21 15:00:00	AMZN	Stock	11.986	12.0095	11.9375	11.9775	9834560.0
2012-08-21 16:00:00	AMZN	Stock	11.9725	12.0383	11.9625	11.9725	2310740.0
2012-08-21 17:00:00	AMZN	Stock	11.9725	11.9725	11.9725	11.9725	544000.0

> showing 50 of 43,942 rows — these rows as CSV

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