PREVIEW / stock_1hour / 2012-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-18.parquet
  size:    933 KB
  rows:    44,134
  symbols: 3,499

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-18 04:00:00	AAPL	Stock	21.7982	21.9089	21.7982	21.8393	263060.0
2012-04-18 05:00:00	AAPL	Stock	21.8071	21.8071	21.6793	21.6889	107800.0
2012-04-18 06:00:00	AAPL	Stock	21.6896	21.7143	21.68	21.6968	112980.0
2012-04-18 07:00:00	AAPL	Stock	21.705	21.7846	21.6811	21.76	554624.0
2012-04-18 08:00:00	AAPL	Stock	21.7629	21.9821	21.6818	21.8368	10933832.0
2012-04-18 09:00:00	AAPL	Stock	21.8389	22.1518	21.8218	22.1237	172257344.0
2012-04-18 10:00:00	AAPL	Stock	22.1249	22.1311	21.8036	21.9607	175409948.0
2012-04-18 11:00:00	AAPL	Stock	21.96	21.9657	21.5254	21.7814	180075532.0
2012-04-18 12:00:00	AAPL	Stock	21.7786	21.78	21.5814	21.6643	67471628.0
2012-04-18 13:00:00	AAPL	Stock	21.6675	21.7093	21.5435	21.5857	54826800.0
2012-04-18 14:00:00	AAPL	Stock	21.5857	21.9664	21.5636	21.9179	133294812.0
2012-04-18 15:00:00	AAPL	Stock	21.9174	21.9771	21.7182	21.7229	126985264.0
2012-04-18 16:00:00	AAPL	Stock	21.7239	21.9287	21.4989	21.6036	20233780.0
2012-04-18 17:00:00	AAPL	Stock	21.6036	21.6775	21.6036	21.6439	913024.0
2012-04-18 18:00:00	AAPL	Stock	21.6536	21.6536	21.5714	21.5893	482468.0
2012-04-18 19:00:00	AAPL	Stock	21.5893	21.6068	21.5664	21.6068	834428.0
2012-04-18 07:00:00	MSFT	Stock	31.28	31.28	31.01	31.18	6622.0
2012-04-18 08:00:00	MSFT	Stock	31.19	31.29	31.19	31.22	9359.0
2012-04-18 09:00:00	MSFT	Stock	31.25	31.31	31.05	31.125	5136214.0
2012-04-18 10:00:00	MSFT	Stock	31.13	31.25	31.09	31.175	5270016.0
2012-04-18 11:00:00	MSFT	Stock	31.17	31.25	31.07	31.18	4854118.0
2012-04-18 12:00:00	MSFT	Stock	31.19	31.22	31.04	31.09	3549962.0
2012-04-18 13:00:00	MSFT	Stock	31.085	31.2	31.06	31.1	3567092.0
2012-04-18 14:00:00	MSFT	Stock	31.09	31.24	31.08	31.184	2969076.0
2012-04-18 15:00:00	MSFT	Stock	31.185	31.21	31.09	31.13	6843129.0
2012-04-18 16:00:00	MSFT	Stock	31.13	31.186	31.05	31.13	8235471.0
2012-04-18 17:00:00	MSFT	Stock	31.14	31.16	31.13	31.16	11200.0
2012-04-18 18:00:00	MSFT	Stock	31.17	31.17	31.17	31.17	1000.0
2012-04-18 19:00:00	MSFT	Stock	31.17	31.21	31.17	31.19	1600.0
2012-04-18 08:00:00	NVDA	Stock	0.349	0.349	0.349	0.349	18000.0
2012-04-18 09:00:00	NVDA	Stock	0.3482	0.349	0.3425	0.3475	77760000.0
2012-04-18 10:00:00	NVDA	Stock	0.3474	0.3495	0.3448	0.3493	84121240.0
2012-04-18 11:00:00	NVDA	Stock	0.3493	0.3493	0.3469	0.3473	43157240.0
2012-04-18 12:00:00	NVDA	Stock	0.3475	0.3475	0.3458	0.3466	41129560.0
2012-04-18 13:00:00	NVDA	Stock	0.3468	0.3475	0.3453	0.3458	18973840.0
2012-04-18 14:00:00	NVDA	Stock	0.3458	0.3493	0.3455	0.3493	17536440.0
2012-04-18 15:00:00	NVDA	Stock	0.3493	0.35	0.3462	0.3465	93523200.0
2012-04-18 16:00:00	NVDA	Stock	0.3468	0.3468	0.345	0.3465	21925880.0
2012-04-18 17:00:00	NVDA	Stock	0.345	0.345	0.345	0.345	148000.0
2012-04-18 06:00:00	AMZN	Stock	9.349	9.349	9.349	9.349	2000.0
2012-04-18 07:00:00	AMZN	Stock	9.4065	9.4065	9.4005	9.4005	8000.0
2012-04-18 08:00:00	AMZN	Stock	9.4145	9.45	9.4145	9.42	269800.0
2012-04-18 09:00:00	AMZN	Stock	9.421	9.6125	9.4055	9.6005	14349840.0
2012-04-18 10:00:00	AMZN	Stock	9.6025	9.6725	9.581	9.6125	14820900.0
2012-04-18 11:00:00	AMZN	Stock	9.6125	9.6235	9.5415	9.6035	12284740.0
2012-04-18 12:00:00	AMZN	Stock	9.6045	9.621	9.5755	9.6018	7460380.0
2012-04-18 13:00:00	AMZN	Stock	9.6025	9.636	9.5905	9.602	7058060.0
2012-04-18 14:00:00	AMZN	Stock	9.602	9.667	9.585	9.648	7578120.0
2012-04-18 15:00:00	AMZN	Stock	9.6495	9.6575	9.553	9.5535	12170140.0
2012-04-18 16:00:00	AMZN	Stock	9.5535	9.61	9.503	9.61	3836480.0

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

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