PREVIEW / stock_1hour / 2013-04-10

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-10.parquet
  size:    985 KB
  rows:    45,393
  symbols: 3,502

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-04-10 04:00:00	AAPL	Stock	15.2893	15.2893	15.2893	15.2893	2800.0
2013-04-10 06:00:00	AAPL	Stock	15.3143	15.3143	15.3143	15.3143	5600.0
2013-04-10 07:00:00	AAPL	Stock	15.315	15.3304	15.27	15.2832	156604.0
2013-04-10 08:00:00	AAPL	Stock	15.2857	15.3293	15.2143	15.2507	1836856.0
2013-04-10 09:00:00	AAPL	Stock	15.2568	15.3429	15.2146	15.2696	54188456.0
2013-04-10 10:00:00	AAPL	Stock	15.2646	15.4479	15.2418	15.4246	85434272.0
2013-04-10 11:00:00	AAPL	Stock	15.4239	15.5511	15.4093	15.5268	65256408.0
2013-04-10 12:00:00	AAPL	Stock	15.5257	15.5786	15.4879	15.5664	38411912.0
2013-04-10 13:00:00	AAPL	Stock	15.5639	15.5754	15.5289	15.5578	30270520.0
2013-04-10 14:00:00	AAPL	Stock	15.5582	15.5832	15.5221	15.5552	33352900.0
2013-04-10 15:00:00	AAPL	Stock	15.5557	15.6093	15.5271	15.5632	53885076.0
2013-04-10 16:00:00	AAPL	Stock	15.5604	15.6247	15.2459	15.5411	8278032.0
2013-04-10 17:00:00	AAPL	Stock	15.5411	15.5604	15.5375	15.5414	307300.0
2013-04-10 18:00:00	AAPL	Stock	15.5386	15.5482	15.5382	15.5386	113736.0
2013-04-10 19:00:00	AAPL	Stock	15.54	15.54	15.5271	15.5357	229880.0
2013-04-10 05:00:00	MSFT	Stock	29.65	29.65	29.65	29.65	200.0
2013-04-10 07:00:00	MSFT	Stock	29.65	29.68	29.53	29.65	5700.0
2013-04-10 08:00:00	MSFT	Stock	29.67	29.7	29.54	29.65	197086.0
2013-04-10 09:00:00	MSFT	Stock	29.67	29.95	29.52	29.87	7629952.0
2013-04-10 10:00:00	MSFT	Stock	29.87	30.3	29.87	30.28	17580643.0
2013-04-10 11:00:00	MSFT	Stock	30.285	30.32	30.14	30.15	13274533.0
2013-04-10 12:00:00	MSFT	Stock	30.155	30.29	30.13	30.256	4989861.0
2013-04-10 13:00:00	MSFT	Stock	30.25	30.27	30.16	30.2	4599654.0
2013-04-10 14:00:00	MSFT	Stock	30.2	30.275	30.145	30.173	5518826.0
2013-04-10 15:00:00	MSFT	Stock	30.18	30.28	30.035	30.28	11949976.0
2013-04-10 16:00:00	MSFT	Stock	30.28	30.3	29.61	29.94	2765164.0
2013-04-10 17:00:00	MSFT	Stock	29.97	30.28	29.77	29.79	155475.0
2013-04-10 18:00:00	MSFT	Stock	29.79	29.79	29.61	29.64	64969.0
2013-04-10 19:00:00	MSFT	Stock	29.65	29.74	29.65	29.73	27411.0
2013-04-10 09:00:00	NVDA	Stock	0.316	0.3175	0.3153	0.3175	23760760.0
2013-04-10 10:00:00	NVDA	Stock	0.3173	0.3193	0.3165	0.3193	55236280.0
2013-04-10 11:00:00	NVDA	Stock	0.3193	0.3195	0.317	0.3173	37735600.0
2013-04-10 12:00:00	NVDA	Stock	0.3173	0.3195	0.3173	0.3188	31678360.0
2013-04-10 13:00:00	NVDA	Stock	0.319	0.32	0.3183	0.32	41444200.0
2013-04-10 14:00:00	NVDA	Stock	0.32	0.3213	0.3198	0.3202	45889120.0
2013-04-10 15:00:00	NVDA	Stock	0.3203	0.3213	0.3195	0.3205	126032360.0
2013-04-10 16:00:00	NVDA	Stock	0.3208	0.3208	0.3193	0.32	20068320.0
2013-04-10 17:00:00	NVDA	Stock	0.3208	0.3208	0.3208	0.3208	194280.0
2013-04-10 05:00:00	AMZN	Stock	13.102	13.102	13.102	13.102	2000.0
2013-04-10 07:00:00	AMZN	Stock	13.1	13.11	13.1	13.108	16000.0
2013-04-10 08:00:00	AMZN	Stock	13.1095	13.11	13.05	13.089	166140.0
2013-04-10 09:00:00	AMZN	Stock	13.064	13.1	12.966	13.055	7968260.0
2013-04-10 10:00:00	AMZN	Stock	13.0565	13.16	13.0545	13.1485	9861620.0
2013-04-10 11:00:00	AMZN	Stock	13.15	13.199	13.139	13.1872	5305900.0
2013-04-10 12:00:00	AMZN	Stock	13.189	13.264	13.1644	13.2618	6372020.0
2013-04-10 13:00:00	AMZN	Stock	13.261	13.2864	13.239	13.259	4021560.0
2013-04-10 14:00:00	AMZN	Stock	13.2585	13.299	13.2355	13.2475	3980260.0
2013-04-10 15:00:00	AMZN	Stock	13.248	13.253	13.2215	13.243	6667660.0
2013-04-10 16:00:00	AMZN	Stock	13.245	13.245	13.1476	13.2208	352180.0
2013-04-10 17:00:00	AMZN	Stock	13.2385	13.2425	13.2375	13.2425	60800.0

> showing 50 of 45,393 rows — these rows as CSV

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