PREVIEW / stock_1hour / 2012-05-25

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-25.parquet
  size:    910 KB
  rows:    43,584
  symbols: 3,513

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-05-25 04:00:00	AAPL	Stock	20.25	20.3357	20.25	20.3	81200.0
2012-05-25 06:00:00	AAPL	Stock	20.3104	20.3104	20.2321	20.2321	50400.0
2012-05-25 07:00:00	AAPL	Stock	20.2857	20.2857	20.2321	20.2436	277480.0
2012-05-25 08:00:00	AAPL	Stock	20.25	20.2946	20.0911	20.1429	2321872.0
2012-05-25 09:00:00	AAPL	Stock	20.1361	20.2089	19.9679	20.0632	69020532.0
2012-05-25 10:00:00	AAPL	Stock	20.0604	20.0919	19.9832	19.9907	54048820.0
2012-05-25 11:00:00	AAPL	Stock	19.9936	20.0429	19.9454	19.9719	39566268.0
2012-05-25 12:00:00	AAPL	Stock	19.9719	20.0189	19.9518	19.9929	29564416.0
2012-05-25 13:00:00	AAPL	Stock	19.9911	20.1239	19.9768	20.0596	39230548.0
2012-05-25 14:00:00	AAPL	Stock	20.0604	20.0643	19.9893	20.0186	27086696.0
2012-05-25 15:00:00	AAPL	Stock	20.02	20.0893	20.0107	20.0818	55658736.0
2012-05-25 16:00:00	AAPL	Stock	20.0818	20.19	20.0209	20.0879	8686132.0
2012-05-25 17:00:00	AAPL	Stock	20.0879	20.1004	20.0804	20.0893	122108.0
2012-05-25 18:00:00	AAPL	Stock	20.0825	20.0868	20.0786	20.0832	144340.0
2012-05-25 19:00:00	AAPL	Stock	20.0854	20.0893	20.0804	20.0893	425208.0
2012-05-25 08:00:00	MSFT	Stock	29.19	29.2	29.07	29.07	17315.0
2012-05-25 09:00:00	MSFT	Stock	29.1	29.36	29.1	29.31	3548313.0
2012-05-25 10:00:00	MSFT	Stock	29.3	29.33	29.05	29.06	5648014.0
2012-05-25 11:00:00	MSFT	Stock	29.06	29.18	29.06	29.155	3033527.0
2012-05-25 12:00:00	MSFT	Stock	29.155	29.19	29.1	29.17	2649778.0
2012-05-25 13:00:00	MSFT	Stock	29.16	29.2	29.13	29.198	2212013.0
2012-05-25 14:00:00	MSFT	Stock	29.2	29.22	29.08	29.095	3208968.0
2012-05-25 15:00:00	MSFT	Stock	29.09	29.14	29.01	29.05	6239348.0
2012-05-25 16:00:00	MSFT	Stock	29.05	29.148	29.01	29.06	2515384.0
2012-05-25 17:00:00	MSFT	Stock	29.06	29.06	29.06	29.06	100.0
2012-05-25 18:00:00	MSFT	Stock	29.04	29.04	29.04	29.04	200.0
2012-05-25 19:00:00	MSFT	Stock	29.06	29.06	29.04	29.04	900.0
2012-05-25 08:00:00	NVDA	Stock	0.305	0.305	0.305	0.305	24000.0
2012-05-25 09:00:00	NVDA	Stock	0.3035	0.3113	0.3025	0.308	65059920.0
2012-05-25 10:00:00	NVDA	Stock	0.3088	0.3105	0.3073	0.309	51959400.0
2012-05-25 11:00:00	NVDA	Stock	0.309	0.3113	0.309	0.3103	41063720.0
2012-05-25 12:00:00	NVDA	Stock	0.31	0.3105	0.3085	0.3098	20409960.0
2012-05-25 13:00:00	NVDA	Stock	0.3096	0.3125	0.3093	0.312	29476480.0
2012-05-25 14:00:00	NVDA	Stock	0.312	0.3125	0.31	0.3104	22758160.0
2012-05-25 15:00:00	NVDA	Stock	0.3103	0.3118	0.3095	0.31	90499000.0
2012-05-25 16:00:00	NVDA	Stock	0.31	0.311	0.3098	0.31	68956160.0
2012-05-25 17:00:00	NVDA	Stock	0.3103	0.3103	0.3103	0.3103	4000.0
2012-05-25 18:00:00	NVDA	Stock	0.3103	0.3103	0.3103	0.3103	24000.0
2012-05-25 19:00:00	NVDA	Stock	0.3108	0.3108	0.3108	0.3108	4000.0
2012-05-25 04:00:00	AMZN	Stock	10.8	10.8	10.8	10.8	2000.0
2012-05-25 05:00:00	AMZN	Stock	10.795	10.8	10.795	10.8	6000.0
2012-05-25 08:00:00	AMZN	Stock	10.765	10.765	10.725	10.725	82000.0
2012-05-25 09:00:00	AMZN	Stock	10.7025	10.799	10.7	10.7435	4888920.0
2012-05-25 10:00:00	AMZN	Stock	10.7435	10.756	10.65	10.6535	8339260.0
2012-05-25 11:00:00	AMZN	Stock	10.65	10.6919	10.65	10.662	5926920.0
2012-05-25 12:00:00	AMZN	Stock	10.66	10.691	10.6575	10.6715	4438020.0
2012-05-25 13:00:00	AMZN	Stock	10.671	10.715	10.6545	10.684	3826880.0
2012-05-25 14:00:00	AMZN	Stock	10.6835	10.6865	10.6225	10.624	4339580.0
2012-05-25 15:00:00	AMZN	Stock	10.625	10.6595	10.611	10.6445	7924100.0
2012-05-25 16:00:00	AMZN	Stock	10.6445	10.6798	10.6345	10.6445	3216840.0

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

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