PREVIEW / stock_1hour / 2011-12-22

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-22.parquet
  size:    925 KB
  rows:    44,214
  symbols: 3,536

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
2011-12-22 04:00:00	AAPL	Stock	14.1429	14.2114	14.1429	14.1936	16800.0
2011-12-22 05:00:00	AAPL	Stock	14.1429	14.1454	14.1429	14.1454	14000.0
2011-12-22 06:00:00	AAPL	Stock	14.1489	14.1536	14.1432	14.1536	22400.0
2011-12-22 07:00:00	AAPL	Stock	14.1625	14.1964	14.1557	14.1964	202916.0
2011-12-22 08:00:00	AAPL	Stock	14.1925	14.2179	14.1786	14.1786	1837500.0
2011-12-22 09:00:00	AAPL	Stock	14.1839	14.2454	14.1464	14.2196	42170520.0
2011-12-22 10:00:00	AAPL	Stock	14.2232	14.2393	14.1986	14.2139	32787468.0
2011-12-22 11:00:00	AAPL	Stock	14.2136	14.2318	14.2007	14.2107	20255984.0
2011-12-22 12:00:00	AAPL	Stock	14.2139	14.2546	14.2093	14.2471	25852988.0
2011-12-22 13:00:00	AAPL	Stock	14.2475	14.2518	14.2332	14.2364	12801208.0
2011-12-22 14:00:00	AAPL	Stock	14.2386	14.2411	14.2154	14.226	18406080.0
2011-12-22 15:00:00	AAPL	Stock	14.2268	14.2404	14.2161	14.2311	34050884.0
2011-12-22 16:00:00	AAPL	Stock	14.2304	14.2382	14.1587	14.2375	9521260.0
2011-12-22 17:00:00	AAPL	Stock	14.2097	14.2454	14.2097	14.2454	280448.0
2011-12-22 18:00:00	AAPL	Stock	14.2414	14.2461	14.2343	14.245	140728.0
2011-12-22 19:00:00	AAPL	Stock	14.2461	14.25	14.2364	14.2436	370020.0
2011-12-22 04:00:00	MSFT	Stock	25.78	25.78	25.78	25.78	150.0
2011-12-22 06:00:00	MSFT	Stock	25.8	25.8	25.8	25.8	995.0
2011-12-22 07:00:00	MSFT	Stock	25.8	25.8	25.8	25.8	4005.0
2011-12-22 08:00:00	MSFT	Stock	25.85	25.85	25.76	25.77	22250.0
2011-12-22 09:00:00	MSFT	Stock	25.77	25.89	25.6	25.67	5659002.0
2011-12-22 10:00:00	MSFT	Stock	25.669	25.72	25.54	25.62	5975922.0
2011-12-22 11:00:00	MSFT	Stock	25.62	25.75	25.619	25.69	5276772.0
2011-12-22 12:00:00	MSFT	Stock	25.7	25.8	25.69	25.755	3162075.0
2011-12-22 13:00:00	MSFT	Stock	25.755	25.8	25.7	25.76	3650263.0
2011-12-22 14:00:00	MSFT	Stock	25.76	25.81	25.73	25.785	3359230.0
2011-12-22 15:00:00	MSFT	Stock	25.79	25.82	25.73	25.81	5739605.0
2011-12-22 16:00:00	MSFT	Stock	25.805	25.83	25.63	25.79	2133086.0
2011-12-22 17:00:00	MSFT	Stock	25.8	25.82	25.78	25.82	2235.0
2011-12-22 18:00:00	MSFT	Stock	25.81	25.84	25.81	25.84	6000.0
2011-12-22 19:00:00	MSFT	Stock	25.85	25.89	25.83	25.83	7467.0
2011-12-22 06:00:00	NVDA	Stock	0.3475	0.3475	0.3475	0.3475	29200.0
2011-12-22 07:00:00	NVDA	Stock	0.3475	0.3482	0.3475	0.3482	24000.0
2011-12-22 08:00:00	NVDA	Stock	0.344	0.344	0.344	0.344	44000.0
2011-12-22 09:00:00	NVDA	Stock	0.3445	0.3538	0.344	0.352	64948400.0
2011-12-22 10:00:00	NVDA	Stock	0.352	0.3533	0.3498	0.3508	112907160.0
2011-12-22 11:00:00	NVDA	Stock	0.3508	0.3551	0.3508	0.355	92043440.0
2011-12-22 12:00:00	NVDA	Stock	0.355	0.3575	0.3542	0.3575	71336320.0
2011-12-22 13:00:00	NVDA	Stock	0.3575	0.3585	0.3568	0.3579	34329480.0
2011-12-22 14:00:00	NVDA	Stock	0.358	0.3581	0.3555	0.3555	84889920.0
2011-12-22 15:00:00	NVDA	Stock	0.3555	0.3588	0.355	0.3575	100072480.0
2011-12-22 16:00:00	NVDA	Stock	0.3576	0.3582	0.3545	0.3575	12851560.0
2011-12-22 17:00:00	NVDA	Stock	0.3582	0.3598	0.3582	0.3598	135560.0
2011-12-22 19:00:00	NVDA	Stock	0.359	0.3592	0.3578	0.3578	88000.0
2011-12-22 07:00:00	AMZN	Stock	8.8	8.8	8.7845	8.7845	6000.0
2011-12-22 08:00:00	AMZN	Stock	8.7725	8.7965	8.7305	8.733	273100.0
2011-12-22 09:00:00	AMZN	Stock	8.7475	8.865	8.7105	8.83	17347220.0
2011-12-22 10:00:00	AMZN	Stock	8.827	8.9395	8.825	8.9215	20344580.0
2011-12-22 11:00:00	AMZN	Stock	8.92	8.9835	8.9175	8.954	13169600.0
2011-12-22 12:00:00	AMZN	Stock	8.9535	8.975	8.936	8.9415	7430600.0

> showing 50 of 44,214 rows — these rows as CSV

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