PREVIEW / stock_1hour / 2012-04-16

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-16.parquet
  size:    927 KB
  rows:    44,080
  symbols: 3,527

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-04-16 04:00:00	AAPL	Stock	21.5671	21.5982	21.5536	21.5893	64400.0
2012-04-16 05:00:00	AAPL	Stock	21.6036	21.6214	21.5982	21.6214	28000.0
2012-04-16 06:00:00	AAPL	Stock	21.6929	21.7125	21.6761	21.6804	125272.0
2012-04-16 07:00:00	AAPL	Stock	21.6786	21.7321	21.6561	21.6782	967820.0
2012-04-16 08:00:00	AAPL	Stock	21.6771	21.8389	21.6554	21.7786	6858796.0
2012-04-16 09:00:00	AAPL	Stock	21.7786	21.8	20.7964	20.9946	237174028.0
2012-04-16 10:00:00	AAPL	Stock	20.9929	21.3168	20.9132	21.1971	217893704.0
2012-04-16 11:00:00	AAPL	Stock	21.1954	21.2276	20.9396	21.0125	107963772.0
2012-04-16 12:00:00	AAPL	Stock	21.0071	21.0892	20.8929	20.9918	87340624.0
2012-04-16 13:00:00	AAPL	Stock	20.9975	21.0064	20.8171	20.9225	95912936.0
2012-04-16 14:00:00	AAPL	Stock	20.9222	21.0375	20.8489	20.9107	85743112.0
2012-04-16 15:00:00	AAPL	Stock	20.9087	20.9211	20.6518	20.7375	172631200.0
2012-04-16 16:00:00	AAPL	Stock	20.7246	21.6154	20.7168	20.75	21790804.0
2012-04-16 17:00:00	AAPL	Stock	20.7468	20.7664	20.7346	20.7639	683620.0
2012-04-16 18:00:00	AAPL	Stock	20.7589	20.7643	20.7232	20.7246	473816.0
2012-04-16 19:00:00	AAPL	Stock	20.725	20.725	20.6832	20.6875	640052.0
2012-04-16 07:00:00	MSFT	Stock	30.9	30.9	30.9	30.9	500.0
2012-04-16 08:00:00	MSFT	Stock	31.02	31.02	30.9	30.9	9660.0
2012-04-16 09:00:00	MSFT	Stock	30.9	31.13	30.86	31.0	3651164.0
2012-04-16 10:00:00	MSFT	Stock	30.99	31.0	30.77	30.95	6376825.0
2012-04-16 11:00:00	MSFT	Stock	30.945	30.97	30.85	30.86	3154406.0
2012-04-16 12:00:00	MSFT	Stock	30.87	31.04	30.86	31.04	2951080.0
2012-04-16 13:00:00	MSFT	Stock	31.04	31.16	30.99	31.12	3632432.0
2012-04-16 14:00:00	MSFT	Stock	31.125	31.19	31.08	31.089	3799874.0
2012-04-16 15:00:00	MSFT	Stock	31.08	31.16	31.02	31.09	7659060.0
2012-04-16 16:00:00	MSFT	Stock	31.085	31.13	30.81	31.09	5854363.0
2012-04-16 17:00:00	MSFT	Stock	31.09	31.09	31.09	31.09	6772.0
2012-04-16 18:00:00	MSFT	Stock	31.09	31.1	31.09	31.1	300.0
2012-04-16 19:00:00	MSFT	Stock	31.15	31.16	31.01	31.16	5210.0
2012-04-16 08:00:00	NVDA	Stock	0.3565	0.3585	0.356	0.357	220000.0
2012-04-16 09:00:00	NVDA	Stock	0.3568	0.358	0.3478	0.3478	71340440.0
2012-04-16 10:00:00	NVDA	Stock	0.3478	0.3515	0.344	0.3498	121265680.0
2012-04-16 11:00:00	NVDA	Stock	0.3499	0.35	0.3462	0.3473	46661240.0
2012-04-16 12:00:00	NVDA	Stock	0.3475	0.3488	0.345	0.346	44431760.0
2012-04-16 13:00:00	NVDA	Stock	0.346	0.3489	0.346	0.3485	51432640.0
2012-04-16 14:00:00	NVDA	Stock	0.3485	0.3515	0.348	0.3502	34165280.0
2012-04-16 15:00:00	NVDA	Stock	0.35	0.3508	0.3488	0.3498	86565920.0
2012-04-16 16:00:00	NVDA	Stock	0.3498	0.3502	0.3493	0.3495	827640.0
2012-04-16 17:00:00	NVDA	Stock	0.3498	0.3498	0.3498	0.3498	36000.0
2012-04-16 18:00:00	NVDA	Stock	0.3498	0.3498	0.3495	0.3498	320000.0
2012-04-16 06:00:00	AMZN	Stock	9.451	9.451	9.4505	9.4505	6000.0
2012-04-16 08:00:00	AMZN	Stock	9.4245	9.4795	9.4245	9.475	69520.0
2012-04-16 09:00:00	AMZN	Stock	9.488	9.503	9.269	9.279	14573940.0
2012-04-16 10:00:00	AMZN	Stock	9.2789	9.3135	9.1825	9.3005	17340080.0
2012-04-16 11:00:00	AMZN	Stock	9.2995	9.3245	9.2255	9.2373	8595520.0
2012-04-16 12:00:00	AMZN	Stock	9.2385	9.282	9.233	9.2696	6458360.0
2012-04-16 13:00:00	AMZN	Stock	9.266	9.325	9.258	9.288	9368360.0
2012-04-16 14:00:00	AMZN	Stock	9.287	9.3335	9.261	9.31	7926140.0
2012-04-16 15:00:00	AMZN	Stock	9.31	9.315	9.254	9.274	13548020.0
2012-04-16 16:00:00	AMZN	Stock	9.275	9.423	9.257	9.2769	2728540.0

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

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