PREVIEW / stock_1hour / 2012-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-23.parquet
  size:    937 KB
  rows:    44,487
  symbols: 3,482

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-10-23 04:00:00	AAPL	Stock	22.5714	22.6071	22.5432	22.5786	138292.0
2012-10-23 05:00:00	AAPL	Stock	22.5607	22.6071	22.5607	22.5679	50764.0
2012-10-23 06:00:00	AAPL	Stock	22.5607	22.5786	22.5004	22.5036	59024.0
2012-10-23 07:00:00	AAPL	Stock	22.5357	22.5714	22.5	22.5296	857472.0
2012-10-23 08:00:00	AAPL	Stock	22.5179	22.5714	22.4457	22.4875	3706248.0
2012-10-23 09:00:00	AAPL	Stock	22.4889	22.5489	22.2686	22.3257	80057796.0
2012-10-23 10:00:00	AAPL	Stock	22.3255	22.4921	22.2821	22.3832	66756508.0
2012-10-23 11:00:00	AAPL	Stock	22.3832	22.3854	22.2014	22.3486	49736344.0
2012-10-23 12:00:00	AAPL	Stock	22.35	22.4918	22.2757	22.4411	41992328.0
2012-10-23 13:00:00	AAPL	Stock	22.4321	22.6393	22.3364	22.4549	109813200.0
2012-10-23 14:00:00	AAPL	Stock	22.4543	22.5357	21.9968	22.2086	196599032.0
2012-10-23 15:00:00	AAPL	Stock	22.2114	22.3179	21.8464	21.9079	135634800.0
2012-10-23 16:00:00	AAPL	Stock	21.9088	22.5081	21.8929	21.9057	13465116.0
2012-10-23 17:00:00	AAPL	Stock	21.9414	21.9921	21.9414	21.9736	600712.0
2012-10-23 18:00:00	AAPL	Stock	21.9679	21.9714	21.9464	21.9643	401324.0
2012-10-23 19:00:00	AAPL	Stock	21.9643	22.0057	21.9625	21.9929	516544.0
2012-10-23 04:00:00	MSFT	Stock	28.04	28.04	28.04	28.04	100.0
2012-10-23 06:00:00	MSFT	Stock	27.78	27.78	27.77	27.77	200.0
2012-10-23 07:00:00	MSFT	Stock	27.8	27.85	27.8	27.8	6080.0
2012-10-23 08:00:00	MSFT	Stock	27.83	27.85	27.75	27.8	116763.0
2012-10-23 09:00:00	MSFT	Stock	27.8	28.08	27.76	28.04	7192742.0
2012-10-23 10:00:00	MSFT	Stock	28.05	28.16	27.86	28.09	14674366.0
2012-10-23 11:00:00	MSFT	Stock	28.09	28.14	27.995	28.02	8692903.0
2012-10-23 12:00:00	MSFT	Stock	28.03	28.09	27.95	28.025	6029717.0
2012-10-23 13:00:00	MSFT	Stock	28.03	28.19	28.02	28.09	5375431.0
2012-10-23 14:00:00	MSFT	Stock	28.095	28.18	28.0	28.11	6069513.0
2012-10-23 15:00:00	MSFT	Stock	28.105	28.2	28.01	28.04	13303279.0
2012-10-23 16:00:00	MSFT	Stock	28.04	28.142	28.0	28.05	1860952.0
2012-10-23 17:00:00	MSFT	Stock	28.04	28.04	28.02	28.04	7104.0
2012-10-23 18:00:00	MSFT	Stock	28.04	28.1	28.04	28.05	3032.0
2012-10-23 19:00:00	MSFT	Stock	28.1	28.1	28.03	28.05	1630.0
2012-10-23 06:00:00	NVDA	Stock	0.297	0.297	0.297	0.297	8000.0
2012-10-23 07:00:00	NVDA	Stock	0.2962	0.2962	0.2962	0.2962	132000.0
2012-10-23 08:00:00	NVDA	Stock	0.2962	0.297	0.2955	0.2958	158600.0
2012-10-23 09:00:00	NVDA	Stock	0.2962	0.2984	0.2955	0.2982	58400080.0
2012-10-23 10:00:00	NVDA	Stock	0.2982	0.3002	0.2965	0.2992	69196840.0
2012-10-23 11:00:00	NVDA	Stock	0.2992	0.3045	0.2988	0.3035	85382400.0
2012-10-23 12:00:00	NVDA	Stock	0.3035	0.309	0.3032	0.3075	90231360.0
2012-10-23 13:00:00	NVDA	Stock	0.3075	0.309	0.3048	0.309	113703800.0
2012-10-23 14:00:00	NVDA	Stock	0.309	0.3103	0.3065	0.3091	72167800.0
2012-10-23 15:00:00	NVDA	Stock	0.3093	0.31	0.3068	0.3083	73463800.0
2012-10-23 16:00:00	NVDA	Stock	0.3083	0.3088	0.3044	0.3088	8459400.0
2012-10-23 17:00:00	NVDA	Stock	0.2992	0.2992	0.2992	0.2992	92000.0
2012-10-23 19:00:00	NVDA	Stock	0.3075	0.3075	0.3075	0.3075	16000.0
2012-10-23 07:00:00	AMZN	Stock	11.6	11.6035	11.6	11.6	11800.0
2012-10-23 08:00:00	AMZN	Stock	11.6	11.689	11.55	11.5675	220600.0
2012-10-23 09:00:00	AMZN	Stock	11.562	11.7145	11.5005	11.709	16017800.0
2012-10-23 10:00:00	AMZN	Stock	11.7065	11.7735	11.5925	11.6681	16097500.0
2012-10-23 11:00:00	AMZN	Stock	11.664	11.7495	11.6495	11.7261	6908540.0
2012-10-23 12:00:00	AMZN	Stock	11.731	11.735	11.6525	11.693	6113700.0

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

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